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

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

Unable to connect to Oracle database even though have configured it correctly.

Feb 28 22:19:11:173 [140421872342848] oracle: Profile: test connection, Oracle error! Status: -1, - ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

Environment

Release: 20.4
Components: oracle probe

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: