set linesize 200 set pagesize 500 spool /tmp/Oct29.html set markup html on set numwidth 40 select * from emp; set long 100000 select sql_id,sql_text from DBA_HIST_SQLTEXT where sql_id in (select sql_id from v$session); spool off

for i in srvctl config; do echo $i; srvctl status database -d $i; done; for i in srvctl config; do echo $i; srvctl status service -d $i; done;

for ORA_SID in $(cat /var/opt/oracle/oratab |grep -vi asm |grep -v ‘#’|grep -vi agent |grep -vi orcl7 |awk -F”:” ‘{ print $1}’) do ORACLE_SID=$ORA_SID export ORACLE_SID sqlplus -s “/ as sysdba” <<! startup; exit; ! done

$ cat /u01/app/oracle/admin/SEPQA01/scripts/archiveclean.sh #CURRDATETIME=date ‘+%Y%m%d-%H%M%S’ ORACLE_SID=ORCL1;export ORACLE_SID ORACLE_HOME=/u01/app/oracle/product/12102;export ORACLE_HOME LOGDIR=/var/opt/monitoring/oracle/logs LOGFILE=/var/opt/monitoring/oracle/logs/archiveclean.log $ORACLE_HOME/bin/rman <<EOF | tee -a /var/opt/monitoring/oracle/logs/archiveclean.log connect target delete archivelog until time ‘sysdate-1’ ; exit EOF ORACLE_SID=ORCL2;export ORACLE_SID $ORACLE_HOME/bin/rman <<EOF | tee -a /var/opt/monitoring/oracle/logs/archiveclean.log connect target delete archivelog until time ‘sysdate-1’ ; exit EOF… Read More