Thursday, February 29, 2024

What does it mean to run autoconfig on an EBS DB tier?

›
In a nutshell, it means running adautocfg.sh on the database server. This is what I did when the listener.ora was missing on one of my EBS...
Friday, February 9, 2024

Script snipplet to test for subdirectories

›
echo "Test: are there subdirectories in /orainst/oracle/cfgtoollogs/dbca/cdb ?" ls $(pwd)/*/ > /dev/null 2>&1 if [ $?...
Thursday, February 8, 2024

Script snipplet to scan the dbca logs for errors

›
Here is a way to scan the logs in the directory where dbca creates its logfiles, by default under your $ORACLE_BASE/cfgtoollogs/dbca/$ORACL...

Script to check for the number of control files in a database and create minimum two if only one is found

›
A script that checks for the number of controlfiles and creates two new ones if only one is found. # 080224: Created # Check if there i...
Wednesday, January 31, 2024

How come I cannot logon to my instance as sysdba, when the ORACLE_SID variable is set correctly?

›
Here's a reminder if you use a symbolic link for your ORACLE_HOME variable: You will not be able to attach to your instance using OS a...
Saturday, January 27, 2024

Solution to ERRORMSG: Invalid SYSTEM database user credential when running txkPostPDBCreationTasks.pl as a part of an EBS database upgrade

›
When upgrading an EBS database from version 12c to 19c, you have to convert to the mulitenant architechture. Oracle supplies script for t...
Friday, January 26, 2024

How to find installed patches through SQL in an EBS database

›
During an EBS upgrade, I had to check whether or not a specific patch, 8796558, still needed to be applied. Turned out is no longer releva...