Will the script useful with snmp? I have no nrpe on my oracle server i m collecting information through snmp only...
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: [email protected] >> 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 >> [email protected] >> 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 [email protected] 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
