Questions tagged [oracle]

Question 1

We have an application behind a OCI Load Balancer, when the LB redirects to the server, it adds the port number, for instance: the cliente calls https://myapplication.com the LB redirects to the ...

Question 2

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 ...

Question 3

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 ...

Question 4

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 ...

Question 5

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’...

Question 6

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 ...

Question 7

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-...

Question 8

When restoring Oracle database in RMAN on AIX I get the error: =================================================== RMAN Progress Status Report at 2025-02-06 20:51:33 ===================================...

Question 9

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 ...

Question 10

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 ...

Question 11

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 ...

Question 12

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$" ...

Question 13

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 ...

Question 14

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" ...

Question 15

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 ...

Question 16

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 ...

Question 17

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 ...

Question 18

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-...

Question 19

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 ...

Question 20

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: ...

Question 21

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 ...

Question 22

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 ...

Question 23

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/...

Question 24

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 ...

Question 25

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 ...

Question 26

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. ...

Question 27

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-...

Question 28

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 ...

Question 29

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 ...

Question 30

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 ...

Question 31

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 ...

Question 32

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-...

Question 33

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 ...

Question 34

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 ...

Question 35

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)

Question 36

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

Question 37

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....

Question 38

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 (...

Question 39

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 ...

Question 40

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 ...

Question 41

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. ...

Question 42

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 ...

Question 43

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 ...

Question 44

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 ...

Question 45

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 ...

Question 46

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 ...

Question 47

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 ...

Question 48

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 ...

Question 49

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 ...

Question 50

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 ...