oracle 10.2.0.1 update 10.2.0.4 for aix 5.3
星期六, 一月 10th, 2009目前正在升级AIX 下的数据库，从10.2.0.1升级到10.2.0.4。大体步骤如下
一、准备回退的工作
备份如下：
1 操作系统 2 DB SOFT 3 数据 4 备份OCR VOTEDISK
二、升级前的一些OS补丁
xlc.rte.aix50.aug2005.ptf.tar.Z
uncompress xlc.rte.aix50.aug2005.ptf.tar.Z
tar -xvf xlc.rte.aix50.aug2005.ptf.tar
smit update_by_fix
xlc.rte.aix50.feb2007.ptf.tar.Z
uncompress xlc.rte.aix50.feb2007.ptf.tar.Z
tar -xvf xlc.rte.aix50.feb2007.ptf.tar
inutoc 跟上刚才解压的目录
smit update_all
三、系统修改一些参数
在集群软件运行的时候执行如下操作
chmod -R +w CRS_ORA_HOME/inventory/Templates/*
/usr/sbin/slibclean
/usr/bin/chuser capabilities=CAP_NUMA_ATTACH ，CAP_BYPASS_RAC_VMM ，CAP_PROPAGAT oracle
用/usr/sbin/lsuser -a capabilities oracle 确认下
四、升级CRS
srvctl stop database -d db_name
srvctl stop nodeapps -n node_name
crsctl stop crs
./runInstaller
一路点下去
执行两个脚本
/u01/app/oracle/product/10.2.0/crs/bin/crsctl stop crs
/u01/app/oracle/product/10.2.0/crs/install/root102.sh
目前工作到这，遇到几个问题
WARNING: directory '/oracle' is not owned by root
Preparing to recopy patched init and RC scripts.
Recopying init and RC scripts.
Startup will be queued to init within 30 seconds.
exec(): 0509-036 Cannot load program crsctl.bin because of the following errors:
0509-130 Symbol resolution failed for crsctl.bin because:
0509-136 Symbol __ct__Q2_3std8_LocinfoFPCci (number 176) is not exported from
dependent module /usr/lib/libC.a[ansi_64.o].
0509-192 Examine .loader section symbols with the
'dump -Tv' command.
解决方法：
Install IY73570: IBM C++ Runtime Environment Components for AIX PTF
If the compiler was installed:
Install XL C/C++ compiler 8.0.0.8
and then try to start Oracle Clusterware
2 个错误
运行脚本时，无法执行下去，
# /oraapp/oracle/crs/install/root102.sh
WARNING: directory '/oraapp/oracle' is not owned by root
WARNING: directory '/oraapp' is not owned by root
Preparing to recopy patched init and RC scripts.
Recopying init and RC scripts.
Startup will be queued to init within 30 seconds.
Starting up the CRS daemons.
Adding daemons to inittab
Waiting for the patched CRS daemons to start.
This may take a while on some systems.
看cssdout.log
priority string (4)
Warning : Current stack limit (4294967296) > (2097152). Resizing..
Info : RLIMIT_STACK set to : 2097152
mlockall: unable to lock pages (-1/1)
解决方法：
真不想说，不过没办法
必须把OS升级到5305或者以上，ORACLE也真行，README里有没，关键有问题了，给的字那么小，第一次安装的时候出了问题，曾经看到了没细看，结果重高一次还这样，恢复吧。哎，命苦的娃阿，一个晚上就这样折腾去了
priority string (4)
Warning : Current stack limit is set to UNLIMITED. Resizing..
Info : RLIMIT_STACK set to : 2097152
mlockall: unable to lock pages (-1/1)
.
The last error message is a 100% match with <a href="http://www.oralife.cn/wp-admin/ml2_documents.showDocument?p_id=739371.1&p_database_id=NOT">note:739371.1</a>
Solution:
You need to install AIX 5.3 TL5 (5300-05) or above.
<strong>*** 12/29/08 04:33 am *** (CHG: Sta->45)</strong>
<strong>*** 12/29/08 04:33 am ***</strong>
一、准备回退的工作
备份如下：
1 操作系统 2 DB SOFT 3 数据 4 备份OCR VOTEDISK
二、升级前的一些OS补丁
xlc.rte.aix50.aug2005.ptf.tar.Z
uncompress xlc.rte.aix50.aug2005.ptf.tar.Z
tar -xvf xlc.rte.aix50.aug2005.ptf.tar
smit update_by_fix
xlc.rte.aix50.feb2007.ptf.tar.Z
uncompress xlc.rte.aix50.feb2007.ptf.tar.Z
tar -xvf xlc.rte.aix50.feb2007.ptf.tar
inutoc 跟上刚才解压的目录
smit update_all
三、系统修改一些参数
在集群软件运行的时候执行如下操作
chmod -R +w CRS_ORA_HOME/inventory/Templates/*
/usr/sbin/slibclean
/usr/bin/chuser capabilities=CAP_NUMA_ATTACH ，CAP_BYPASS_RAC_VMM ，CAP_PROPAGAT oracle
用/usr/sbin/lsuser -a capabilities oracle 确认下
四、升级CRS
srvctl stop database -d db_name
srvctl stop nodeapps -n node_name
crsctl stop crs
./runInstaller
一路点下去
执行两个脚本
/u01/app/oracle/product/10.2.0/crs/bin/crsctl stop crs
/u01/app/oracle/product/10.2.0/crs/install/root102.sh
目前工作到这，遇到几个问题
WARNING: directory '/oracle' is not owned by root
Preparing to recopy patched init and RC scripts.
Recopying init and RC scripts.
Startup will be queued to init within 30 seconds.
exec(): 0509-036 Cannot load program crsctl.bin because of the following errors:
0509-130 Symbol resolution failed for crsctl.bin because:
0509-136 Symbol __ct__Q2_3std8_LocinfoFPCci (number 176) is not exported from
dependent module /usr/lib/libC.a[ansi_64.o].
0509-192 Examine .loader section symbols with the
'dump -Tv' command.
解决方法：
Install IY73570: IBM C++ Runtime Environment Components for AIX PTF
If the compiler was installed:
Install XL C/C++ compiler 8.0.0.8
and then try to start Oracle Clusterware
2 个错误
运行脚本时，无法执行下去，
# /oraapp/oracle/crs/install/root102.sh
WARNING: directory '/oraapp/oracle' is not owned by root
WARNING: directory '/oraapp' is not owned by root
Preparing to recopy patched init and RC scripts.
Recopying init and RC scripts.
Startup will be queued to init within 30 seconds.
Starting up the CRS daemons.
Adding daemons to inittab
Waiting for the patched CRS daemons to start.
This may take a while on some systems.
看cssdout.log
priority string (4)
Warning : Current stack limit (4294967296) > (2097152). Resizing..
Info : RLIMIT_STACK set to : 2097152
mlockall: unable to lock pages (-1/1)
解决方法：
真不想说，不过没办法
必须把OS升级到5305或者以上，ORACLE也真行，README里有没，关键有问题了，给的字那么小，第一次安装的时候出了问题，曾经看到了没细看，结果重高一次还这样，恢复吧。哎，命苦的娃阿，一个晚上就这样折腾去了
priority string (4)
Warning : Current stack limit is set to UNLIMITED. Resizing..
Info : RLIMIT_STACK set to : 2097152
mlockall: unable to lock pages (-1/1)
.
The last error message is a 100% match with <a href="http://www.oralife.cn/wp-admin/ml2_documents.showDocument?p_id=739371.1&p_database_id=NOT">note:739371.1</a>
Solution:
You need to install AIX 5.3 TL5 (5300-05) or above.
<strong>*** 12/29/08 04:33 am *** (CHG: Sta->45)</strong>
<strong>*** 12/29/08 04:33 am ***</strong>
