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 Lori,

we are actually fighting the exact same battle. There is indeed an Oracle RAC pattern available starting with London. But it doesn't solve your scenario. If we find a solution I'll post an update here.

[gk13]

Hi Lori, assuming you could discover the data bases: what class what you put them in and what relationship type would you use to tie them to instances? From my understanding the database would be the parent of it's instances. But concerning the classes there are quite a lot of opinions in the forum. My personal favourite would have been to create them as catalogs because thats how SQL is handled but the different opinions here make me somehow unsure. Maybe Doug can share some ideas here

[lorimonte]

Hi GK,

No, we still can't discover the Oracle database. We can still only get the instances. 

[gk13]

Yes, I know. But if you could discover them in which class would you put them? We are thinking of creating an own pattern for this. But we are not 100% sure in which class we should put them. That why I wanted to get some ideas from you

[blanca12]

did you solve your issue?

____________________________________________

Tutuapp 9Apps ShowBox