#!/bin/bash
# Roda NO nfs01. Mede a baseline do banco do Multiseg antes do corte.
K=/tmp/svc_mig.key
DB=20.0.20.120
ssh -o StrictHostKeyChecking=no -i $K svc_ansible@$DB 'bash -s' <<'REMOTE'
echo "=== /etc/oratab"
grep -v "^#" /etc/oratab | grep -v "^$"
echo "=== instancias no ar"
ps -ef | grep -o "ora_pmon_[a-zA-Z0-9]*" | sort -u
echo "=== dbora.service"
systemctl is-enabled dbora 2>/dev/null; systemctl is-active dbora 2>/dev/null
echo "=== consultas"
SID=$(ps -ef | grep -o "ora_pmon_[a-zA-Z0-9]*" | head -1 | sed s/ora_pmon_//)
echo "ORACLE_SID detectado: $SID"
sudo su - oracle -c "unset ORACLE_PDB_SID; export ORACLE_SID=$SID; 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 heading on linesize 200
select 'CON_NAME='||sys_context('USERENV','CON_NAME') from dual;
select 'LOG_MODE='||log_mode||' OPEN='||open_mode from v$database;
select 'PDB='||name||' '||open_mode from v$pdbs;
alter session set container=SANKHYAPDB;
select 'EMPRESAS='||count(*) from multisegprd.tgfemp;
select 'USUARIOS='||count(*) from multisegprd.tsiusu;
select 'TGFCAB='||count(*) from multisegprd.tgfcab;
select 'TGFITE='||count(*) from multisegprd.tgfite;
select 'IPSERVACESS='||texto from multisegprd.tsipar where chave='IPSERVACESS';
select 'DATAFILES='||count(*) from cdb_data_files;
exit
SQL
REMOTE