'ORA-12154: TNS:could not resolve service name' Error Message Received From Failed Informatica Mapping When Oracle 11g Client Is Not Installed
Last updated on JANUARY 31, 2017
Applies to:Business Intelligence Applications Observer - Version 184.108.40.206.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...
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms