admin

About admin

This author has not yet filled in any details.
So far admin has created 11 blog entries.

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

Praesent Et Urna Turpis

Quisque ligulas ipsum, euismod atras vulputate iltricies etri elit. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Nulla nunc dui, tristique in semper vel, congue sed ligula. Nam dolor ligula, faucibus id sodales in, auctor fringilla libero. Pellentesque pellentesque tempor tellus eget hendrerit. Morbi id aliquam ligula. Aliquam id dui […]

By |July 31st, 2012|Design|0 Comments

Donec At Mauris Enims

Quisque ligulas ipsum, euismod atras vulputate iltricies etri elit. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Nulla nunc dui, tristique in semper vel, congue sed ligula. Nam dolor ligula, faucibus id sodales in, auctor fringilla libero. Pellentesque pellentesque tempor tellus eget hendrerit. Morbi id aliquam ligula. Aliquam id dui […]

By |July 31st, 2012|Creative|1 Comment

Class Aptent Taciti Soci Ad Litora

Quisque ligulas ipsum, euismod atras vulputate iltricies etri elit. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Nulla nunc dui, tristique in semper vel, congue sed ligula. Nam dolor ligula, faucibus id sodales in, auctor fringilla libero. Pellentesque pellentesque tempor tellus eget hendrerit. Morbi id aliquam ligula. Aliquam id dui […]

By |July 31st, 2012|Design, Videos|0 Comments

Nullam Vitae Nibh Un Odiosters

Quisque ligulas ipsum, euismod atras vulputate iltricies etri elit. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Nulla nunc dui, tristique in semper vel, congue sed ligula. Nam dolor ligula, faucibus id sodales in, auctor fringilla libero. Pellentesque pellentesque tempor tellus eget hendrerit. Morbi id aliquam ligula. Aliquam id dui […]

By |July 31st, 2012|Creative|0 Comments

Proin Sodales Quam Nec Sollicit

Quisque ligula ipsum, euismod aturesit vulputate a, ultricies et elit. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Nulla nunc dui, tristique in semper vel, congue sed ligula. Nam dolor ligula, faucibus id sodales in, auctor fringilla libero. Pellentesque pellentesque tempor tellus eget hendrerit. Morbi id aliquam ligula. Aliquam id […]

By |July 31st, 2012|Design|0 Comments