BMC Communities: Message List - Discovering Oracle RAC

Re: Discovering Oracle RAC

petrus.johansson@ikea.com — Thu, 05 Mar 2009 09:43:28 GMT

This question and ellaboration has been idle long enough...

I´m looking in to doing this with UAD, similar to the "Oracle DB (specialized)" entry in the Application Library. Probably it would be necessary to some work with the "Oracle Listener (specialized)" entry in the Application Library as well if not creating a new entry for it. Have not looked in to that specific part yet.

The processes I´m working with are:

racgimon (with keyword "asm") (specifies an instance)

asm_ckpt

asm_dbw0

asm_diag

asm_gmon

asm_lck0

asm_lgwr

asm_lmd0

asm_lmon

asm_lms0

asm_mman

asm_pmon (specifies an instace)

asm_psp0

asm_rbal

asm_smon

Still have some rather big work with "Regular Expressions" to get it all sorted.

For the Listener I´m not sure how to work with this yet...

But in a perfect world it would be great to identify all hosts, instances and nodes of the RAC, the listener ServiceName and the clustername of the RAC.

I´ll keep you posted, input or comments always welcome

Re: Discovering Oracle RAC

forums@developer.bmc.com — Thu, 20 Nov 2008 22:16:04 GMT

could you give us the process that are running regarding Oracle.

we can maybe discover it with UAD.

gilles

Re: Discovering Oracle RAC

petrus.johansson@ikea.com — Thu, 20 Nov 2008 18:33:05 GMT

Of course that is the case, Oracle RAC consists of several nodes (in our case usualy 8 nodes/RAC)

What I am after is a way to automaticaly in TD identify Oracle RAC, bounding them together with the TNS listeners and the ASM with for example the "service name" of the RAC.

For normal stand alone databse instaces, applications use hostname, instance name, port to connect to the databse.

For Oracle RAC applications connect to the "service name" of the RAC that consists of all nodes.

Do I need a modification of how Discovery collects the db information by the TNS method? If so, any idea of what has to be modified? Or any other suggestions or thoughts at all?

Re: Discovering Oracle RAC

rastislav_danis@tempest.sk — Thu, 06 Nov 2008 09:06:32 GMT

from i had saw - customers use common naming for RAC dbs - f.e. 2 node rac of db TEST is named TEST_NODE1 and TEST_NODE2, so probably there is such naming convention in your case

Discovering Oracle RAC

petrus.johansson@ikea.com — Thu, 06 Nov 2008 08:21:22 GMT

I would like to take this topic up for discussion as Oracle RAC gets more and more common in the IT industry today. As I´m aware FD/TD 1.6 does not support Discovering Oracle RAC and/or the functionality of it.

Yes, running a normal database and asset discovery on Oracle RAC servers provide pretty much the same information as running the same discovery on a single node instance.
The result of the scan shows the host server and the connected database instances. However, there are no way to determine if this is a Oracle RAC or not, so this is where I would like to start off this discussion.

My first question is really basic... what commands does Discovery use during database discovery with the TNS method and how is the output collected into the datastore? I´m having trouble finding this information in the TD/HOME directory on the Discovery server