oracle: Profile: test connection, Oracle error! Status: -1, - ORA-12545

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

Unable to connect to Oracle database 

Error in oracle_monitor.log:

oracle: Profile: <profilename>, Oracle error! Status: -1, - ORA-12545: Connect failed because target host or object does not exist

Environment

any oracle probe version

Resolution

Validate the global_name:

select * from global_name;

Use the following for the service name in the probe connection:

(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = my-hostname)(PORT = my-connection-port))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = the-name-that-was-returned-from-the-select-query)))

example: