How to discover a clustered Oracle Databases

lorimonte
Mega Contributor

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!

17 REPLIES 17

lorimonte
Mega Contributor

Anyone? I'm stuck on this one.



Thanks!


kbyrne
Kilo Contributor

We just heard back from our account consultant and said the product team reports: 

We are targeting London to support ORACLE ClusterWare. Oracle RAC is in development for a post London. Post London, we will be offering new patterns without the need to upgrade the instance.

lorimonte
Mega Contributor

Oh awesome!  Thank you!

 

kbyrne
Kilo Contributor

We are in the same boat.  Really hoping there's a solution!