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
Hi,

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:
DAC 10.1.3.4.1
Informatica 9.1

Execution:
ExecutionPlanHumanResources_All

Example Failure:

SIL_DayDimension_GenerateRows3

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!

Legend

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