Thursday, March 7, 2024

How to solve TNS-01194: The listener command did not arrive in a secure transport

›
On one of my servers running Oracle 19c with a container database and a PDB, I had trouble getting the services to automatically register t...
Wednesday, March 6, 2024

How to remove all postgres packages on a Linux RH server

›
Logged in as root on the server you would like to remove all postgres packages from: Stop and disable the current postgres services (in th...
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...