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
216
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
0
votes
4
answers
329
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
114
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
53
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
414
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
403
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
198
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 ...
- 103
0
votes
1
answer
72
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
262
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
1k
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
973
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
570
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
515
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 ...
- 23
0
votes
1
answer
472
views
Installing Oracle Java in Red Hat Enterprise Linux
I am seeking advice on a solution for updating Oracle Java in a large number of hosts -
We have a large number of RHEL hosts, and we would like to use yum update rather than rpm install for upgrading ...
- 101
0
votes
1
answer
4k
views
Oracle cloud compute change ssh port fails
I am new to cloud computing and plan to use an always free compute service from Oracle Cloud to obtain a public IP address to run a website. As a basic security measure I require my machines to not ...
- 11
1
vote
0
answers
381
views
Installing Oracle JDK using Ansible
I've been researching this for a while and it seems that installing an Oracle JDK rather than OpenJDK through Ansible is much more troublesome due to licensing from Oracle.
I've found some community ...
- 57
1
vote
0
answers
311
views
Oracle will not start after VM crash
My Oracle 11gR2, running on a VM, crashed when the datastore of the host filled up. I got the VM to start and as I'm trying to start the DB, I see this:
Connected to an idle instance.
SQL> startup
...
- 11
0
votes
1
answer
266
views
Trouble adding CNAME record for WAF to a hostname that already has an A record
I have a domain (for instance, example.com) that points to certain IP direction (type A record), and DNS system is controlled by my organization. Now, a new web app has been published at news.example....
1
vote
0
answers
356
views
How to add static IPv6 in Oracle cloud
I am running OS Ubuntu 18.4.
I will add static ipv6 address with netplan in Oracle cloud my netplan yaml file looks like this:
network:
version: 2
renderer: networkd
ethernets:
enp0s3:
...
- 11
1
vote
0
answers
2k
views
Disk disappeared after umount and reboot
I had a disk which disappeared:
# df -h
Filesystem Size Used Avail Use% Mounted on
.
.
/dev/mapper/vg1-osblv02 5.0T 61G 4.7T 2% /data/osb-pool-1
/dev/mapper/vg01-osblv01 ...
- 133
0
votes
1
answer
1k
views
How to connect oracle database docker image
I have registered with the docker image of oracle database and got below link to pull the image.
docker pull store/oracle/database-enterprise:12.2.0.1
No other tags available to see on the page. But ...
- 541