When are are trying to connect to a second remote database from the oracle probe we are getting an ORA-12154 error
Article ID: 103263
DX Infrastructure ManagementNIMSOFT PROBES
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 9.0 and earlier oracle probe 5.30 and earlier
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 support 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.