Re: monitor rac database services

  • From: coskan gundogar <coskan@xxxxxxxxx>
  • To: Freek.DHooge@xxxxxxxxx
  • Date: Tue, 14 Jun 2011 17:21:33 +0100

still using crs_stats instead of crsctl but will this one work for you ?

script is from Yong Huang.

On 14 June 2011 15:10, D'Hooge Freek <Freek.DHooge@xxxxxxxxx> 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@xxxxxxxxx
> tel +32(0)3 451 23 82
> disclaimer:
> --


Oracle DBA

Email: coskan@xxxxxxxxx

Other related posts: