How to Discover Oracle Real Application Cluster (RAC)

This section includes the following topics:

1. Prerequisite - Set up protocol credentials

   This discovery uses the NTCMD, SSH, or Telnet protocols.

   For credential information, see Supported Protocols.

2. Prerequisites - Other

   1. To retrieve all relevant information, verify that DFM has:

   • Read permissions for the $ORACLE_HOME\network\admin directory

   • The correct execute permissions for $ORACLE_HOME\bin\lsnrctl and for the corresponding library (lib) and message files.

   2. Oracle Listeners by Shell job. Verify that the RAC relative processes are running on the Oracle database. The file names begin with ora_lms, ora_lmd, ora_lck, and oracm.

   3. Oracle RAC Topology by Shell job. The Listened IPs of the Listener CIT must be not NULL.

   4. Run the Host Connection by Shell job, to activate Shell CITs.

3. Run the discovery

   1. Run any of the host resources jobs that gather information about processes running on the host. For example, Host Applications by Shell.

   If DFM discovers TNS Listener processes, the job creates Oracle TNS Listener CIs and an Oracle DB CI together with its connected processes.

   2. To discover Oracle TNS Listener CIs with full data, run the Oracle Listeners by Shell job. This job connects to the host and retrieves the required data for the Oracle TNS Listener CI. For details, see Oracle Listeners by Shell Job.

   3. To discover Oracle RAC topology, run the Oracle RAC Topology by Shell job. This job connects to the hosts with full listeners and discovers RAC. For details, see Oracle RAC Topology by Shell Job. For details on undiscovered elements, see Troubleshooting and Limitations – Oracle RAC Discovery.

   For details on running jobs, refer to "Module/Job-Based Discovery" in the Universal CMDB Data Flow Management section of the UCMDB Online Help.