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

    Intermittent TNS Connection Error


      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!