Oracle alert logs

[Gerhard Lausser]

Hi Sunny,

you could use http://www.consol.com/opensource/nagios/check-logfiles for
that. However you need to either run the nrpe daemon or to be able to login
wit ssh on the oracle server. On the examples page there is a section on
Oracle alert logs:
@searches = (
{
  tag => 'oraalerts',
  logfile => '......../alert.log',
  criticalpatterns => [
      'ORA\-0204',        # error in reading control file
      'ORA\-0206',        # error in writing control file
      'ORA\-0210',        # cannot open control file
      'ORA\-0257',        # archiver is stuck
      'ORA\-0333',        # redo log read error
      'ORA\-0345',        # redo log write error
      'ORA\-04[4-7][0-9]',# ORA-0440 - ORA-0485 background process failure
      'ORA\-048[0-5]',
      'ORA\-06[0-3][0-9]',# ORA-6000 - ORA-0639 internal errors
      'ORA\-1114',        # datafile I/O write error
      'ORA\-1115',        # datafile I/O read error
      'ORA\-1116',        # cannot open datafile
      'ORA\-1118',        # cannot add a data file
      'ORA\-1578',        # data block corruption
      'ORA\-1135',        # file accessed for query is offline
      'ORA\-1547',        # tablespace is full
      'ORA\-1555',        # snapshot too old
      'ORA\-1562',        # failed to extend rollback segment
      'ORA\-162[89]',     # ORA-1628 - ORA-1632 maximum extents exceeded
      'ORA\-163[0-2]',   
      'ORA\-165[0-6]',    # ORA-1650 - ORA-1656 tablespace is full
      'ORA\-4031',        # out of shared memory.
  ],
  warningpatterns => [
      'ORA\-3113',        # end of file on communication channel 
      'ORA\-6501'         # PL/SQL internal error 
  ]
});

On the DB-server you need the check_logfiles plugin and the above config
file.
Then you define a service

define service {
  service_description   check_oraalerts
  host_name             dbsrv
  check_command       check_by_ssh!/path/to/check_logfiles -f
/path/to/above_configfile
  is_volatile           1
  check_period          7x24
  max_check_attempts    1
  ...
}  

define command {
                command_name                    check_by_ssh
                command_line                    $USER1$/check_by_ssh -H
$HOSTADDRESS$ -C '$ARG1$'
}

and you should get a nagios notification every time new error messages are
appended to the alertlog.

Greetings from Munich,
Gerhard

> -----Ursprüngliche Nachricht-----
> Von: nagios-users-bounces at lists.sourceforge.net 
> [mailto:nagios-users-bounces at lists.sourceforge.net] Im 
> Auftrag von Sunny Bhatheja
> Gesendet: Donnerstag, 22. November 2007 16:42
> An: nagios-users at lists.sourceforge.net
> Betreff: [Nagios-users] Oracle alert logs
> 
> 
> Hello,
>                      I want to monitor the oracle alert log 
> from my nagios server.My oracle is installed on remote 
> machine (sun 5.8) .It is a production server so i can `t do 
> much on that , Is there way way to monitor those alert logs.
>      
> 
> 
> --------------------------------------------------------------
> -----------
> This SF.net email is sponsored by: Microsoft Defy all 
> challenges. Microsoft(R) Visual Studio 2005.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> Nagios-users mailing list
> Nagios-users at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/nagios-users
> ::: Please include Nagios version, plugin version (-v) and OS 
> when reporting any issue. 
> ::: Messages without supporting info will risk being sent to /dev/null
> 


-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
::: Messages without supporting info will risk being sent to /dev/null