A dica de hoje é bem simples, criei este script para auxiliar a obter as informações:
1- Listar todos os databases e versões.
2- Listar todos os pdbs e status existentes em todos os databases em execução:
Shell script:
for ORACLE_SID in `ps -e -o "cmd" | grep smon|grep -v grep|awk '!/ASM/'| awk -F "_" '{print$3}'`
do
ORAENV_ASK=NO
export ORAENV_ASK
export ORACLE_SID
echo $ORACLE_SID
. /usr/local/bin/oraenv >/dev/null 2>&1
sqlplus -S / as sysdba <<< 'set heading off
select instance_name,VERSION from gv$instance;';
sqlplus -S / as sysdba <<< '
show pdbs;';
echo ""
echo "========================================================="
echo ""
doneResultado:
oragbl101
oragbl101 19.0.0.0.0
oragbl102 19.0.0.0.0
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 ORADSV06 READ WRITE NO
4 ORAHML09 READ WRITE NO
=========================================================
orahml031
orahml031 11.2.0.4.0
orahml032 11.2.0.4.0
SP2-0158: unknown SHOW option "pdbs"
=========================================================
oradsv021
oradsv021 11.2.0.4.0
oradsv022 11.2.0.4.0
SP2-0158: unknown SHOW option "pdbs"
=========================================================
oradsv011
oradsv011 11.2.0.4.0
oradsv012 11.2.0.4.0
SP2-0158: unknown SHOW option "pdbs"
=========================================================
orahml021
orahml021 11.2.0.4.0
orahml022 11.2.0.4.0
SP2-0158: unknown SHOW option "pdbs"
=========================================================
oragbl041
oragbl041 12.2.0.1.0
oragbl042 12.2.0.1.0
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 ORAHML08 READ WRITE NO
=========================================================
orapocvrd1
orapocvrd1 19.0.0.0.0
orapocvrd2 19.0.0.0.0
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 HML READ WRITE NO
4 TEMPLATE_WIN1252 READ WRITE NO
5 ORADSV07 READ WRITE NO
6 PDB_RAID READ WRITE NO
7 HML_ORAPRD10 READ WRITE NO
8 ORADSV08 MOUNTED
=========================================================