Database Administration (MOSC)

MOSC Banner

Monitor alert log using adrci for multiple database under one oracle home

edited Oct 1, 2014 10:16AM in Database Administration (MOSC) 2 comments

Hi,

We have around 10 11gr2 databases in one server.

So we have to put separate alert log monitoring script for each database.

But with adrci, now i m able to to monitor all database alert logs using one simple script.

#################################################

###### ALERT LOG CHECKING VIA ADRCI #############

#################################################

. /home/oracle/profile_orcl

DAILY_LOG=/home/oracle/alert_log_check_daily.txt

adrci_homes=( $(adrci exec="show homes" | grep -e rdbms ))

                echo '#########################################################################################################' > $DAILY_LOG

                echo '###########################################ALERT LOG OUTPUT FOR last 10 minutes ###########################' >> $DAILY_LOG

                echo '##########################################################################################################' >> $DAILY_LOG

for adrci_home in ${adrci_homes[@]}

                do

echo ' '>>$DAILY_LOG

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center