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/

Filter by
Sorted by
Tagged with
0 votes
0 answers
31 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 ...
Harley's user avatar
  • 101
0 votes
0 answers
34 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 ...
Scivic's user avatar
  • 1
0 votes
0 answers
47 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 ...
linusrg's user avatar
0 votes
0 answers
20 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 %{...
Red's user avatar
  • 1
0 votes
1 answer
148 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 ...
Daniel's user avatar
  • 1
1 vote
0 answers
71 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-...
Craig's user avatar
  • 11
0 votes
2 answers
62 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 ...
ProbablyIdiot's user avatar
0 votes
1 answer
191 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: ...
Harley's user avatar
  • 101
1 vote
0 answers
80 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 ...
Raphael Aracelli's user avatar
-1 votes
2 answers
110 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 ...
cygent's user avatar
  • 1
0 votes
1 answer
320 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/...
Kerry KRAMMERSANDSTRUM's user avatar
1 vote
1 answer
241 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 ...
bangheadhere's user avatar
0 votes
0 answers
43 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 ...
mpemburn's user avatar
  • 101
0 votes
2 answers
112 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. ...
Jurkstas's user avatar
  • 109
0 votes
0 answers
83 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 ...
Mido's user avatar
  • 1
0 votes
1 answer
312 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-...
simonalexander2005's user avatar
0 votes
0 answers
159 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 ...
ValeryC's user avatar
  • 101
0 votes
1 answer
109 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 ...
Scivic's user avatar
  • 1
0 votes
1 answer
898 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 ...
csmj's user avatar
  • 11
0 votes
0 answers
188 views

Issue when switching from networkd to NetworkManager

On an Ubuntu 22.04 instance on Google Cloud, I can switch from networkd to NetworkManager like this: $ sudo apt install network-manager $ sudo nano /etc/netplan/50-cloud-init.yaml # add: network: ...
triatic's user avatar
  • 35
0 votes
0 answers
29 views

AZURE Skytap Oracle db environment showing block corruption

We are seeing redo, undo and datafile block corruptions when we restore using RMAN into Azure Skytap from our source servers. This is a reoccurring issue. As soon as we fix it in one place, it sems to ...
Michael Ault's user avatar
2 votes
0 answers
55 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 ...
M B's user avatar
  • 21
0 votes
1 answer
125 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-...
shenhengbin's user avatar
1 vote
0 answers
198 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 ...
Mehul Kumar's user avatar
0 votes
0 answers
654 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 ...
Flavian Rotaru's user avatar
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)
shwick's user avatar
  • 101
0 votes
1 answer
393 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
oradbanj's user avatar
  • 161
0 votes
1 answer
233 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....
Vincent Dapiton's user avatar
0 votes
4 answers
279 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 (...
Tony's user avatar
  • 31
1 vote
2 answers
94 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 ...
miturbe's user avatar
  • 151
0 votes
0 answers
48 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 ...
Patricio Marino's user avatar
0 votes
1 answer
390 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. ...
Sergey's user avatar
  • 11
0 votes
2 answers
343 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 ...
user19407495's user avatar
1 vote
0 answers
193 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 ...
DanRan's user avatar
  • 93
0 votes
1 answer
71 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 ...
Martin Smith's user avatar
0 votes
2 answers
233 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 ...
Adam Wyżgoł's user avatar
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 ...
David Garcia's user avatar
0 votes
0 answers
911 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 ...
MRalwasser's user avatar
0 votes
1 answer
542 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 ...
Kenicram's user avatar
0 votes
1 answer
478 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 ...
js1018's user avatar
  • 23
0 votes
1 answer
394 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 ...
Head and toes's user avatar
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 ...
Currn Hyde's user avatar
1 vote
0 answers
346 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 ...
Ress's user avatar
  • 45
1 vote
0 answers
284 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 ...
GID's user avatar
  • 11
0 votes
1 answer
255 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....
madprofessor's user avatar
1 vote
0 answers
342 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: ...
Myra Sewitz's user avatar
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 ...
kunz's user avatar
  • 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 ...
Sara June's user avatar
  • 521
1 vote
1 answer
245 views

Oracle database - solaris 10 9/10 where is i can find

We have Oracle tech login but cannot find the elusive Solaris 10 9-10 SW load iso file. We have just about everything else for Sol 10 .... and can't restore a an ORACLE DATABASE backup without it to ...
Thắng Đặng Văn's user avatar
-1 votes
1 answer
1k views

Users and Roles Extraction in Oracle

I've tried to write a query to have a users/roles extraction, i don't have much SQL skills as well as on oracle, so I started with this: SELECT A.GRANTEE, A.GRANTED_ROLE, B.ACCOUNT_STATUS FROM ...
bind2lrz's user avatar

1
2 3 4 5
18