oracle psu无法开库,打11gR2第一个PSU遇到的问题

最近给oracle11g

release2的数据库打11.2.0.1.0打补丁p9778840_112010_Linux-x86-64.zip也就是PSU1，由于开始规划系统的时候

没有预料到11g

R2占用的空间比较多，在安装完后，grid和db存放的目录/u01一共只有不到2G的free空间，在使用opatch打补丁遇到如下错误：

[oracle@node1-11gr2-rac oradata]$ opatch napply -local -oh

/u01/grid/ -id 9778840,9352237

Invoking OPatch 11.2.0.1.2

Oracle Interim Patch Installer version 11.2.0.1.2

Copyright (c) 2010, Oracle Corporation. All rights

reserved.

UTIL session

Oracle Home : /u01/grid

Central Inventory : /u01/oraInventory

from : /etc/oraInst.loc

OPatch version : 11.2.0.1.2

OUI version :

11.2.0.1.0

OUI location :

/u01/grid//oui

Log file location :

/u01/grid/cfgtoollogs/opatch/opatch2010-07-08_15-33-17PM.log

Patch history file:

/u01/grid/cfgtoollogs/opatch/opatch_history.txt

Invoking utility "napply"

Checking conflict among patches...

Checking if Oracle Home has components required by patches...

Checking conflicts against Oracle Home...

OPatch continues with these patches: 9352237 9778840

Do you want to proceed? [y|n]

y

User Responded with: Y

Running prerequisite checks...

Prerequisite check "CheckSystemSpace" failed.

The details are:

Required amount of space(4563706644)

is not available.

UtilSession failed: Prerequisite check

"CheckSystemSpace" failed.

OPatch failed with error code 73

系统提示居然需要4.5G的空间才能打补丁，其实PSU解压后只有1G左右，有2G的空间打补丁应该够用。

于是想尝试修改opatch下的文件opatch_prereq.xml中关于

SEVERITY="Error"/>

NAME="CheckSystemSpace"

EXTERNALNAME="Does the system have enough space?"

EXTERNALNAMEID="S_CHECK_SYSTEM_SPACE@oracle.opatch.opatchprereq.OPatchPrereqRuntimeRes"

TEXTID="S_CHECK_SYSTEM_SPACE_DESCRIPTION@oracle.opatch.opatchprereq.OPatchPrereqRuntimeRes"/>

RULE="CheckSystemSpace" FILE=""

TEXT="Required amount of space is not present in the system."

删除掉CheckSystemSpace部分，但是opatch运行还是抱同样的错误。

检查了下metalink发现有个OPatch.SKIP_VERIFY_SPACE=true

的功能，可以忽略空间检查

[oracle@node1-11gr2-rac oradata]$ opatch napply

OPatch.SKIP_VERIFY_SPACE=true -local -oh /u01/grid/ -id

9778840,9352237

Invoking OPatch 11.2.0.1.2

Oracle Interim Patch Installer version 11.2.0.1.2

Copyright (c) 2010, Oracle Corporation. All rights

reserved.

UTIL session

Oracle Home : /u01/grid

Central Inventory : /u01/oraInventory

from : /etc/oraInst.loc

OPatch version : 11.2.0.1.2

OUI version :

11.2.0.1.0

OUI location :

/u01/grid//oui

Log file location :

/u01/grid/cfgtoollogs/opatch/opatch2010-07-08_16-07-14PM.log

Patch history file:

/u01/grid/cfgtoollogs/opatch/opatch_history.txt

Invoking utility "napply"

Checking conflict among patches...

Checking if Oracle Home has components required by patches...

Checking conflicts against Oracle Home...

OPatch continues with these patches: 9352237 9778840

Do you want to proceed? [y|n]

y

User Responded with: Y

Running prerequisite checks...

Provide your email address to be informed of security issues,

install and

initiate Oracle Configuration Manager. Easier for you if you use

your My

Oracle Support Email address/User Name.

Visit http://www.oracle.com/support/policies.html

for details.

Email address/User Name:

You have not provided an email address for notification of

security issues.

Do you wish to remain uninformed of security issues ([Y]es, [N]o)

[N]: y

You selected -local option, hence OPatch will patch the local

system only.

Please shutdown Oracle instances running out of this ORACLE_HOME on

the local system.

(Oracle Home = '/u01/grid')

Is the local system ready for patching? [y|n]

y

User Responded with: Y

Backing up files affected by the patch 'NApply' for restore. This

might take a while...

Execution of 'sh /oradata/9352237/custom/scripts/pre -apply 9352237

':

Return Code = 0

Applying patch 9352237...

ApplySession applying interim patch '9352237' to OH

'/u01/grid'

ApplySession: Optional component(s) [

oracle.oraolap, 11.2.0.1.0 ] not present in the Oracle Home

or a higher version is found.

Backing up files affected by the patch '9352237' for rollback. This

might take a while...

打补丁成功！最后结果：

[oracle@node1-11gr2-rac oradata]$ opatch lsinventory

Invoking OPatch 11.2.0.1.2

Oracle Interim Patch Installer version 11.2.0.1.2

Copyright (c) 2010, Oracle Corporation. All rights

reserved.

Oracle Home :

/u01/app/oracle

Central Inventory : /u01/oraInventory

from : /etc/oraInst.loc

OPatch version : 11.2.0.1.2

OUI version :

11.2.0.1.0

OUI location :

/u01/app/oracle/oui

Log file location :

/u01/app/oracle/cfgtoollogs/opatch/opatch2010-07-10_09-38-49AM.log

Patch history file:

/u01/app/oracle/cfgtoollogs/opatch/opatch_history.txt

Lsinventory Output file location :

/u01/app/oracle/cfgtoollogs/opatch/lsinv/lsinventory2010-07-10_09-38-49AM.txt

--------------------------------------------------------------------------------

Installed Top-level Products (1):

Oracle Database

11g 11.2.0.1.0

There are 1 products installed in this Oracle Home.

Interim patches (2) :

Patch 9352237 : applied on Sat Jul 10

09:32:01 CST 2010

Unique Patch ID: 12677125

Created on 25 Mar 2010,

00:05:17 hrs PST8PDT

Bugs fixed:

8661168, 8769239, 8898852, 8801119,

9054253, 8706590, 8725286, 8974548

8778277, 8780372, 8769569, 9027691,

9454036, 9454037, 9454038, 8761974

7705591, 8496830, 8702892, 8639114,

8723477, 8729793, 8919682, 8818983

9001453, 8475069, 9328668, 8891929,

8798317, 8820324, 8733749, 8702535

8565708, 9036013, 8735201, 8684517,

8870559, 8773383, 8933870, 8812705

8405205, 8822365, 8813366, 8761260,

8790767, 8795418, 8913269, 8897784

8760714, 8717461, 8671349, 8775569,

8898589, 8861700, 8607693, 8642202

8780281, 9369797, 8780711, 8784929,

8834636, 9015983, 8891037, 8828328

8570322, 8832205, 8665189, 8717031,

8685253, 8718952, 8799099, 8633358

9032717, 9321701, 8588519, 8783738,

8796511, 8782971, 8756598, 9454385

8856497, 8703064, 9066116, 9007102,

8721315, 8818175, 8674263, 9352237

8753903, 8720447, 9057443, 8790561,

8733225, 9197917, 8928276, 8991997, 8837736

Patch 9778840 : applied on Sat Jul 10

09:15:09 CST 2010

Unique Patch ID: 12677125

Created on 8 Jun 2010,

22:14:20 hrs PST8PDT

Bugs fixed:

9778840, 9783609

Rac system comprising of multiple nodes

Local node = node1-11gr2-rac

Remote node = node2-11gr2-rac