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
1 vote
2 answers
87 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 ...
1 vote
2 answers
7k views

Escape all characters that shell or sqlplus need escaped in any password given

You may try for yourself by creating this user: CREATE USER "karl" IDENTIFIED BY "/?'!@#$%^&*()_+=-~`" (Maybe there are other symbols I should have included for my testing, but that seemed ...
0 votes
0 answers
18 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 ...
0 votes
0 answers
36 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 ...
0 votes
0 answers
16 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 %{...
0 votes
0 answers
65 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 votes
0 answers
27 views

How to configure client DNS parameters on an oracle 8 distribution?

Using an ansible playbook I add DNS addresses in linux distributions and I would like to know how to configure DNS clients on Oracle 8. I tried to use the ansible playbook to configure them, I would ...
2 votes
2 answers
5k views

Can't start WebLogic admin console

I'm wondering how to fix this error. We had the wrong Java installed on my machine when I got it, so my boss installed JRocket to fix things. WebLogic has been having problems ever since. I cannot ...
3 votes
1 answer
4k views

ORA-12705: invalid or unknown NLS parameter value specified

I have a J2EE application hosted on JBoss on Linux. When I try to access the application, I see following error in the server.log file. ORA-12705: invalid or unknown NLS parameter value specified ...
1 vote
0 answers
55 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-...
1 vote
1 answer
7k views

Unable to convert JKS keystore to Oracle Wallet using orapki

I have generated jks keystore using keytool and using the jks keystore I have csr. The same csr I have sent to Signing authority. The Signing authority have given the trusted certificates(root,...
0 votes
2 answers
104 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. ...
0 votes
2 answers
49 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
166 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: ...
8 votes
2 answers
7k views

Oracle 10g for Windows does not start up on system boot

We have an Oracle 10g Enterprise Edition installation (10.2.0.1.0) on a Windows Server 2003 virtual machine. It was initially created with Virtual Server 2005 R2 SP1 but has now been migrated to ...
-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 ...
1 vote
0 answers
77 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 ...
0 votes
1 answer
260 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
211 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 ...
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 ...
0 votes
1 answer
96 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 ...
0 votes
0 answers
73 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 ...
0 votes
1 answer
292 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
150 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 ...
2 votes
3 answers
14k views

Can't install kernel-uek-headers for currently running kernel

I have just created a VM in VMWare and installed a minimal install of Oracle Enterprise Linux 6.3. # cat /etc/oracle-release Oracle Linux Server release 6.3 It is running with the UEK kernel. # ...
0 votes
1 answer
804 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 ...
0 votes
0 answers
180 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: ...
0 votes
1 answer
4k views

Oracle 11g MTS install fails with error: OUI - 10150: Error: A runtime exception occurred while setting s_dlgCfgNamingLabelSIDnull

Is there a workaround in the Oracle 11g Universal Installer for the following error? OUI - 10150: Error: A runtime exception occurred while setting s_dlgCfgNamingLabelSIDnull in component oracle ...
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 ...
2 votes
1 answer
11k views

What's the difference between an instance and a server process in Oracle database?

What is the difference between an instance and a server process, and what are their respective lifecycles?
16 votes
4 answers
114k views

Oracle difference between SID, DB Name, DB Domain, Global Database Name, Service Name, Service Alias and Instance Name

What's the difference of SID, DB Name, DB Domain, Global Database Name, Service Name, Service Alias and Instance Name in Oracle ?
2 votes
0 answers
54 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 ...
0 votes
1 answer
120 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-...
3 votes
3 answers
6k views

SELinux is preventing Perl CGI script from accessing Oracle libraries

I'm trying to configure SELinux on a Red Hat Enterprise Linux 6.2 web server that runs Apache 2.2.15 and Perl 5.10.1, and connects to remote Oracle databases. The Oracle 11.2g client is installed. The ...
0 votes
4 answers
270 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 (...
1 vote
0 answers
194 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 ...
0 votes
0 answers
625 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 ...
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)
1 vote
3 answers
4k views

Oracle 10g: backup failed, log disk full - how do I recover the database?

Because of failed backups, the disk used for transaction logs appears to be full. The database is not accepting connections, so I cannot run the (HP Data Protector) backup job manually. The Oracle ...
0 votes
3 answers
2k views

How do I set up Weblogic 12c on Windows to start the http server on boot?

Windows 2008 server, Weblogic 12c. I have a pretty simple setup using nodemanager. My problem is that our webhost likes to patch and reboot the server without telling us, and the HTTP server doesn't ...
0 votes
1 answer
373 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
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 ...
0 votes
1 answer
232 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....
1 vote
1 answer
3k views

Weblogic server hangs when "Creating data source connection pool named"

I have just installed Weblogic version 10.3.6.0 and created a data source which connects to MSSQL on my localhost. I have tested my connection and verified that a successful connection can be made ...
1 vote
1 answer
2k views

Unable to connect to Oracle database from certain client machines

I have an application that connects to an Oracle database that works fine in development on any development machine I can find but falls over with the following error when being ran from a production ...
0 votes
1 answer
2k views

Exception thrown when trying to access a web service (Weblogic) - java.lang.LinkageError

I've installed Adobe LiveCycle for Weblogic 10.3.4, and when I try to access one of the web services it deployed, I'm getting the following exception: Exception - java.lang.LinkageError: loader ...
0 votes
1 answer
2k views

Is it possible to migrate Oracle SOA BPEL instances from one environment to another with history

Is it possible to migrate Oracle SOA BPEL instances from one environment to another with history? For instance, I want to move from BPEL instances deployed to defined partition on Oracle SOA to ...
1 vote
1 answer
2k views

One Way Replication of Oracle 11g to MSSQL 2008R2

We're in the midst of a major LOB system change which will use Oracle 11g, but we need to maintain a LARGE number of existing reports in SSRS. What is a good method to automate a one-way, read-only ...
2 votes
2 answers
4k views

Oracle: Getting ORA-01195 and ORA-01110 when attempting resetlogs

I am trying to get our database to startup. When I login to sqlplus and do a startup, I get the message: Total System Global Area 534462464 bytes Fixed Size 2215064 bytes Variable ...
2 votes
2 answers
5k views

Powershell execute Queries using SQLPLUS

I have a RHEL server with Oracle 10G installed. I need to write a powershell script to query my database and get the output. I have imported Posh-SSH module and am able to connect to my RHEL server ...

1
2 3 4 5
18