Oracle 11g アラートログ(alert.log)をtail -fで表示するスクリプト ref: http://qiita.com/na0AaooQ/items/eced881647a82f44c740

file0.txt

[oracle@example-oracle-11g ~]$ echo $ORACLE_BASE
/oracle_example/opt/oracle/app/oracle
[oracle@example-oracle-11g ~]$

[oracle@example-oracle-11g ~]$ echo $ORACLE_SID
testsid
[oracle@example-oracle-11g ~]$

file1.txt

[oracle@example-oracle-11g ~]$ vi tail_alert_log.sh

file2.txt

[oracle@example-oracle-11g ~]$ chmod 755 tail_alert_log.sh

file3.txt

[oracle@example-oracle-11g ~]$ chmod 755 tail_alert_log.sh

file4.txt

[oracle@example-oracle-11g ~]$ ./tail_alert_log.sh
　　(省略)　
Wed Jan ** **:**:** 2015
Thread 1 advanced to log sequence XXXXXX (LGWR switch)
  Current log# 4 seq# XXXXXX mem# 0: /XXXXXXXXXX/testsid/redogXXm01.log
  Current log# 4 seq# XXXXXX mem# 1: /XXXXXXXXXX/testsid/redogXXm02.log
Wed Jan ** **:**:** 2015
Archived Log entry XXXXXX added for thread 1 sequence XXXXXX ID XXXXXXXXXXXXX dest 1:

tail_alert_log.sh

#!/bin/sh

ALERT_LOG="${ORACLE_BASE}/diag/rdbms/${ORACLE_SID}/${ORACLE_SID}/trace/alert_${ORACLE_SID}.log"

if [ -f ${ALERT_LOG} ] ; then
        tail -f ${ALERT_LOG}
fi