Error In OBIEE With Oracle Client 11g: Could Not Load Module /Obi/Home/Server/Bin/Libnqsdbgatewayoci10g64.So (Doc ID 1088007.1)

Last updated on MARCH 08, 2017

Applies to:

Answers, Interactive Dashboard - Version 10.1.3.4.1 [1900] and later
Information in this document applies to any platform.
***Checked for relevance on 13-Sep-2013***

Symptoms

Oracle Business Intelligence Enterprise Edition (OBIEE) 10.1.3.4.1 on AIX 64-bit and OBIEE software is
also 64-bit. Oracle RDBMS 10.2.0.4.

Customer has now upgrade the Oracle client version from 10g to 11.2.0.1.0. In OBIEE, all the requests are now failing with:

Odbc driver returned an error (SQLExecDirectW).
Error Details
Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. Could not load module /OBI/home/server/Bin/libnqsdbgatewayoci10g64.so. The module has an invalid magic number. [nQSError: 46029] Failed to load the DLL /OBI/home/server/Bin/libnqsdbgatewayoci10g64.so. Check if 'Oracle OCI 10G' database client is installed. (HY000)

Using the following note, you can confirm Oracle 10.2.0.4 as source and Oracle client 11.2.0.1.0. are supported on OBIEE 10.1.3.4.1:

<Note 207303.1>: Client / Server / Interoperability Support Between Different Oracle Versions

In any case, using Oracle client 10.2.0.4, the requests continuining failing with the message:

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. Could not load module /OBI/home/server/Bin/libnqsdbgatewayoci10g.so. Dependent module /ORACLEBI/oracle/product/10/db/lib/libclntsh.a(shr.o) could not be loaded. The module has an invalid magic number. Could not load module /OBI/home/server/Bin/libnqsdbgatewayoci10g.so. Dependent module /OBI/home/server/Bin/libnqsdbgatewayoci10g.so could not be loaded. [nQSError: 46029] Failed to load the DLL /OBI/home/server/Bin/libnqsdbgatewayoci10g.so. Check if 'Oracle OCI 10G' database client is installed. (HY000)

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms