Error from the oracle probe ORA-12154 error

book

Article ID: 103263

calendar_today

Updated On:

Products

DX Infrastructure Management NIMSOFT PROBES CA Unified Infrastructure Management for z Systems CA Unified Infrastructure Management On-Premise (Nimsoft / UIM) CA Unified Infrastructure Management SaaS (Nimsoft / UIM)

Issue/Introduction

We have setup an oracle probe that we need to monitor two databases on. The oracle probe is setup to use the oracle client of the first database and is working as expected. When we create a connection to the second database we get an oracle client error ORA-12154.
How can we monitor a second oracle database from the same oracle probe installation?

Cause

- Guidance

Environment

- UIM 20.x and later
- oracle probe 5.30 or later
 

Resolution

- The oracle probe environment variables only need to point to the location of an ORACLE client that supports the target database type. Check the oracle client documentation for compatibility.

- As long as that is supported you should be able to update the ORACLE CLIENT tnsnames.ora file with the different database connection  / service names as needed and then have the oracle probe connect without an issue.

- You should be able to use the sqlplus tool built into the oracle client to test the service name connection with the username and password to be used in the oracle probe. If this works then the oracle probe should work as well.

Additional Information

Another way that you can try is to install multiple robots in a single Server, so you can setup different controllers:

https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/unified-infrastructure-management/20-3/installing/deploy-robots/install-multiple-robots-on-a-single-host.html