2 Replies Latest reply on Feb 28, 2021 9:22 PM by Akshay Wani

    Oracle DSN error for Informatica 10.4.1

    Akshay Wani New Member

      Error:

      Node: node01

      Thread: READER_1_1_1

      Process ID: 26203

      Message Code: RR_4036

      Message: Error connecting to database [

      Database driver error...

      Function Name : Logon

      ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

      Database driver error...

      Function Name : Connect

      Database Error: Failed to connect to database using user [test] and connection string [Oracle].].

       

      Oracle DB version: 11g (remote database)

      DB for Informatica: MSSQL 2019

       

      I checked connection test from ODBC config in windows and from Admin console of Informatica and it is successful.

      When I'm trying to run workflow using oracle dsn getting above error. (in Workflow Manager)

       

      All informatica services are in running state.

       

      Please help me out to fix this issue.

       

      Thanks,

      Akshay