How to discover a clustered Oracle Databases

[lorimonte]

All,

I've been battling this for quite some time and while all of the wiki's lead to SNOW discovering Oracle instances our DBAs are insisting that we capture the database as well. Here is our scenario:

Oracle Database: PRODDB is clustered across 2 instances

Instance 1:   PRODDB1 hosted on Server-PRODDB-P1

Instance 2:   PRODDB2 hosted on Server-PRODDB-P2

I can easily discover both instances but what they are wanting is to also see a database CI titled PRODDB that shows it related to the 2 instances. The reason they want this is while they may put a change in against one of the instances most of the time the change is against the database as a whole, not a singular instance.   To them PRODDB1 *IS*   PRODDB2 both are parallel processes serving as the interface to the PRODDB database.

Is there a way to actually discover the PRODDB as well as the instances?   I'm at a complete loss on this one.

Thanks!

[lorimonte]

No, we still can't discover actual Oracle databases; only the instances

[BhupeshG]

Was this ever solved? is there a solution for this in Utah or Higher?

[cosek]

How to find Oracle Database cluster name?