Posted on 2010-11-24 09:24
winderain 阅读(2767)
评论(0) 编辑 收藏 所属分类:
DB
环境: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等参数后,报如下错误
1 [NQODBC] [SQL_STATE: HY000]
2 [nQSError: 10058] A general error has occurred.
3 0509-022 Cannot load module /oracle/OracleBI/server/Bin/libnqsdbgatewayoci10g.so.
4 0509-150 Dependent module /oracle/app/product/10.2.0.1/lib/libclntsh.a(shr.o) could not be loaded.
5 0509-103 The module has an invalid magic number.
6 0509-022 Cannot load module /oracle/OracleBI/server/Bin/libnqsdbgatewayoci10g.so.
7 0509-150 Dependent module /oracle/OracleBI/server/Bin/libnqsdbgatewayoci10g.so could not be loaded.
8 [nQSError: 46029] Failed to load the DLL /oracle/OracleBI/server/Bin/libnqsdbgatewayoci10g.so.
9 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的兼容问题。