'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 18.104.22.168.0 and later
Information in this document applies to any platform.
Informatica Mapping fails with the following error when trying to connect Informatica to an Oracle 11g Database:
READER_1_1_1&gt; 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&gt; Tue Jul 28 19:01:40 2015
READER_1_1_1&gt; BLKR_16001 Error connecting to database...
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