Search This Blog

Total Pageviews

Wednesday 3 August 2011

Oracle 11g adrci from prompt

Oracle 11g alert through adrci

Oracle 11g adrci

# adrci.cmd <<<<<
--------------------------------

# ADRCI script to find alert log errors
SPOOL /tmp/alert_log_errors.txt
ECHO "ALERT LOG ERRORS:"; SET HOME diag/rdbms/aptdb/aptdb; SHOW ALERT -TERM -P "MESSAGE_TEXT LIKE '%ORA-%'"
SPOOL OFF

---------------------------------


$adrci -script=adrci.cmd

-bash-3.2$ ls -ltr /tmp/alert_log_errors.txt
-rw-r----- 1 oracle dba 9766 Aug 3 14:50 /tmp/alert_log_errors.txt

No comments:

Oracle DBA

anuj blog Archive