SHOW ALERT

To tail the last 10 lines of the current alert log...

adrci exec="set homepath diag/rdbms/$(echo $ORACLE_SID | tr '[:upper:]' '[:lower:]')/$ORACLE_SID;show alert -tail"

To tail the last 50 lines of the current alert log...

adrci exec="set homepath diag/rdbms/$(echo $ORACLE_SID | tr '[:upper:]' '[:lower:]')/$ORACLE_SID;show alert -tail 50"

To tail the last 10 lines of the current alert log and show more lines as they arrive...

adrci exec="set homepath diag/rdbms/$(echo $ORACLE_SID | tr '[:upper:]' '[:lower:]')/$ORACLE_SID;show alert -tail -F"

To show an entry at a specific timestamp...

adrci

show alert -term -p "ORIGINATING_TIMESTAMP = '2021-07-16 09:55:37.840343 -01:00'"

To show all entries between specific timestamps...

adrci

show alert -term -p "ORIGINATING_TIMESTAMP > '2021-07-16 09:55:00.000000 -01:00' AND ORIGINATING_TIMESTAMP < '2021-07-16 09:58:00.000000 -01:00'

Startup/Shutdown times

Using current alert.log

adrci

show alert -p "originating_timestamp > systimestamp-1 and message_group like '%ddl%'" -term

Using older alert.log

echo show alert -p "message_group like '%ddl%'" -term -file /u01/app/oracle/diag/rdbms/$(echo $ORACLE_SID | tr '[:upper:]' '[:lower:]')/${ORACLE_SID}/alert/log.xml.2018-09-15_23:59

adrci

Using nawk to simplify output

Shutdown...

adrci exec=show alert -p "originating_timestamp > systimestamp-1 and message_group like '%ddl%'" -term | \

nawk 'c-->0;$0~s{if(b)for(c=b+1;c>1;c--)print r[(NR-c+1)%b];print;c=a}b{r[NR%b]=$0}' b=1 a=0 s="^ALTER DATABASE CLOSE"

Startup...

adrci exec=show alert -p "originating_timestamp > systimestamp-1 and message_group like '%ddl%'" -term | \

nawk 'c-->0;$0~s{if(b)for(c=b+1;c>1;c--)print r[(NR-c+1)%b];print;c=a}b{r[NR%b]=$0}' b=1 a=0 s="^Completed: ALTER DATABASE OPEN"

Startup/Shutodown Shell script

Querying the Listener Log

This script show all TNS errors complete with failed connection information...

adrci exec=show alert -p "message_text like '%TNS-%' or message_text like '% * 1%'" -file /u01/app/oracle/diag/tnslsnr/$(hostname -s)/${LISTENER_NAME}/alert/log.xml -term

Purge

To check Autopurge settings use...

adrci

select SHORTP_POLICY,LONGP_POLICY,LAST_AUTOPRG_TIME,LAST_MANUPRG_TIME from ADR_CONTROL;

Incident Packaging Service (IPS)

Bibliography