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!

[gk13]

Hi,

did you solve your issue? If yes maybe you can share your solution.

[lorimonte]

Hey!

Still nothing! This is such a huge inconvenience. I had thought with the upgrade to Madrid that it included new probes and patterns for this but so far I've not seen anything. 

[doug_schulze]

Lori,

So youre not on Oracle RAC.. we put something in for clusters in the london release...

[gk13]

Hi Doug,

can you share a Dependency Map of how an Oracle RAC would look like after Disocvery? I'd like to compare our results to it

[lorimonte]

Still doesn't help unfortunately.