
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
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
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?
Hi
could you give us the process that are running regarding Oracle.
we can maybe discover it with UAD.
gilles
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 ![]()