0 Replies Latest reply on Sep 7, 2021 10:10 PM by Amey Abhyankar

    Logon ORA-12154: TNS:could not resolve the connect identifier

    Amey Abhyankar New Member

      Hello,

       

      Developer is able to connect to the remote Oracle12c DB in 'PowerCenter Designer' but getting error when he is trying to run a workflow in 'PowerCenter Workflow Manager' + 'PowerCenter Workflow Monitor'.

       

      Error =

      ----------------------------------------------------------------------------------------------------------------------------------------

      Severity Timestamp Node Thread Message Code Message

      ERROR 9/7/2021 6:12:43 PM node01 READER_1_2_1 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 [system] and connection string [jdbc:informatica:oracle://oracle.mydomain.com:1521;SID=orcl].]

      ----------------------------------------------------------------------------------------------------------------------------------------
      Following checks are done =
      1) DWsqls28.so exists on Informatica Linux server = Yes
      2) Path of DWsqls28.so exists in odbc.ini for Oracle with other values i.e. correct user name,password,port & SID
      3) Informatica version = 10.4.1
      4) Tried to check Oracle connectivity from Informatica admin i.e. http://10.200.104.88:6008/administrator/#admin_domainOverview/  and getting success message.
      5) Tried to test ODBC connectivity from Informatica Windows client machine and it is working fine.

      6) Able to connect to the same DB using dbeaver from other systems

      Regards,
      Amey.