Oracle bug causing problems for data source connection (64-bit Windows, 32-bit client)

Troubleshooting

Problem

When creating a data source to an Oracle database on 64-bit Windows with a 32-bit Oracle client, an Oracle bug stops the connection from being successful. The following generic error message is returned by Cognos: "QE-DEF-0285 The logon failed" and "Test connection failed because of an error in initializing provider. ORA-06413: Connection not open"

Symptom

The following line should be seen within the sqlnet.log file:

Fatal NI connect error 6413, connecting to:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=host)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=service_name)(CID=(PROGRAM=<b>C:\Program Files (x86)</b>\cognos\bin\BmtMDProviderMain.exe)(HOST=host)(USER=user))))

[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Install and Config","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.2.2;10.2.1;10.2","Edition":"All Editions","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SS6G84","label":"IBM Cognos Analytics on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

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.

Was this topic helpful?

Document Information

More support for:
Cognos Business Intelligence

Software version:
10.2.2, 10.2.1, 10.2

Operating system(s):
Windows

Document number:
626069

Modified date:
08 May 2025

UID

swg21384623

IBM Support

Tips