#!/bin/bash
# Roda NO nfs01. Para o Oracle do Multiseg como CDB (nao so o PDB).
K=/tmp/svc_mig.key; DB=20.0.20.120
ssh -o StrictHostKeyChecking=no -i $K svc_ansible@$DB 'bash -s' <<'REMOTE'
echo "=== sessoes de usuario antes de parar"
sudo su - oracle -c "unset ORACLE_PDB_SID; export ORACLE_SID=sankhyacdb; export ORACLE_HOME=/database/app/oracle/product/21.0.0/dbhome_1; \$ORACLE_HOME/bin/sqlplus -S / as sysdba" <<'SQL'
set pagesize 0 feedback off
select 'SESSOES_USUARIO='||count(*) from v$session where type='USER' and username is not null;
exit
SQL
echo "=== shutdown immediate (CDB\$ROOT)"
sudo su - oracle -c "unset ORACLE_PDB_SID; export ORACLE_SID=sankhyacdb; export ORACLE_HOME=/database/app/oracle/product/21.0.0/dbhome_1; \$ORACLE_HOME/bin/sqlplus -S / as sysdba" <<'SQL'
select 'CONTAINER='||sys_context('USERENV','CON_NAME') from dual;
shutdown immediate
exit
SQL
echo "=== listener"
sudo su - oracle -c "export ORACLE_HOME=/database/app/oracle/product/21.0.0/dbhome_1; \$ORACLE_HOME/bin/lsnrctl stop" 2>&1 | tail -3
echo "=== processos oracle restantes (tem que ser zero)"
ps -ef | grep -c "[o]ra_pmon"
echo "=== filesystems montados"
df -h /database /database-backup | tail -2
REMOTE