'ORA-12154: TNS:could not resolve service name' Error Message Received From Failed Informatica Mapping When Oracle 11g Client Is Not Installed
(Doc ID 2038048.1)
Last updated on JULY 08, 2021
Applies to:
Business Intelligence Applications Observer - Version 11.1.1.7.0 and laterInformation in this document applies to any platform.
Symptoms
Informatica Mapping fails with the following error when trying to connect Informatica to an Oracle 11g Database:
READER_1_1_1> Tue Jul 28 19:01:40 2015
READER_1_1_1> RR_4036 Error connecting to database [ ORA-12154: TNS:could not resolve service name
Database driver error... Function Name : Connect Database Error: Failed to connect to database using user [UserXXXX] and connection string [XXX_PROD.world].].
READER_1_1_1> Tue Jul 28 19:01:40 2015
READER_1_1_1> BLKR_16001 Error connecting to database...
READER_1_1_1> RR_4036 Error connecting to database [ ORA-12154: TNS:could not resolve service name
Database driver error... Function Name : Connect Database Error: Failed to connect to database using user [UserXXXX] and connection string [XXX_PROD.world].].
READER_1_1_1> Tue Jul 28 19:01:40 2015
READER_1_1_1> BLKR_16001 Error connecting to database...
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |