2 Replies Latest reply: Jan 22, 2013 9:57 AM by 986328 RSS

    Intermittent TNS Connection Error

    986328
      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!