Datadirect Odbc Oracle Wire Protocol Driver Invalid Precision Value

Posted : admin On 28.08.2019
Datadirect Odbc Oracle Wire Protocol Driver Invalid Precision Value 3,5/5 5389 votes

DataDirectODBC Oracle Wire Protocol driverOracleORA-28040: No matching authentication protocol (Doc ID 2399847.1) Last updated on AUGUST 26, 2019. Applies to: Hyperion Essbase - Version 11.1.2.4.000 and later Information in this document applies to any platform.

Troubleshooting


Problem

An InfoSphere DataStage job using ODBC fails to connect to Oracle. The job log shows the error:[IBM(DataDirect OEM)][ODBC Oracle Wire Protocol driver][Oracle]TNS-12505: TNS:listener could not resolve SID given in connect descriptor

Cause

Protocol

This error message is being sent by Oracle and is stating that the value for the Oracle SID specified in the .odbc.ini for this DSN is invalid. This problem may happen if the Oracle Database is not running or if the SID specified in the .odbc.ini file is incorrect.

Datadirect odbc oracle wire protocol driver invalid precision value error

Resolving The Problem

To fix this problem first make sure that you are able to connect to this database outside of DataStage. If that works, then edit the $DSHOME/.odbc.ini file and enter the proper value for the SID of this DSN. Please ask your Oracle DBA to help you get the SID of the database to which you are connecting. This information can be obtained by inspecting the tnsnames.ora file.

Datadirect Odbc Oracle Wire Protocol Driver Invalid Precision Value List

[{'Product':{'code':'SSVSEF','label':'InfoSphere DataStage'},'Business Unit':{'code':'BU001','label':'Analytics Private Cloud'},'Component':'--','Platform':[{'code':'PF002','label':'AIX'},{'code':'PF010','label':'HP-UX'},{'code':'PF016','label':'Linux'},{'code':'PF027','label':'Solaris'}],'Version':'8.1;8.0.1;7.5','Edition':'}]

Document Information

Modified date:
16 June 2018