Oracle alert logs

[Gerhard Lausser]

> Will the script useful with snmp? I have no nrpe on my oracle 
> server i m collecting information through snmp only...
Sorry, the plugin must have local access to the logfile. Without nrpe
check_by_ssh is your only chance to run the plugin on the database server.
If you're limited to snmp then i see no chance except writing your own
extension to snmpd
(http://www.net-snmp.org/wiki/index.php/Tut:Extending_snmpd_using_perl). 

Gerhard 
> 
> Gerhard Lausser wrote:
> > 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