Wednesday, April 17, 2024

Solution to [FATAL] [DBT-05509] Failed to connect to the specified database (cdb) in dbca

›
I was attempting to create a container database using dbca like this: dbca -createDatabase -responsefile /home/oracle/scripts/cdb.rsp -sil...

My solution to ORA-12701: CREATE DATABASE character set is not known

›
Some of our Oracle servers are set up to accommodate EBS. During the provisioning process of a new oracle server, the Oracle database crea...

A scriptlet that will look for a file and when found, start displaying it using tail

›
A short script that will look for the existence of a file, and when found, start tailing it to std out: while true; do if [ -f /u01/crea...
Saturday, April 13, 2024

How to open the PDB$SEED database for patching in read/write mode

›
The following should only be done if you need to patch the PDB$SEED using datapatch, or under instructions from Oracle Support. sqlplus /...
Friday, April 12, 2024

How to process a variable consisting of values separated by blank spaces using a for-loop construct in shell scripting

›
If you have a variable with to or more values, separated by space, it's very simple to loop through them and process them individually...
Tuesday, April 9, 2024

How to extract the the first of two identical sentences in a log file using awk

›
I have a log file which repeats the same message twice. I would like to save this message in a variable to use later in the script. The f...

How to trim away all extra output from a result using sqlplus

›
The following code can be put in a shell script and executed by root. Note the sqlplus directives which will remove all unwanted output fr...