Error from the oracle probe ORA-12154 error
search cancel

Error from the oracle probe ORA-12154 error


Article ID: 103263


Updated On:


DX Unified Infrastructure Management (Nimsoft / UIM) Unified Infrastructure Management for Mainframe CA Unified Infrastructure Management SaaS (Nimsoft / UIM)


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?


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


- Guidance


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.