IBM Support

Getting error ORA-12514 error : listener does not currently know of service requested in connect descriptor while Testing Datasource connection

Troubleshooting


Problem

Compatible datasource connection failed with error "ORA-12514 error : listener does not currently know of service requested in connect descriptor"

Symptom

Screen Shot of error message attached

Cause

Incorrect service name used in the tnsnames.ora file

Environment

Windows, Unix

Diagnosing The Problem

Execute the below command on Oracle. This gives the service name of Oracle Database

select value from v$parameter where name='service_names'

Resolving The Problem

1. Verified the tnsnames.ora file on the oracle client. The servicenamefromDB in the below section of the file was different from the output of the command


select value from v$parameter where name='service_names'


TEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = <validhost>)(PORT = <validport>))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = <servicenamefromDB>)
)
)

2. Made the change in the tnsnames.ora file. Saved changes
3. Tested and the compatible data source connection succeeded.

[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"10.2.1;10.2;10.1.1;10.1","Edition":""}]

Document Information

Modified date:
15 June 2018

UID

swg21654376