Oracle BIEE 链接oracle 数据库的问题，报：Check if 'Oracle OCI 10G' database client is installed

环境：AIX 5305 64bit；oracle 10g(64bit);oracle BIEE 10;错误信息如下

 

[NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. 0509-022 Cannot load module /oracle/OracleBI/server/Bin/libnqsdbgatewayoci10g.so. 0509-150 Dependent module libclntsh.a(shr.o) could not be loaded. 0509-022 Cannot load module libclntsh.a(shr.o). 0509-026 System error: A file or directory in the path name does not exist. 0509-022 Cannot load module /oracle/OracleBI/server/Bin/libnqsdbgatewayoci10g.so. 0509-150 Dependent module /oracle/OracleBI/server/Bin/libnqsdbgatewayoci10g.so could not be loaded. [nQSError: 46029] Failed to load the DLL /oracle/OracleBI/server/Bin/libnqsdbgatewayoci10g.so. Check if 'Oracle OCI 10G' database client is installed. (HY000) 

在user.sh中设置了ORACLE_HOME LIBPATH TNS_ADMIN等参数后，报如下错误

[NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. 0509-022 Cannot load module /oracle/OracleBI/server/Bin/libnqsdbgatewayoci10g.so. 0509-150 Dependent module libclntsh.a(shr.o) could not be loaded. 0509-022 Cannot load module libclntsh.a(shr.o). 0509-026 System error: A file or directory in the path name does not exist. 0509-022 Cannot load module /oracle/OracleBI/server/Bin/libnqsdbgatewayoci10g.so. 0509-150 Dependent module /oracle/OracleBI/server/Bin/libnqsdbgatewayoci10g.so could not be loaded. [nQSError: 46029] Failed to load the DLL /oracle/OracleBI/server/Bin/libnqsdbgatewayoci10g.so. Check if 'Oracle OCI 10G' database client is installed. (HY000) 

再次在user.sh中修改LIPATH ,指向 ORACLE_HOME/lib32 仍然访问的是/oracle/app/product/10.2.0.1/lib/libclntsh.a,不是lib32下的。无论怎么修改，总是如此。最后迫不得已，使用lib32 替换了lib，结果报tnsname错误，其他应用也不能连接数据库。接着使用start64参数启动BIEE到64bit模式，也如此。最后的解决办法是，

使用lib32目录下的libclntsh.a文件，替换了lib下的libclntsh.a文件

替换后测试BIEE、Oracle DB、其他应用，一切正常。至此解决。

通过这个解决办法，认为本错误主要是 64bit和32bit的兼容问题。