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":"BU059","label":"IBM Software w\/o TPS"},"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":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21654376