#!/usr/bin/bash
ORACLE_HOME=/u02/app/oracle/product/19.0.0.0/dbhome_1
for v_inst in `ps -ef| grep pmon | awk '{print $8}' | grep -iv asm | grep -iv apx | awk -F"_" '{print $3}'`
do
echo "Instance name = $v_inst"
export ORACLE_SID=$v_inst
# Fetch the list of PDBs (excluding the Seed PDB)
# We use -S (silent) to keep the output clean for the loop
PDB_LIST=$(sqlplus -S / as sysdba <<EOF
SET HEAD OFF FEEDBACK OFF PAGES 0
SELECT name FROM v\$pdbs WHERE name != 'PDB\$SEED';
EXIT;
EOF
)
echo "----------------------------------------------------"
echo "Iterating through PDBs for SID: $ORACLE_SID"
echo "----------------------------------------------------"
for PDB in $PDB_LIST
do
echo "Checking PDB: $PDB"
sqlplus -S / as sysdba <<EOF
set lines 120 pages 200
ALTER SESSION SET CONTAINER = $PDB;
SHOW CON_NAME;
EXIT;
EOF
echo "----------------------------------------------------"
done
done
Tutornet.US — Source of excellent learning
One-page flyer for Facebook and LinkedIn. Download the image to share.