Re: Oracle services check
From: Yong Huang <yong321_at_yahoo.com>
Date: Wed, 30 Jan 2013 14:21:48 -0800 (PST)
Message-ID: <1359584508.80709.YahooMailClassic_at_web184806.mail.gq1.yahoo.com>
> I wrote a simple script to compare the current status of each service
> with it's configuration
> If there isn't anything in EM, then how are others dealing with this?
Date: Wed, 30 Jan 2013 14:21:48 -0800 (PST)
Message-ID: <1359584508.80709.YahooMailClassic_at_web184806.mail.gq1.yahoo.com>
> I wrote a simple script to compare the current status of each service
> with it's configuration
> If there isn't anything in EM, then how are others dealing with this?
We use home-grown scripts.
svc_on_pref.sh: Check to see if services are running on their preferred instances. Notify us if not.
and
ck_lsnr_svc_upd.sh: 11g only (10g script is quite different). Check listener service update making sure pmon's on all instances update their info with all SCAN listeners.
at
http://yong321.freeshell.org/oranotes/Service.txt
do the job we want.
Yong Huang
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jan 30 2013 - 23:21:48 CET