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/
866
questions
0
votes
0
answers
15
views
Issue: oracle linux UI goes black
I'm using the oracle linux verison
Linux localhost.localdomain 5.15.0-207.156.6.el9uek.x86_64 #2 SMP Thu Jun 6 02:32:40 PDT 2024 x86_64 x86_64 x86_64 GNU/Linux
I'm facing the issue, whenever I try to ...
0
votes
0
answers
26
views
Oracle Linux 9.4 Display Issue
I have Two server running oracle linux 9.4
1st one is working good if i connect display.
2nd one have flicker issue or Display is totally black even though i upgrade the firmware, app update ,drivers ...
- 1
0
votes
1
answer
67
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
65
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
0
votes
0
answers
54
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 ...
- 101
0
votes
0
answers
56
views
Updating lodash to the latest version to resolve a handful of vulnerabilities
I'm attempting to update lodash and have run several commands;
npm update -g lodash
npm update lodash --force
I've ran npm cache clean --force but nothing. Many of the lodash modules are outdated ...
- 1
0
votes
0
answers
101
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
0
answers
50
views
OHS and ProxyPass and RewriteRule / RedirectMatch
i've setted up this virtualhost,
<VirtualHost *:443>
ServerName test.domain.org
DocumentRoot "/u02/config/www/tst-12c"
RewriteEngine on
RewriteCond %{...
- 1
0
votes
1
answer
588
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
121
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
87
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
280
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: ...
- 101
1
vote
0
answers
95
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
120
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
659
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
336
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
49
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
144
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
0
answers
116
views
OBIEE 12 c RCU installation stuck on DB connection
I am trying to install OBIEE 12c on DB 12c using a VM box.
I have finished all perquisites steps and stuck on RCU step when entering connection parameters.
Here is the error message:
Unable to connect ...
- 1
0
votes
1
answer
383
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
196
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
161
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
1k
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
60
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
143
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
217
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 ...
- 189
0
votes
0
answers
765
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
2k
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
457
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
247
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