Monitor Multiple Oracle DBs with different ORACLE_SIDs(ENVT Detials)

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)
• CA Unified Infrastructure Management On-Premise (Nimsoft / UIM)
• CA Unified Infrastructure Management SaaS (Nimsoft / UIM)

Issue/Introduction

Can we configure two or more DBs with different Oracle ORACLE_SID, LD_LIBRARY_PATH, ORACLE_HOME, TNS_ADMIN on a single server?

Environment

DX UIM 20.4.x / DX UIM 23.4

Oracle probe 5.x

Cause

Guidance

Resolution

The Oracle probe uses the 'Service Name' you enter in the 'Connections' configuration to find the target Oracle server and uses the variables set in the controller to know which oracle client to use.

When contacted, the server returns the values listed in the tnsnames.ora file that is configured during the deployment phase. 

To monitor multiple instances of the Oracle Databases running on the same server, additional entries can be added to the tnsnames.ora file. 

---

Steps to configure multiple instances of the Oracle Databases running on the same server:

• Engage your DBA and set up the tnsnames.ora file correctly
• In the Oracle probe, configure different "Connections" using each of the Service Names/SIDs that are reachable by the defined Oracle Agent.

Additional Information

Notes:

• If the multiple Services configured are not reachable, verify with the Oracle DBA if the path to the TNS_ADMIN is configured correctly. 

• You can only have one setup of variables configured in the robot controller

• These variables are to tell the oracle probe which oracle client to use

• For troubleshooting purposes: you can use the tnsping utility to ping the install or the sqlplus utility

• Another option you can try is to install multiple robots in a single Server, so you can setup different controllers: Install Multiple Robots on a Single Host (broadcom.com)