ERP 在 AIX 的32位操作系统和64位操作系统之间互相迁移

 原来的环境：AIX4.3，32位。ERP是11.5.7，DB是8173。

新的环境：AIX5L，64位。

 

5L上面需要打Oracle的补丁让他支持32位的，否则数据库起不来。基本上很顺利，直接拷贝，clone即可

迁移过程中的问题如下：

问题一

exec(): 0509-036 Cannot load program svrmgrl because of the following errors:
        0509-130 Symbol resolution failed for svrmgrl because:
        0509-136   Symbol pw_post (number 262) is not exported from
                   dependent module /unix.
        0509-136   Symbol pw_wait (number 263) is not exported from
                   dependent module /unix.
        0509-136   Symbol pw_config (number 264) is not exported from
                   dependent module /unix.
        0509-136   Symbol aix_ora_pw_version3_required (number 265) is not exported from
                   dependent module /unix.
        0509-192 Examine .loader section symbols with the
                 'dump -Tv' command.

问题二

$ svrmgrl

Oracle Server Manager Release 3.1.7.0.0 - Production

Copyright (c) 1997, 1999, Oracle Corporation.  All Rights Reserved.

exec(): 0509-036 Cannot load program oracleTEST because of the following errors:
        0509-150   Dependent module libobk.a(shr.o) could not be loaded.
        0509-022 Cannot load module libobk.a(shr.o).
        0509-026 System error: A file or directory in the path name does not exi
st.
exec(): 0509-036 Cannot load program oracleTEST because of the following errors:
        0509-150   Dependent module libobk.a(shr.o) could not be loaded.
        0509-022 Cannot load module libobk.a(shr.o).
        0509-026 System error: A file or directory in the path name does not exi
st.
ORA-12547: TNS:lost contact

 

如果又要从64为迁回32位，那当然也是不能直接运行，需要在DB和AP的用户下分别运行relink动作才可以，AP如果不做Link会出现下列类似错误：

exec(): 0509-036 Cannot load program f60webmx because of the following errors:
        0509-130 Symbol resolution failed for /compard/testora/8.0.6/lib/libiwfw.so because:
        0509-136   Symbol ___bzero (number 5) is not exported from
                   dependent module /usr/lib/libc.a(shr.o).
        0509-136   Symbol ___memmove (number 6) is not exported from
                   dependent module /usr/lib/libc.a(shr.o).
        0509-136   Symbol ___fill (number 7) is not exported from
                   dependent module /usr/lib/libc.a(shr.o).
        0509-192 Examine .loader section symbols with the
                 'dump -Tv' command.

Relink结束后, 执行一下f60gen等看看，如果错误还存在，需要重新产生一下Oracle的lib文件，执行下列步骤之前，先备份lib下的文件

cd $ORACLE_HOME/lib
$ORACLE_HOME/bin/genshlib iwf 0
$ORACLE_HOME/bin/genshlib iwfw 0
$ORACLE_HOME/bin/genshlib iff 0
$ORACLE_HOME/bin/genshlib iffw 0

数据库上面的relink步骤如下：

To relink Oracle executables:
核对ORACLE_HOME是否正确，LD_LIBRARY_PATH 变量是否包含$ORACLE_HOME/lib.
常用的relink命令：
– relink all (relinks all Oracle executables)
– relink oracle (relinks the database executables)
– relink network (relinks listener, cman, names)
– relink oemagent (relinks the Intelligent Agent)
– relink utilities (relinks sqlplus, imp, exp)
– relink ctx (relinks Oracle Text)

 

 结束。