Re: 11g RAC TAPI/Custom services : how to query in data dictionary
Date: Wed, 15 Jul 2015 10:24:27 -0700
Message-ID: <1436981067.54198.YahooMailBasic_at_web184806.mail.gq1.yahoo.com>
The first method in Chad's message (see below) is exactly what my svc_on_pref.sh script does, available at http://yong321.freeshell.org/oranotes/Service.txt (about half page down)
I tried Chad's query. It lists only one of the few services that run on non-preferred nodes. Why not simply:
select database_unique_name, cluster_name, service_name, preferred_instances, running_instances
from mgmt_rac_services
where preferred_instances != running_instances
order by 1, 2, 3, 4;
which can list them all.
Yong Huang
- Original message ---
by Chad Cleveland:
> You can get this information with SRVCTL inside a shell script. Loop through each of the sids and report back.
> ALTERNATIVELY you can hit the OEM repository for this info:
> Databases with Services running on non-preferred Node:
> select distinct(lower(service_name)) Service_Name, database_unique_name, cluster_name, preferred_instances, available_instances, running_instances
> from sysman.mgmt_rac_services a
> where ecm_snapshot_id = (select max(b.ecm_snapshot_id) from sysman.mgmt_rac_services b where b.service_name = a.service_name)
and running_instances <> preferred_instances
> order by 2 asc;
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jul 15 2015 - 19:24:27 CEST