DB2建nickname导致CRASH解决方法

-FRAME-- --CODE-- --LOCATION-- BFFE8E70 83C4286A 0x0083 + A_SHAFinalCommon                   (/opt/IBM/db2/V8.1/lib/libdb2e.so.1) BFFE8F00 8B55E48D 0x00ae + A_X931RandomUpdate                   (/home/oracle/OraHome1/lib/libclntsh.so.9.0) BFFE8F60 83C40CEB 0x00d0 + ztcrseed3                   (/home/oracle/OraHome1/lib/libclntsh.so.9.0)

　　这是DB2 II V8.2 和 Oracle 9i/10g 的一个兼容性问题.

　　如果是ORACLE 9i

Workaround:                                                              ============                                                             1) Back up your $ORACLE_HOME/lib/libclntsh.so and                        $ORACLE_HOME/bin/genclntsh                                               2) Add  '-Wl,-Bsymbolic' to the link line of $ORACLE_HOME/bin/genclntsh:              LD="gcc -shared -Wl,-relax -L${ORACLE_HOME}/lib -Wl,-Bsymbolic"         # shared library link command             3) Run genclntsh to create libclntsh.so                           4) Execute djxlinkOracle                                          5) Stop and Start the instance

　　如果是ORACLE 10g

Workaround:                                                              ============                                                             1) back up $ORACLE_HOME/bin/genclntsh,                                   $ORACLE_HOME/lib/libclntsh.so.10.1, $ORACLE_HOME/lib32/libclntsh.so.10.1 2) cd $ORACLE_HOME/lib;  mv libnnz10.so  libnnz10.so.orig     (so libnnz10.so not exist in lib)                                            3) cd $ORACLE_HOME/bin; modify the script genclntsh:                      a). Add "-Wl, -Bsymbolic" to linker line, .... make sure there is no    spaces between the comma and -B.                                                                   ex. LD="gcc -shared -Wl,-relax -L${ORACLE_HOME}/lib -Wl,-Bsymbolic"   # shared library link command      b)  Change libnnz10.so   ==> libnnz10.a in following line                 * -r ${OLIB}/libnnz10.so * && LNZ="-lnnz10