Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

RAC - Determine all instances whether enabled/disabled for inventory purpose

user13283765Mar 6 2015 — edited Mar 6 2015

Hello All,

I can't seem to figure out to get all the instance and hostnames in my cluster when some of the instances are disabled.

My scenario is that I have 5 nodes and 3 of the 5 are disabled in clusterware.

I'm loging into one of the active instances, and when I select from GV$INSTANCE, I only see the active/enabled instances. On the other hand, the parameter "cluster_database_instances" shows 5.

For inventory purposes I need to determine all 5 instance names, all 5 hostnames. How can I do this from SQL.

Thanks in advance for any assistance or pointers.

Sincerely

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 3 2015

Added on Mar 6 2015

#performance-availability, #rac-asm-clusterware-installation

2 comments

1,399 views