11gR2 GI打PSU ORACLE_HOME空间不足案例—需要20G以上空闲空间

GI打auto打patch命令 #/u01/oracle/app/grid/OPatch/opatch auto /u01/soft/18706472 -ocmrf /u01/soft/ocm.rspExecuting /u01/oracle/app/grid/perl/bin/perl /u01/oracle/app/grid/OPatch/crs/patch11203.pl -patchdir /u01/soft -patchn 18706472 -ocmrf

GI打auto打patch命令

#/u01/oracle/app/grid/OPatch/opatch auto /u01/soft/18706472 -ocmrf /u01/soft/ocm.rspExecuting /u01/oracle/app/grid/perl/bin/perl /u01/oracle/app/grid/OPatch/crs/patch11203.pl -patchdir /u01/soft -patchn 18706472 -ocmrf /u01/soft/ocm.rsp -paramfile /u01/oracle/app/grid/crs/install/crsconfig_paramsThis is the main log file: /u01/oracle/app/grid/cfgtoollogs/opatchauto2014-10-15_01-15-28.logThis file will show your det<span style="color:transparent">本文来源gaodai#ma#com搞*!代#%^码网%</span>ected configuration and all the steps that opatchauto attempted to do on your system:/u01/oracle/app/grid/cfgtoollogs/opatchauto2014-10-15_01-15-28.report.log2014-10-15 01:15:28: Starting Clusterware Patch SetupUsing configuration parameter file: /u01/oracle/app/grid/crs/install/crsconfig_paramsStopping CRS...Stopped CRS successfullypatch /u01/soft/18706472/18522509  apply successful for home  /u01/oracle/app/grid patch /u01/soft/18706472/18522515  apply failed  for home  /u01/oracle/app/gridStarting CRS...Installing Trace File AnalyzerCRS-4123: Oracle High Availability Services has been started.opatch auto succeeded.

这里可以看到,打patch 18522509成功,后续patch都失败,而不是仅仅18522515失败

分析错误日志

Composite patch 18522509 successfully applied. OPatch Session completed with warnings. Log file location: /u01/oracle/app/grid/cfgtoollogs/opatch/opatch2014-10-15_01-19-00AM_1.log OPatch completed with warnings.2014-10-15 01:21:44: patch /u01/soft/18706472/18522509  apply successful for home  /u01/oracle/app/grid2014-10-15 01:21:44: Executing command /u01/oracle/app/grid/OPatch/opatch napply /u01/soft/18706472/18522515 -local -silent -ocmrf /u01/soft/ocm.rsp -oh /u01/oracle/app/grid -invPtrLoc /u01/oracle/app/grid/oraInst.loc as grid2014-10-15 01:21:44: Running as user grid: /u01/oracle/app/grid/OPatch/opatch napply /u01/soft/18706472/18522515 -local -silent -ocmrf /u01/soft/ocm.rsp -oh /u01/oracle/app/grid -invPtrLoc /u01/oracle/app/grid/oraInst.loc2014-10-15 01:21:44: s_run_as_user2: Running /bin/su grid -c ' /u01/oracle/app/grid/OPatch/opatch napply /u01/soft/18706472/18522515 -local -silent -ocmrf /u01/soft/ocm.rsp -oh /u01/oracle/app/grid -invPtrLoc /u01/oracle/app/grid/oraInst.loc '2014-10-15 01:21:49: Removing file /tmp/uaa7jC7eu2014-10-15 01:21:49: Successfully removed file: /tmp/uaa7jC7eu2014-10-15 01:21:49: /bin/su exited with rc=732014-10-15 01:21:49: status of apply patch is 186882014-10-15 01:21:49: The apply patch output is Oracle Interim Patch Installer version 11.2.0.3.6 Copyright (c) 2013, Oracle Corporation.  All rights reserved. Oracle Home       : /u01/oracle/app/grid Central Inventory : /u01/oracle/app/oraInventory    from           : /u01/oracle/app/grid/oraInst.loc OPatch version    : 11.2.0.3.6 OUI version       : 11.2.0.4.0 Log file location : /u01/oracle/app/grid/cfgtoollogs/opatch/opatch2014-10-15_01-21-44AM_1.log Verifying environment and performing prerequisite checks... Prerequisite check "CheckSystemSpace" failed. The details are: Required amount of space(24021.839MB) is not available. UtilSession failed: Prerequisite check "CheckSystemSpace" failed. Log file location: /u01/oracle/app/grid/cfgtoollogs/opatch/opatch2014-10-15_01-21-44AM_1.log OPatch failed with error code 73

这里可以看出来,patch 18522509 成功,但是18522515在check的时候失败,由于$ORACLE_HOME(GI)需要可用空间为24021.839MB,现在空闲空间不足

查看空间并腾空间

# df -gFilesystem    GB blocks      Free %Used    Iused %Iused Mounted on/dev/hd4          10.00      9.56    5%    12443     1% //dev/hd2          15.00     11.42   24%    60339     3% /usr/dev/hd9var       10.00      9.91    1%     3310     1% /var/dev/hd3          10.00      9.65    4%      364     1% /tmp/dev/hd1          10.00     10.00    1%       32     1% /home/dev/hd11admin      0.25      0.25    1%        5     1% /admin/proc                 -         -    -         -     -  /proc/dev/hd10opt      10.00      8.98   11%    12401     1% /opt/dev/fslv00       50.00     12.94   75%    59137     2% /u01/dev/odm           0.00      0.00   -1%        6   100% /dev/odm/dev/vx/dsk/crs_dg/crs_vol      1.96      1.75   12%        5     1% /crsdata/dev/vx/dsk/ora_dg/data01_vol   2048.00   2031.32    1%        4     1% /oradata/data01/dev/vx/dsk/ora_dg/sys_vol    400.00    350.29   13%     3702     1% /oradata/sys# cd /u01# lslost+found  oracle      soft# cd soft# du -sg17.34   .# mv /u01/soft /oradata/sys/# df -gFilesystem    GB blocks      Free %Used    Iused %Iused Mounted on/dev/hd4          10.00      9.56    5%    12443     1% //dev/hd2          15.00     11.42   24%    60339     3% /usr/dev/hd9var       10.00      9.91    1%     3310     1% /var/dev/hd3          10.00      9.65    4%      364     1% /tmp/dev/hd1          10.00     10.00    1%       32     1% /home/dev/hd11admin      0.25      0.25    1%        5     1% /admin/proc                 -         -    -         -     -  /proc/dev/hd10opt      10.00      8.98   11%    12401     1% /opt/dev/fslv00       50.00     27.56   45%    59137     2% /u01/dev/odm           0.00      0.00   -1%        6   100% /dev/odm/dev/vx/dsk/crs_dg/crs_vol      1.96      1.75   12%        5     1% /crsdata/dev/vx/dsk/ora_dg/data01_vol   2048.00   2031.32    1%        4     1% /oradata/data01/dev/vx/dsk/ora_dg/sys_vol    400.00    333.54   14%     3702     1% /oradata/sys# cd soft# ls -ltrtotal 12464202drwxr-xr-x    5 grid     dba            1024 Jul 07 21:06 18706472-rw-rw-r--    1 grid     dba            2123 Jul 15 20:06 PatchSearch.xml-rw-r--r--    1 root     system   1801653734 Oct 14 14:39 p13390677_112040_aix64-5l_1of7.zip-rw-r--r--    1 root     system   1170882875 Oct 14 14:40 p13390677_112040_aix64-5l_2of7.zip-rw-r--r--    1 root     system   2127071138 Oct 14 14:41 p13390677_112040_aix64-5l_3of7.zip-rw-r--r--    1 root     system   1242090126 Oct 14 14:43 p18706472_112040_AIX64-5L.zip-rw-r--r--    1 root     system     34964928 Oct 14 14:43 p6880880_112000_AIX64-5L.zip-rwxr-xr-x    1 root     system       127965 Oct 14 14:48 unzip_aix-rw-r--r--    1 root     system      4871110 Oct 14 14:50 ONEOFF_112043_AIX64.zipdrwxr-xr-x    8 grid     dba            1024 Oct 14 14:55 griddrwxr-xr-x    8 oracle   dba            1024 Oct 14 14:57 database-rw-r--r--    1 grid     dba             621 Oct 15 00:11 ocm.rsp

确实/u01空间不足,通过把RAC安装文件迁移到其他目录,确保/u01有足够空间用来打patch

回退命令

# /u01/oracle/app/grid/OPatch/opatch auto /u01/soft/18706472 -rollback -ocmrf /u01/soft/ocm.rsp

重新打patch

#/u01/oracle/app/grid/OPatch/opatch auto /u01/soft/18706472 -ocmrf /u01/soft/ocm.rsp                 <Executing /u01/oracle/app/grid/perl/bin/perl /u01/oracle/app/grid/OPatch/crs/patch11203.pl -patchdir /oradata/sys/soft -patchn 18706472 -ocmrf /oradata/sys/soft/ocm.rsp -paramfile /u01/oracle/app/grid/crs/install/crsconfig_paramsThis is the main log file: /u01/oracle/app/grid/cfgtoollogs/opatchauto2014-10-15_01-57-42.logThis file will show your detected configuration and all the steps that opatchauto attempted to do on your system:/u01/oracle/app/grid/cfgtoollogs/opatchauto2014-10-15_01-57-42.report.log2014-10-15 01:57:42: Starting Clusterware Patch SetupUsing configuration parameter file: /u01/oracle/app/grid/crs/install/crsconfig_paramsStopping CRS...Stopped CRS successfullypatch /oradata/sys/soft/18706472/18522509  apply successful for home  /u01/oracle/app/grid patch /oradata/sys/soft/18706472/18522515  apply successful for home  /u01/oracle/app/grid patch /oradata/sys/soft/18706472/18522514  apply successful for home  /u01/oracle/app/grid Starting CRS...Installing Trace File AnalyzerCRS-4123: Oracle High Availability Services has been started.opatch auto succeeded.

检查确认patch成功

# su - gridxifenfei1:/home/grid> opatch lspatches18522514;ACFS PATCH SET UPDATE : 11.2.0.4.3 (18522514)18522515;OCW Patch Set Update : 11.2.0.4.3 (18522515)18522509;Database Patch Set Update : 11.2.0.4.3 (18522509)xifenfei1:/home/grid> crsctl status res -t--------------------------------------------------------------------------------NAME           TARGET  STATE        SERVER                   STATE_DETAILS       --------------------------------------------------------------------------------Local Resources--------------------------------------------------------------------------------ora.LISTENER.lsnr               ONLINE  ONLINE       xifenfei1                                                    ONLINE  ONLINE       xifenfei2                                     ora.asm               OFFLINE OFFLINE      xifenfei1                                                    OFFLINE OFFLINE      xifenfei2                                     ora.gsd               OFFLINE OFFLINE      xifenfei1                                                    OFFLINE OFFLINE      xifenfei2                                     ora.net1.network               ONLINE  ONLINE       xifenfei1                                                    ONLINE  ONLINE       xifenfei2                                     ora.ons               ONLINE  ONLINE       xifenfei1                                                    ONLINE  ONLINE       xifenfei2                                     ora.registry.acfs               OFFLINE OFFLINE      xifenfei1                                                    OFFLINE OFFLINE      xifenfei2                                     --------------------------------------------------------------------------------Cluster Resources--------------------------------------------------------------------------------ora.LISTENER_SCAN1.lsnr      1        ONLINE  ONLINE       xifenfei2                                     ora.cvu      1        ONLINE  ONLINE       xifenfei2                                     ora.xifenfei1.vip      1        ONLINE  ONLINE       xifenfei1                                     ora.xifenfei2.vip      1        ONLINE  ONLINE       xifenfei2                                     ora.oc4j      1        ONLINE  ONLINE       xifenfei2                                     ora.scan1.vip      1        ONLINE  ONLINE       xifenfei2                                     

• 打patch出现Copy failed—tfa服务导致部分lib未释放
• 11.2.0.4 GI单独安装tfa
• OLR相关维护
• Oracle 小升级 opatch apply使用
• 因asm sga_target设置不当导致11gr2 rac无法正常启动
• 在11GR2 GI上配置第二个监听
• ORACLE 12C RAC修改ocr/votedisk/asm spfile所在磁盘组名称
• 10.2.0.x升级到10.2.0.5.5

原文地址：11gR2 GI打PSU ORACLE_HOME空间不足案例—需要20G以上空闲空间, 感谢原作者分享。

喜欢 (0)赏

[搞代码]

分享 (0)