runon_allcdbs_find_pdbs.sql

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