Re: monitor rac database services

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

http://coskan.wordpress.com/2010/12/29/how-to-monitor-services-on-11gr2/

<http://coskan.wordpress.com/2010/12/29/how-to-monitor-services-on-11gr2/>Original
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
> http://www.uptime.be
> disclaimer: www.uptime.be/disclaimer
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>


-- 
-- 
Coskan GUNDOGAR

Oracle DBA

Email: coskan@xxxxxxxxx
Blog: http://coskan.wordpress.com
Twitter: http://www.twitter.com/coskan
Linkedin: http://uk.linkedin.com/in/coskan

Other related posts: