Category: Oracle

#!/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

#!/usr/bin/bash
ORACLE_BASE=/u02/app/oracle
ORACLE_HOME=/u02/app/oracle/product/19.0.0.0/dbhome_1
LOGNAME=runon_all_localdb_$$.log

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
 $ORACLE_HOME/bin/sqlplus "/ as sysdba" << EOF >> ${LOGNAME}
 show user
 set echo off
 set numwidth 9
 set linesize 132
 set pagesize 300
 set feedback off
 set verify off
 set time off
 set timing off
 --select * from v\$instance;
 @/u02/scripts/paresh/find_pdbs.sql
 --select PROPERTY_VALUE from database_properties where PROPERTY_NAME='DEFAULT_TEMP_TABLESPACE';
EOF
done

cat ${LOGNAME}

rm ${LOGNAME}