Posted on 2010-11-24 09:24
winderain 閱讀(2778)
評論(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的兼容問題。