> 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: [EMAIL PROTECTED] > >> [mailto:[EMAIL PROTECTED] Im Auftrag von > >> Sunny Bhatheja > >> Gesendet: Donnerstag, 22. November 2007 16:42 > >> An: nagios-users@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@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@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