alert log - keywords to monitor? - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 19 of 19

Thread: alert log - keywords to monitor?

  1. #11
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    oem is not free, in fact it's bloody expensive

  2. #12
    Join Date
    May 2001
    Location
    San Francisco, California
    Posts
    510
    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.
    Remember the Golden Rule - He who has the gold makes the rules!
    ===================
    Kris109
    Ph.D., OCP 8i, 9i, 10g, 11g DBA

  3. #13
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    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

  4. #14
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    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.

  5. #15
    Join Date
    May 2001
    Location
    San Francisco, California
    Posts
    510
    Check for world 'error'. 'ORA-600' is another one you need to watch out. 'Failed' of occurs with redo and archive log failures.
    Remember the Golden Rule - He who has the gold makes the rules!
    ===================
    Kris109
    Ph.D., OCP 8i, 9i, 10g, 11g DBA

  6. #16
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    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.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  7. #17
    Join Date
    Sep 2001
    Location
    Ohio
    Posts
    334
    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!


    Code:
    #!/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

  8. #18
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    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.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  9. #19
    Join Date
    May 2001
    Location
    San Francisco, California
    Posts
    510
    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.
    Remember the Golden Rule - He who has the gold makes the rules!
    ===================
    Kris109
    Ph.D., OCP 8i, 9i, 10g, 11g DBA

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width