Oracle alert logs

[Sunny Bhatheja]

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: 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