AIX上完成了11gR2 RAC 11.2.0.2至11.2.0.3的PatchSet升级后,,在安装PSU过程中遇到以下问题:
PSU下载地址:
Oracle Recommended Patches — Oracle Database [ID 756671.1]
根据文档说明:
11.2.0.3 Current Recommended Patches
Patch Set Updates
Document
Description
Rolling RAC
Patch Download
Note:13343438.8
11.2.0.3.1 Patch Set Update (PSU)
Yes
Grid Infrastructure
Document
Description
Rolling RAC
Patch Download
Note:13348650.8
11.2.0.3.1 Grid Infrastructure Patch Set Update (GI PSU)
Yes
Also see:
Note:1392633.1Common Performance/Wrong Results Bugs Reported on 11.2.0.3
其中patch 13348650已经包含了patch 13343438,因此只需要下载13348650
解压后如下的目录如下:
[grid@p520 soft]$ ls
13343438 13348650
这PSU程序太大了,下载1G,解压6G
[p520]/soft #ls
13343438 13348650 README.html README.txt bundle.xml lost+found
[p520]/soft #du -sm
6028.86 .
在安装过程中,进行到以下步骤时,opatch失败:
[root@p520 soft]# /oracle/app/11.2.0.3/grid/OPatch/opatch auto /soft -oh
/oracle/app/11.2.0.3/grid -ocmrf /tmp/oracle/ocm.rsp
2012-04-01 17:46:09: patch //soft/13348650 apply failed for home
/oracle/app/11.2.0.3/grid
分析安装日志,发现报错如下:
Verifying environment and performing prerequisite checks…
Prerequisite check “CheckSystemSpace” failed.
The details are:
Required amount of space(23420.604MB) is not available.
UtilSession failed:
Prerequisite check “CheckSystemSpace” failed.
Log file location: /oracle/app/11.2.0.3
/grid/cfgtoollogs/opatch/opatch2012-04-01_17-46-03PM_1.log
OPatch failed with error code 73
晕到,安装一个PSU居然空闲空间至少23个G,我的空间情况如下:
[p520]/soft #df -g
Filesystem GB blocks Free %Used Iused %Iused Mounted on
/dev/hd4 1.00 0.68 32% 11004 7% /
/dev/hd2 7.00 1.14 84% 65951 19% /usr
/dev/hd9var 1.00 0.65 35% 8433 5% /var
/dev/hd3 2.00 1.74 13% 2126 1% /tmp
/dev/hd1 1.00 1.00 1% 129 1% /home
/dev/hd11admin 0.25 0.25 1% 5 1% /admin
/proc – – – – – /proc
/dev/hd10opt 1.00 0.78 22% 9070 5% /opt
/dev/livedump 0.25 0.25 1% 4 1%
/var/adm/ras/livedump
/dev/oralv 48.00 10.61 78% 127133 5% /oracle
根据metalink上文档介绍:
opatch CheckSystemSpace Fails With Error Code 73 While Applying GI PSU [ID1088455.1]
Cause:
OPATCH needs about 4.4GB of disk space in $GRID_HOME to apply PSU patch,
the issue happened as there’s insufficient space.
On AIX, due to unpublished bug 9780505, space requirement is 22GB
没办法,只能增加/oracle文件系统的空间继续安装PSU。
所以建议各位在升级的时候一定要考虑到空间问题。
更多Oracle相关信息见Oracle 专题页面 ?tid=12