Uncategorized

Database Instance alert log monitoring using base (X$) metadata tables

#!/usr/bin/ksh

# source the database instance to be monitored like ORACLE_SID, ORACLE_BASE, ORACLE_HOME … saved by you to a .profile

$ORACLE_HOME/bin/sqlplus “/ as sysdba” = sysdate-120/1440)
and (message_text like ‘%ORA-%’ or message_text like ‘%Fatal%’ or message_text like ‘%Errors%’ or message_text like ‘%Corrupt%’ or message_text like ‘%event%’);

spool off
eof
exit

ErrCnt=`cat $ORACLE_BASE/log/errors.log |grep “no rows selected”| wc […]

By |March 3rd, 2016|Uncategorized|0 Comments

Monitor alert log using data dictionary

#!/usr/bin/ksh

# source the database instance to be monitored like ORACLE_SID, ORACLE_BASE, ORACLE_HOME … saved by you to a .profile

$ORACLE_HOME/bin/sqlplus “/ as sysdba” = sysdate-120/1440)
and (message_text like ‘%ORA-%’ or message_text like ‘%Fatal%’ or message_text like ‘%Errors%’ or message_text like ‘%Corrupt%’ or message_text like ‘%event%’);

spool off
eof
exit

ErrCnt=`cat $ORACLE_BASE/log/errors.log |grep “no rows selected”| wc […]

By |March 3rd, 2016|Uncategorized|0 Comments

Hello world!

Welcome to WordPress. This is your first post. Edit or delete it, then start blogging!

By |September 16th, 2014|Uncategorized|1 Comment

Tutorials

By |November 8th, 2013|Uncategorized|3 Comments

TOOLS

By |November 8th, 2013|Uncategorized|1 Comment