5 Replies Latest reply on Jul 6, 2021 12:27 AM by Rakshitha K. R.

    ODBC Driver Error - DataDirect CLOSED 8.0 Oracle Wire Protocol for Informatica - R36

    Rob Schrage New Member

      Scenario:

       

      1) Installed Informatica Cloud Sercure Agent version 59.17 on on-prem Windows Server 2019 version 10.0 with amd64 architecture.  Agent is running and can be accessed from Informatica Cloud.

      2) Created oracle connection in Informatica cloud with a successful test connection.  Oracle version is 12c.

      3) Created a mapping mapping with oracle as a target.  Target was able to find desired table target in oracle schema and select target columns to map to.

      4) When mapping was run, the following error was generated:

       

      WRITER_1_*_1> WRT_8147 [2021-06-24 15:59:43.343] Writer: Target is database [odbc://dbtype=Oracle;host={host_name};port=1521;database={db_name}], user [{db_user_name}], bulk mode [OFF]

      WRITER_1_*_1> CMN_1021 [2021-06-24 15:59:43.344] Database driver event...

      CMN_1021 [Driver Manager used is [Data Direct].]

      WRITER_1_*_1> CMN_1761 [2021-06-24 16:01:50.543] Timestamp Event: [Thu Jun 24 16:01:50 2021]

      WRITER_1_*_1> WRT_8001 [2021-06-24 16:01:50.543] Error connecting to database...

      WRT_8001 [Session s_mtt_01751P0Z00000000001Z Username {db_user_name} DB Error -1

      [Informatica][ODBC Oracle Wire Protocol driver]Connection refused. Verify Host Name and Port Number.[Informatica][ODBC Oracle Wire Protocol driver][Oracle]ORA-12203: unable to connect to destination

      Database driver error...

      Function Name : Connect

      Database driver error...

      Function Name : Connect

      Database Error: Failed to connect to database using user [{db_user_name}] and connection string [Driver=DataDirect CLOSED 8.0 Oracle Wire Protocol for Informatica - R36;Host={host_name};ServiceName={db_name};Port=1521;UID={db_user_name};AS=6000000;EBL=0;ENS=1;IACP=4;ETWT=1;WorkArounds2=2;AllowedOpenSSLVersions=1.0.2;EnableEmptyLobs=1].]

       

      Troubleshooting Tasks Completed :

       

      - Verfied connection string information using sqlplus on server where agent is running.  Was able to insert record into target database.

      - Verified that your Oracle_Home\bin is within your path.

      - Verified that the TNSNAMES.ORA resides in the ORACLE_HOME\NETWORK\ADMIN directory.

      - Checked the SQLNET.LOG file in the ORACLE_HOME\NETWORK\LOG directory. No log files present.

      - Restarted the Oracle Server

      - Checked registry key Computer\HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\DataDirect CLOSED 8.0 Oracle Wire Protocol for Informatica - R36

      "Driver" and "Setup" set to C:\Program Files\Informatica Cloud Secure Agent\drivers\odbc\datadirect\r36\dwora28.dll

       

       

      Questions:

       

      1) How do I solve this database error?  Why can I query the schema in my mapping but receive an error when the task runs?

      2) Should the DataDirect CLOSED 8.0 Oracle Wire Protocol for Informatica - R36 show up in the User DSN or System DSN or Driver Tabs in the ODBC Data Administrator windows tool? I am wondering if the installation of the driver silently failed while installing the informatica cloud secure agent.