This discussion is archived
2 Replies Latest reply: Jan 22, 2013 9:57 AM by 986328 RSS

Intermittent TNS Connection Error

986328 Newbie
Currently Being Moderated

I have a curious issue whereby executing the following results in an intermittent TNS error i.e. sometimes tasks complete but othertimes they fail with connection error:

Software Details:
Informatica 9.1


Example Failure:


RR_4036 Error connecting to database [
Database driver error...
Function Name : Logon
ORA-12154: TNS:could not resolve the connect identifier specified

Database driver error...
Function Name : Connect
Database Error: Failed to connect to database using user [OLAP] and connection string [XXXX.XXXX].].

Executing the whole plan again may/may not result in this workflow completing.

To be clear the following have been resolved:

1. tnsnames.ora is correct and tested working. All connection aliases have a global suffix
2. Single Oracle Client being used
3. Tests from Server to Server include multiple connections
4. DAC and Informatica connection settings are the same

Any help would be appreciated!


  • Correct Answers - 10 points
  • Helpful Answers - 5 points