IBM Support

Why am I getting "[MasterDataManagement][ODBC Oracle Wire Protocol driver][Oracle] Unexpected Network Error" on new Oracle 19c database connection?

Question & Answer


Question

 
While installing Infosphere Master Data Management Advanced Edition (MDM AE) in a new production server, we are getting the  below error when connecting to an Oracle 19c database server:
 
STATE=HY000, CODE=-5, MSG=[MasterDataManagement][ODBC Oracle Wire Protocol driver][Oracle]Unexpected Network Error. 
 
It was also noticed when performing a test_datasource through madconfig and the error can be reproduced.
 

The exact error message is :

[serviceisaeprod@iaeplpc1app01 scripts]$ ./madconfig.sh test_datasource

Buildfile: /WebAS/MDM/MDM_PROD_PR_D_AMER/mds/scripts/build.xml

Trying to override old definition of task executeUpdateScript

madenv_init:

madenv_exec_init:

madenv_odbc_driver_init:

test_datasource:

Running ODBC SQL statement [select 1 from dual;]...

Executing /WebAS/MDM/MDM_PROD_PR_D_AMER/mds/bin/madsql

/WebAS/MDM/MDM_PROD_PR_D_AMER/mds/bin/madsql: STATE=HY000, CODE=-5, MSG=[MasterDataManagement][ODBC Oracle Wire Protocol driver][Oracle]Unexpected Network Error.

/WebAS/MDM/MDM_PROD_PR_D_AMER/mds/bin/madsql: STATE=HY000, CODE=-5, MSG=[MasterDataManagement][ODBC Oracle Wire Protocol driver][Oracle]Unexpected Network Error.

Result: 1

Return Code: 1, Time elapsed: 0.149 sec

BUILD FAILED

/WebAS/MDM/MDM_PROD_PR_D_AMER/mds/scripts/build-utils-config.xml:1225: ERROR: Unable to connect to the IBM InfoSphere MDM database via ODBC.

Total time: 2 seconds

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

The Oracle driver version being used is 08.02.2178 (B0386, U0258):

$ strings o6ora28.so | grep "08\.0" 

08.02.2178 (B0386, U0258)

run strings o6ora28.so | grep "08\.0 to gather the datadirect driver version

 
 

Cause

The 8.0 Oracle Wire Protocol driver was not certified with Oracle 19c until October, 2019. The certification was done with driver build 08.02.2245 (B0498, U0347), which is later than the driver version being used.

Answer

Test with the latest available version driver build since the 08.02.2245 driver version was not certified and there are fixes that may apply.  
 
The version driver build that worked is 08.02.3371 (B23PROGRESS_DATADIRECT_ODBC_ORACLE_8.0.2_LINUX_64.tgz74, U2242).

[{"Type":"MASTER","Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSWSR9","label":"IBM InfoSphere Master Data Management"},"ARM Category":[{"code":"a8m0z000000cvpMAAQ","label":"Database, JDBC, ODBC"}],"ARM Case Number":"TS018448740","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.6.0;12.0.0"}]

Historical Number

TS021519001;TS020430413

Product Synonym

Infosphere Master Data Management, Master Data Management, MDM AE, MDM, AE, Physical MDM

Document Information

Modified date:
21 February 2025

UID

ibm17183880

Page Feedback