Monday, April 22, 2024

grep for all database names in /etc/oratab

›
The file /etc/oratab contains: # mydb01:/orainst/product/19c:Y cdb:/orainst/product/19c:N To extract the database names: grep "^[^#]...
Thursday, April 18, 2024

Solution to script warning: here-document at line < num > delimited by end-of-file (wanted `!')

›
In a script, I had formatted my code as follows: for l in $(cat file.txt|grep 'Status'| awk -F' ' '{print $2}')...
Wednesday, April 17, 2024

Solution to ORA-28547: connection to server failed, probable Oracle Net admin error

›
When trying to perform sqlplus actions against one of my databases, I received oracle@oric-dbserver01:[mydb01]# sqlplus / as sysdba SQL*P...

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