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.

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

[{"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"}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Product Synonym

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

Was this topic helpful?

Document Information

More support for:
IBM InfoSphere Master Data Management

Component:
Database, JDBC, ODBC

Software version:
11.6.0, 12.0.0

Document number:
7183880

Modified date:
21 February 2025

UID

ibm17183880

IBM Support

Tips