Questions tagged [oracle]
Oracle is a relational DBMS (Database Management System) created by Oracle Corporation. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java. Most questions about Oracle are better placed at the sister site https://dba.stackexchange.com/
874 questions
1 vote
0 answers
86 views
Oracle 19c throwing error combination ORA-31011 ORA-19213 LPX-00007
Our 19c Oracle installation throws errors in several situations: Trying to connect with DBeaver Querying e.g. SELECT * FROM ALL_OBJECTS Running SQL> @?/rdbms/admin/utlrp.sql other 3rd party ...
- 111
0 votes
0 answers
31 views
REMAP_DATAFILE not working during Data Pump import on Oracle 19c
I'm trying to import a full database dump using impdp into a different Oracle 19c (Standard Edition 2) environment, but the REMAP_DATAFILE parameter doesn't seem to be working. My goal is to import a ...
- 111
0 votes
0 answers
132 views
Workspace's URL not working on 19000 port in EPM 11.2.15
We have installed and configured EPM 11.2.15 with foundation and FR components successfully. Workpsace url is up and running with 28080 port. Weblogic url with 7001 is also running fine. But having ...
0 votes
1 answer
2k views
Where can I download Oracle Database 12c?
I need to install Oracle Database 12c on my local machine, but I’m unable to find a working download link. The official Oracle website seems to have removed or restricted access to older versions. I’...
- 3
1 vote
0 answers
47 views
Oracle Secure Backup 10.4.0.4.0: "UUID Not Found" Error Preventing observiced from Functioning
I'm encountering an issue with Oracle Secure Backup (OSB) version 10.4.0.4.0 on an Oracle Linux 6.2 system. The observiced service is running, but it's consistently logging the following error: can't ...
- 11
0 votes
0 answers
65 views
check oracle opera server
Currently, I am learning IT and working at a hotel that requires the use of the Opera server. I have been asked to check information such as Oracle-database-version, Oracle-patch, Opera-version, Opera-...
1 vote
0 answers
225 views
ORA-19504: failed to create file. A file cannot be larger than the value set by ulimit
When restoring Oracle database in RMAN on AIX I get the error: =================================================== RMAN Progress Status Report at 2025-02-06 20:51:33 ===================================...
- 11
1 vote
1 answer
81 views
Unable to connect between Oracle compute instances
I manage several Oracle cloud compute instances (all Ubuntu servers) located in different regions. All VMs have iptables set to allow ingress traffic on port 22, and the same ingress rules are applied ...
- 113
2 votes
1 answer
2k views
Oracle 23AI cannot connect to database as newly created user
I installed Oracle 23AI free database and I'm attempting to create a new user and connect to the database as that user. I'm using Sql Developer to connect to the database. After connecting to the ...
0 votes
0 answers
77 views
WLS: Connections Leaked - inactive sessions are not closed, despite of Inactive Connection Timeout
I have a Java web application running with the following setup: Java Web application Oracle WebLogic (14.1.1.) Oracle Database We have noticed that the DB User (Schema) seems to have leaked ...
0 votes
0 answers
259 views
Nginx custom domain proxy server for Oracle APEX app not working properly
I am using Nginx as proxy server for my Oracle APEX App. When I run my custom domain mycustomdomain.com my APEX app home page opens but I have 3 problems: First time opening in browser mycustomdomain....
- 1
1 vote
0 answers
227 views
Oracle Linux allows individual packages to be updated but not all
Running sudo yum update -y, returns error "You need to update rpm to handle: rpmlib (PayloadIsZstd) <= 5.4.18-1", even though rpm -Va --nofiles --nodigest has been run with no output. I ...
- 113
0 votes
0 answers
223 views
Unable to perform unattended installation of Oracle Database 19.3.0 on Windows 10
During an unattended installation of Oracle Database 19.3.0 on Windows 10, the following error occurs: "SEVERE: PRCZ-1082 : Failed to add Windows user or Windows group "REG-XSPY-NUM12$" ...
0 votes
1 answer
179 views
Custom changes in Core DNS (Kube-DNS) in OKE (Oracle Cloud Kubernetes) are reverted automatically after one day
I have created an Enhanced Cluster of Kubernetes (OKE) in Oracle Cloud (OCI). Some cluster pods connect to VM instances outside OKE but in the same VCN subnet as the pods. I want these connections to ...
- 101
0 votes
1 answer
418 views
python: oracledb ignores position of positional bind valuedoes not bind positional values correctly
i want to update a table in oracle using python3 with oracledb and positional values. A simple example, which is not working: sql = "update table set col1 = :2, col2 = :3 where id = :1" ...
- 1
1 vote
0 answers
162 views
Delete OCI Compartments
I'm trying to delete unwanted OCI compartments, but can't seem to do it. When I look in Tenancy Explorer, the compartments are empty. The only thing I can find is: Log Groups in compartment shows ...
- 111
0 votes
0 answers
346 views
TNS error while connecting to an Oracle DB running as ACI through an Azure Application Gateway
I have an Oracel DB runnning as an Azure Container Instance. To connect to the container, I set up an Azure Applicaiton Gateway as described here: Expose a static IP address for a container group Now ...
- 1
0 votes
1 answer
3k views
Oracle 19c installation on Rhel9 amd RHEL 8 difference
When I run Oracle installation using automation on rhel9, I get following error. I am using db_19.22.0.0.240228.zip Launching Oracle Database Setup Wizard... [FATAL] [INS-35955] The Database software ...
- 1
1 vote
0 answers
339 views
How to enable SQL trace for AWS Oracle RDS
To enable sql trace under Oracle you would typically run the following via sqlplus after login: ALTER SESSION SET SQL_TRACE=TRUE On Oracle 19 RDS this results in the following: Error report - ORA-...
- 11
0 votes
2 answers
176 views
Setting up sftp/ftp for OCI wordpress
I’ve been following the oracle tutorial for setting up wordpress (https://docs.oracle.com/en-us/iaas/developer-tutorials/tutorials/wp-on-ubuntu/01-summary.htm), now when I want to download a theme, it ...
0 votes
1 answer
533 views
Connecting to Oracle Autonomous Database with PHP and OCI8
I'm using Oracle Cloud Infrastructure. I have a VM instance with Ubuntu-22.04-Minimal. Apache, PHP, and OCI8 are all installed and working. When I try to connect to the database I get: Warning: ...
- 111
1 vote
0 answers
147 views
Forward DNS does not work. BIND and DIG find nothing
The company's DC is in the Oracle Cloud, and I connect it to the companies via IPSec, and foward the DNS via Domain Override in pfSense or Bind9. I recently picked up a Dream Machine from Ubiquiti to ...
-1 votes
2 answers
147 views
Looking for Firmware for Oracle Dual 40 Gb Ethernet Adapter
I purchased an Oracle Dual 40 Gb Ethernet Adapter - documentation here. The card was sold to me as pure Intel. I realised it was OEM after I installed the card and checked it on Linux, but meanwhile ...
- 1
0 votes
1 answer
943 views
Oracle Linux 8 to 9 in place upgrade with Leapp fails with XFS internal log size 8192 too large, must be less than 4789
Can someone please help? 2023-11-14 09:25:01.774 DEBUG PID: 308200 leapp.workflow.InterimPreparation.dnf_dry_run: External command has finished: ['/bin/dd', 'if=/dev/zero', 'of=/var/lib/leapp/...
1 vote
1 answer
609 views
Updating vulnerable python packages on Oracle Linux 8.8
I have a number of Oracle Linux 8.8 machines and Crowdstrike is flagging all of them for vulnerabilities associated with the python packages installed with python 3.6. Oracle says python 3.6 is ...
- 11
0 votes
0 answers
65 views
Importing mysql database into Oracle OCI Ubuntu instance
I recently spun up a Ubuntu instance on Oracle OCI (https://cloud.oracle.com) to host a Laravel application. I need to be able to import a large-ish mysql database, but every time I try, it hangs up ...
- 101
0 votes
2 answers
280 views
Can`t get Oracle SAS SSDs to work in HP Z640
I got a pair of SAS SSDs from a decomissioned Oracle server. Model name LB1606R SUN1.6T. I want to use them in HP Z640 workstation (running Windows 10 Pro) so I bought HP LSI 9217-4i4e SAS controller. ...
- 109
0 votes
1 answer
707 views
restarting Oracle 23c within the docker container causes blocked listener
I am using the Free Oracle 23c Docker container (see here) to help provision a development environment. As part of the configuration of the environment, I am putting scripts and SQL into /docker-...
0 votes
0 answers
336 views
Errors installing Oracle 19 on Windows 11 Business
I'm trying to install Oracle 19.30.00 on a brand new Windows 11 Business machine. I tried several times choosing a different user to run the Oracle service (virtual, built-in, create new) but every ...
- 101
0 votes
1 answer
510 views
How to determine what CVE is back ported to what version of package?
I'm trying to determine what version of apache is backported for CVE-2021-40438. I'm very confused as to how to find out. Our spacewalk server has multiple apache versions of 2.4.37 from -10 to -56 ...
- 1
0 votes
1 answer
2k views
Migrate and upgrade Oracle 12.1.0.2 to 19c: UDI-00018: Data Pump client is incompatible with database version 12.1.0.2.0
Migrating Oracle 12.1.0.2 server to Oracle 19.13.0.0 Enterprise using a new virtual machine. I set up Oracle 19, and it seems to be running fine. Now I want to import on dump from the Oracle 12 server ...
- 11
2 votes
0 answers
79 views
trouble with Oracle Sun SAS 6GB/s pci-e drivers
I got a new card for my server, a Sun SAS card (SG-XPCIESAS-GEN2-Z), and now I cannot get it to work. I tried many LSI drivers, many Adaptec drivers, but none work, some even crash. Card P/N is ...
- 21
0 votes
1 answer
234 views
Failed to create keys in the OLR, rc = 100 on windows server
I am installing Oracle 19c RAC on windows server 2019. I have 4 servers, domain controller： pc name = dc storage: pc name = st node1: pc name = node1 node2: pc name = node2 I have done all the pre-...
- 101
1 vote
0 answers
287 views
How to change Public Key in Oracle Cloud
I have CentOS running on AMD and Ubuntu running on ARM services on Oracle cloud. Previously, I shared my private key (used for connecting SSH/Putty) with my freelance developer. However, over a month ...
- 199
0 votes
0 answers
1k views
oracle19c - Port 1521 open on remote VM and visible in netstat, but cannot ping with telnet
I am running into some issues while trying to access a remove oracle db 19.3. The VM (CentOS 7) is located inside GCP Cloud and I can ping it on other ports (22), but i cannot connect to the database ...
google-cloud-platform
0 votes
1 answer
3k views
Permission denied (publickey) when try ssh into Oracle Cloud
I downloaded two keys ssh-key-2023-02-09.key and ssh-key-2023-02-09.key.pub. I did chmod 400 ssh-key-2023-02-09.key ssh -i ssh-key-2023-02-09.key user@ip Permission denied (publickey)
- 101
0 votes
1 answer
765 views
Can Oracle GoldenGate work between different version of Oracle
Can we use Oracle GoldenGate to sync data between different versions of Oracle ? Our source database is 11.2.0.4 and target is 19.0.0.0
- 161
0 votes
1 answer
301 views
Modular Dependency in my Docker "dnf module enabled -y php:7.4 php-oci8"
So I'm running a command dnf module enabled -y php:7.4 php-oci8 but I'm getting a Modular Dependency Problem, this was not an issue before. Problem: module php-oci8:21c:8060020221011134100:34611983....
- 101
0 votes
4 answers
652 views
Oracle 19c database session unstable with Azure Load Balancer
We are trying to implement a HA setup with an Oracle database in Azure, somewhat as described in DBAKevlar's white paper and Oracle HA in Azure - Options. Our setup includes an Oracle Data Guard pair (...
- 31
1 vote
2 answers
163 views
Is quorum disk required for standalone installations?
A provider is setting up a single bare-metal Oracle server for us, which will not be part of any grid or cluster. It has over 20 disks connected via fiber to a SAN, each 1TB. OVM is installed on a ...
- 151
0 votes
0 answers
67 views
When creating a VM, memory keeps filling up, and never finishes installation
I'm using VirtualBox to get started with Oracle Database. I downloaded Database App Development VM and tried to import it into VB, but every time I try, it stops with the error [0x80070057]. I read ...
0 votes
1 answer
549 views
Access from one network to another through cloud WireGuard server
Please need your help with WireGuard & network configuring. I am trying to get access from Office network to Field network through Oracle Cloud WireGuard server. Please take a look on the picture. ...
- 11
0 votes
2 answers
575 views
Oracle cloud - Connect to Windows instance with disabled ethernet
As I was troubleshooting the network connection of my Windows instance, I managed to disable the OCI Ethernet adapter, which makes it impossible to connect to the instance through RDP. I've have ...
1 vote
0 answers
231 views
Tunneling a LEMP server through an oracle instance with wireguard. Cannot get Nginx Certbot certificates on LEMP server. How to debug?
I have a LEMP server at home running Ubuntu 22.02 and an Oracle cloud instance running Ubuntu 20.04. The Oracle cloud instance is acting as a Wireguard server. The LEMP server at home is acting as the ...
- 163
0 votes
1 answer
92 views
Instance in OIC lost public IP
I have two instances in OIC free tier. I saw that I cant connect to either server with SSH. I logged in to web ui and see both instances running, but they lack Public IP. These IPs where assigned at ...
- 21
0 votes
2 answers
313 views
Oracle Cloud Native Environment setup with Vault faild on validating host names in certificate
I'm setting up OLCNE environment with Hashicorp Vault PKI, I successfully install agent, setup vault, certificates was generated but during module createion I have error that host name not match ...
- 101
0 votes
1 answer
2k views
ORA-210000 Oracle error: ORA-12154: TNS:could not resolve the connect identifier specified
I am trying to setup a connection from my rhel 7.9 machine to my oracle host db on windows server 2016 running oracle 19c. 04:25:36 - ORA-210000 Oracle error: ORA-12154: TNS:could not resolve the ...
- 235
0 votes
0 answers
1k views
Compatible way to bind to 169.254.169.254?
I have an application which I can't change, running in a docker container on a bare metal server (no cloud environment) It tries to connect to 169.254.169.254 (fetching IMDSv2 metadata). This ip / the ...
- 203
0 votes
1 answer
740 views
Unable to connect to Oracle database 21c
I have fresh Oracle Linux with Oracle Database 21c installed on it. Issue is I cannot connect to it from the outside, locally there is no problem. lsof was showing that port 1521 was open only for ...
- 1
0 votes
1 answer
724 views
SQL Developer PL/SQL script fails to display output over OpenVPN after running a certain amount of time
The Problem: When I try to run gather stats over OpenVPN on my Oracle 19c database, SQL Developer doesn't return the typical "PL/SQL procedure successfully completed" message if it runs for ...
- 33