'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 JANUARY 31, 2017

Applies to:

Business Intelligence Applications Observer - Version 11.1.1.7.0 and later
Information 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...

Cause

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