Oracle alert logs
Gerhard Lausser
Gerhard.Lausser at consol.de
Fri Nov 23 11:37:52 CET 2007
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
More information about the Users
mailing list