Re: monitor rac database services

From: Radoulov, Dimitre <cichomitiko_at_gmail.com>
Date: Wed, 15 Jun 2011 18:20:02 +0200
Message-ID: <4DF8DBB2.3010307_at_gmail.com>

Hi,
I don't think there is a straightforward way for retrieving this info.

I wrote a small Perl script using a test rac 11.2 with 2 nodes running on my pc.
The script is definitely not production ready yet :)

When you have time you could try it and let me know if it's working for you.

Regards
Dimitre

On 14/06/2011 16:10, D'Hooge Freek wrote:
> Hi,
>
> I'm currently bussy writing a perl check to verify the status of a rac database service.
> When the service is down, while the target status is "online" a critical alert has to be given and when the service is running on an "available" instance instead of the preferred instance a warning has to be given.
>
> I have written such a check in the past for 10gR2, but now I need one for 11gR2.
> As the output formats have changed a lot between 10.2 and 11.2, a large part of the script has to be rewritten (also instances seems to be not as tightly coupled to nodes in 11.2). So I was wondering if there is a (supported) way to query the cluster registry without depending on the output formats of srvctl / crsctl. Which does not seem to be build for easy use in scripts.
>
> Information I need to retrieve is which instances and services exists for a database, what the available / preferred instances are of a service, the current state and target of a service and on which instance a service is currently running.
>
>
> Kind regards,
>
> Freek D'Hooge
> Uptime
> Oracle Database Administrator
> email:freek.dhooge_at_uptime.be
> tel +32(0)3 451 23 82
> http://www.uptime.be
> disclaimer:www.uptime.be/disclaimer
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>

--
http://www.freelists.org/webpage/oracle-l




text/plain attachment: rac11gr2_mon.pl

Received on Wed Jun 15 2011 - 11:20:02 CDT