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