alert log - keywords to monitor?

[pando]

oem is not free, in fact it's bloody expensive

[kris109]

Starting 9i, OEM is part of the oracle install. I remember in 8i, OEM change management pack, tuning pack etc., are all separate CD's. What other expenses?

The DBA resources to maintain OEM? It is part of the DBA's job.

[pando]

well OEM has been in Oracle CDs since 8i, that does not mean it's free, it's not part of Enterprise license

one of our customer pay tons of $$$ to Oracle to use them, if I remember right they charge you per database or instance

[JMac]

I've been using OEM in a standalone mode (ie not using OMS)to 'monitor' our DBs. it came with the 9i disks so I've been using it.

I believe to monoitor the alert logs via OEM I need to use OMS (which I know nothing about). So, back to my original question ...

What key words should I look for? Yes, I agree I should look at them all (and I do - every day at the moment_ but what I'd like is to check for ORA errors, Shutdowns, fail to extend stuff etc on an hourly basis and be notified by email. Then at the end of every day visually check that days logs for anything else.

[kris109]

Check for world 'error'. 'ORA-600' is another one you need to watch out. 'Failed' of occurs with redo and archive log failures.

[marist89]

Originally posted by pando
well OEM has been in Oracle CDs since 8i, that does not mean it's free, it's not part of Enterprise license

one of our customer pay tons of $$$ to Oracle to use them, if I remember right they charge you per database or instance

Back when I looked at it (~3 years ago) it was per database user. You had to license for the same number of users as all your instances. The cost was too much for what OEM does.

[jodie]

I have a script I use to monitor my alert log. I still check it manually, but this alerts me when there's a definite problem... specially during off hours.

We look for ORA- and Corrupt Block. We also skip any ORA-1109 since we get those when we are restarting the DB after a consistent backup (in mount mode)

I don't claim to be a fantastic shell scripter, so if anyone has any suggestions... please feel free to let me know!

#!/bin/ksh
. /home/oracle/.environment_ora

# Find all Sids and Oracle homes in the /etc/oratab file
grep oracle /etc/oratab |grep -v ^#|grep -v ^*|awk 'BEGIN { FS = ":" } {
  instance=($1)
  ohome=($2)
  print instance " " ohome 
}'|while read instance ohome rest
do
  export ORACLE_SID=$instance
  export ORACLE_HOME=$ohome

  # Get the BDUMP location
  alert_dir=`$ORACLE_HOME/bin/sqlplus -silent DBA_USER/$DBA_USERPASS  @${SQL_SCRIPTS}/show_dump_dest`

  # Define Name of logs
  export      ALERT_LOG=$alert_dir/alert_${ORACLE_SID}.log
  export        ERR_LOG=$alert_dir/alert_${ORACLE_SID}_`date +%m%d%y%H`.errors
  export ALERT_LOG_COPY=$alert_dir/alert_${ORACLE_SID}_`date +%m%d%y%H`.log

  # Look for ORA errors or Corrupt Block Errors.
  cnt=`grep -E 'ORA-|^Corrupt block' $ALERT_LOG|grep -v ORA-1109|wc -l`

  # If Errors, write them to a file and exit with return code 1
  if [ $cnt -gt 0 ] ; then
    
    echo "Oracle Errors Found on SID=" $ORACLE_SID > $ERR_LOG
    echo "Alert Log Name is " $ALERT_LOG_COPY >> $ERR_LOG
    echo " " >> $ERR_LOG
    grep -nE 'ORA-|^Corrupt block' $ALERT_LOG|grep -v ORA-1109 >> $ERR_LOG

    # Copy Error list to the $ERR_FILES directory
    cp $ERR_LOG $ERR_FILES/alert_${ORACLE_SID}_`date +%m%d%y%H`.err

    # Send Mail 
    # cat $ERR_LOG|mail -s "Oracle Errors on $ORACLE_SID alert log" $EMAIL_LIST 

    # Move Alert.log to a new file so that we don't get paged again for same error.
    mv $ALERT_LOG $ALERT_LOG_COPY
    touch $ALERT_LOG

    exit 1
  fi
done

[jmodic]

Originally posted by kris109
[B]Starting 9i, OEM is part of the oracle install. I remember in 8i, OEM change management pack, tuning pack etc., are all separate CD's. What other expenses?

Hey, professor, pray to god that noone from Oracle is reading this. Or else in the next few weeks you may have a visit from them at your shop that manages over 100 databases with OEM, without licencing it.

[kris109]

I am going to follow this up with my manager and our IT Director to find out what licensing arragements we have with oracle and that we use OEM with proper licence.