Oracle 11.2.0.4.3 PSU For 11.2.0.4 RAC LINUX X86-64 installation

安装文件 p18706472_112040_Linux-x86-64.zip 大小居然已经500M+了.

需要的opatch版本是最新的11.2.0.3.6，所以需要到Oracle MOS上下载，docid是6880880

unzip <OPATCH-ZIP> -d <ORACLE_HOME>

 

安装的话非常简单，安装readme去做。

我的环境是grid跟oracle用户的软件都分开的，下面就按照这种情况来做。

安装需要OCM.rsp文件，生成是参照If you do not have the OCM response file (ocm.rsp), see the following My Oracle Support Document966023.1How To Create An OCM Response File For Opatch Silent Installation.

 

 

 

我以GI用户登录，执行

cd /tmp

$GRID_HOME/OPatch/ocm/bin/emocmrsp

这样执行了之后，会在当前目录/tmp下生成一个OCM.rsp文件

 

在升级之前将oracle crs起来，数据库跟dbconsole down下去

srvctl stop instance -d orcl -i orcl1

emctl stop dbconsole

下面的列表是我安装的时候oracle执行的步骤，实际安装的时候可以按照这个列表的check的步骤先执行一下看看。

 1-10,13-14是check语句，可以先手工运行检查一下。

<p>crs_home=/u01/app/11.2.0.4/grid version=11.2.0.4.0      owner=oracle      opatch_ver=11.2.0.3.6rac_home=/u01/app/oracle/product/11.2.0.4/db_1  version=11.2.0.4.0      owner=oracle      opatch_ver=11.2.0.3.6</p><p>*********** Steps to be executed as owner unless specified as root ***********</p><p>1: /u01/app/oracle/product/11.2.0.4/db_1/OPatch/opatch prereq CheckComponents -ph /tmp/orasoft/18706472/18522509 -oh /u01/app/oracle/product/11.2.0.4/db_1</p><p>2: /u01/app/oracle/product/11.2.0.4/db_1/OPatch/opatch prereq CheckComponents -ph /tmp/orasoft/18706472/18522515/custom/server/18522515 -oh /u01/app/oracle/product/11.2.0.4/db_1</p><p>3: /u01/app/oracle/product/11.2.0.4/db_1/OPatch/opatch prereq CheckConflictAgainstOH -ph /tmp/orasoft/18706472/18522509 -oh /u01/app/oracle/product/11.2.0.4/db_1</p><p>4: /u01/app/oracle/product/11.2.0.4/db_1/OPatch/opatch prereq CheckConflictAgainstOH -ph /tmp/orasoft/18706472/18522515/custom/server/18522515 -oh /u01/app/oracle/product/11.2.0.4/db_1</p><p>5: /u01/app/11.2.0.4/grid/OPatch/opatch prereq CheckComponents -ph /tmp/orasoft/18706472/18522509 -oh /u01/app/11.2.0.4/grid</p><p>6: /u01/app/11.2.0.4/grid/OPatch/opatch prereq CheckComponents -ph /tmp/orasoft/18706472/18522515 -oh /u01/app/11.2.0.4/grid</p><p>7: /u01/app/11.2.0.4/grid/OPatch/opatch prereq CheckComponents -ph /tmp/orasoft/18706472/18522514 -oh /u01/app/11.2.0.4/grid</p><p>8: /u01/app/11.2.0.4/grid/OPatch/opatch prereq CheckConflictAgainstOH -ph /tmp/orasoft/18706472/18522509 -oh /u01/app/11.2.0.4/grid</p><p>9: /u01/app/11.2.0.4/grid/OPatch/opatch prereq CheckConflictAgainstOH -ph /tmp/orasoft/18706472/18522515 -oh /u01/app/11.2.0.4/grid</p><p>10: /u01/app/11.2.0.4/grid/OPatch/opatch prereq CheckConflictAgainstOH -ph /tmp/orasoft/18706472/18522514 -oh /u01/app/11.2.0.4/grid</p><p>11: /u01/app/oracle/product/11.2.0.4/db_1/bin/emctl stop dbconsole</p><p>12: /u01/app/oracle/product/11.2.0.4/db_1/bin/emctl stop agent</p><p>13: /u01/app/oracle/product/11.2.0.4/db_1/OPatch/opatch prereq CheckApplicable -ph /tmp/orasoft/18706472/18522509 -oh /u01/app/oracle/product/11.2.0.4/db_1</p><p>14: /u01/app/oracle/product/11.2.0.4/db_1/OPatch/opatch prereq CheckApplicable -ph /tmp/orasoft/18706472/18522515/custom/server/18522515 -oh /u01/app/oracle/product/11.2.0.4/db_1</p><p>15: /u01/app/oracle/product/11.2.0.4/db_1/bin/srvctl stop home -o /u01/app/oracle/product/11.2.0.4/db_1 -s /u01/app/oracle/product/11.2.0.4/db_1/srvm/admin/stophome.txt -n rac0402</p><p>16: /tmp/orasoft/18706472/18522515/custom/server/18522515/custom/scripts/prepatch.sh -dbhome /u01/app/oracle/product/11.2.0.4/db_1</p><p>17: /u01/app/oracle/product/11.2.0.4/db_1/OPatch/opatch napply /tmp/orasoft/18706472/18522509 -local -silent -ocmrf /tmp/ocm.rsp -oh /u01/app/oracle/product/11.2.0.4/db_1 -invPtrLoc /u01/app/oracle/product/11.2.0.4/db_1/oraInst.loc</p><p>18: /u01/app/oracle/product/11.2.0.4/db_1/OPatch/opatch napply /tmp/orasoft/18706472/18522515/custom/server/18522515 -local -silent -ocmrf /tmp/ocm.rsp -oh /u01/app/oracle/product/11.2.0.4/db_1 -invPtrLoc /u01/app/oracle/product/11.2.0.4/db_1/oraInst.loc</p><p>19: /tmp/orasoft/18706472/18522515/custom/server/18522515/custom/scripts/postpatch.sh -dbhome /u01/app/oracle/product/11.2.0.4/db_1</p><p>20: /u01/app/11.2.0.4/grid/crs/install/rootcrs.pl -unlock : run as root</p><p>21: /sbin/fuser -k /u01/app/11.2.0.4/grid/bin/crsctl.bin : run as root</p><p>22: /u01/app/11.2.0.4/grid/OPatch/opatch prereq CheckApplicable -ph /tmp/orasoft/18706472/18522509 -oh /u01/app/11.2.0.4/grid</p><p>23: /u01/app/11.2.0.4/grid/OPatch/opatch prereq CheckApplicable -ph /tmp/orasoft/18706472/18522515 -oh /u01/app/11.2.0.4/grid</p><p>24: /u01/app/11.2.0.4/grid/OPatch/opatch prereq CheckApplicable -ph /tmp/orasoft/18706472/18522514 -oh /u01/app/11.2.0.4/grid</p><p>25: /u01/app/11.2.0.4/grid/OPatch/opatch napply /tmp/orasoft/18706472/18522509 -local -silent -ocmrf /tmp/ocm.rsp -oh /u01/app/11.2.0.4/grid -invPtrLoc /u01/app/11.2.0.4/grid/oraInst.loc</p><p>26: /u01/app/11.2.0.4/grid/OPatch/opatch napply /tmp/orasoft/18706472/18522515 -local -silent -ocmrf /tmp/ocm.rsp -oh /u01/app/11.2.0.4/grid -invPtrLoc /u01/app/11.2.0.4/grid/oraInst.loc</p><p>27: /u01/app/11.2.0.4/grid/OPatch/opatch napply /tmp/orasoft/18706472/18522514 -local -silent -ocmrf /tmp/ocm.rsp -oh /u01/app/11.2.0.4/grid -invPtrLoc /u01/app/11.2.0.4/grid/oraInst.loc</p><p>28: /u01/app/11.2.0.4/grid/bin/emctl start dbconsole</p><p>29: /u01/app/11.2.0.4/grid/rdbms/install/rootadd_rdbms.sh : run as root</p><p>30: /u01/app/11.2.0.4/grid/crs/install/rootcrs.pl -patch : run as root</p><p>31: /u01/app/oracle/product/11.2.0.4/db_1/bin/emctl start dbconsole</p><p>32: /u01/app/oracle/product/11.2.0.4/db_1/bin/emctl start agent</p><p>33: /u01/app/oracle/product/11.2.0.4/db_1/bin/srvctl start home -o /u01/app/oracle/product/11.2.0.4/db_1 -s /u01/app/oracle/product/11.2.0.4/db_1/srvm/admin/stophome.txt -n rac0402</p>

实际的执行语句是

As root user, execute the following command on each node of the cluster:

# opatch auto <UNZIPPED_PATCH_LOCATION>/18706472 -ocmrf <ocm response file>

 

两个节点上先后做完之后，需要在数据库上执行语句

2.5.2 Loading Modified SQL Files into the DatabaseThe following steps load modified SQL files into the database. For an Oracle RAC environment, perform these steps on only one node.For each database instance running on the Oracle home being patched, connect to the database using SQL*Plus. Connect as SYSDBA and run the catbundle.sql script as follows:cd $ORACLE_HOME/rdbms/adminsqlplus /nologSQL> CONNECT / AS SYSDBASQL> STARTUPSQL> @catbundle.sql psu applySQL> QUITThe catbundle.sql execution is reflected in the dba_registry_history view by a row associated with bundle series PSU.

 

SQL> column comments format a30SQL> select comments,version from dba_registry_history where bundle_series='PSU';COMMENTS                       VERSION------------------------------ ----------Patchset 11.2.0.2.0            11.2.0.4Patchset 11.2.0.2.0            11.2.0.4PSU 11.2.0.4.3                 11.2.0.4

 

到现在都打好了。

 

下面是中间碰到的问题

1.出现空间不足问题

$ORACLE_HOME/cfgtoollogs/opatchauto2014-08-06_10-26-44.log里面出现下面的信息

 Total space needed for the patches are: 344850774

 Checking if enough space is present on the disk...
 Prerequisite check "CheckSystemSpace" failed.
 The details are:
 Required amount of space(328.875MB) is not available.

 

最终的测试发现4G的free空间是不够的，我最终大概给了7G才行。

2.出现一堆文件不可写问题

Patch 17478514:Copy Action: Destination File "/u01/app/oracle/product/11.2.0.4/db_1/md/admin/catmd10i.sql" is not writeable.'oracle.rdbms, 11.2.0.4.0': Cannot copy file from 'catmd10i.sql' to '/u01/app/oracle/product/11.2.0.4/db_1/md/admin/catmd10i.sql'Copy Action: Destination File "/u01/app/oracle/product/11.2.0.4/db_1/md/admin/sdodbmig.sql" is not writeable.'oracle.rdbms, 11.2.0.4.0': Cannot copy file from 'sdodbmig.sql' to '/u01/app/oracle/product/11.2.0.4/db_1/md/admin/sdodbmig.sql'Copy Action: Destination File "/u01/app/oracle/product/11.2.0.4/db_1/rdbms/admin/bundledata_PSU.xml" is not writeable.'oracle.rdbms, 11.2.0.4.0': Cannot copy file from 'bundledata_PSU.xml' to '/u01/app/oracle/product/11.2.0.4/db_1/rdbms/admin/bundledata_PSU.xml'onewaycopyAction : Desctination File "/u01/app/oracle/product/11.2.0.4/db_1/psu/11.2.0.4.1/catpsu.sql" is not writeable.'oracle.rdbms, 11.2.0.4.0': Cannot copy file from 'catpsu.sql' to '/u01/app/oracle/product/11.2.0.4/db_1/psu/11.2.0.4.1/catpsu.sql'onewaycopyAction : Desctination File "/u01/app/oracle/product/11.2.0.4/db_1/psu/11.2.0.4.1/catpsu_rollback.sql" is not writeable.'oracle.rdbms, 11.2.0.4.0': Cannot copy file from 'catpsu_rollback.sql' to '/u01/app/oracle/product/11.2.0.4/db_1/psu/11.2.0.4.1/catpsu_rollback.sql'onewaycopyAction : Desctination File "/u01/app/oracle/product/11.2.0.4/db_1/patch/scripts/bug17088068.sql" is not writeable.'oracle.rdbms, 11.2.0.4.0': Cannot copy file from 'bug17088068.sql' to '/u01/app/oracle/product/11.2.0.4/db_1/patch/scripts/bug17088068.sql'Copy Action: Destination File "/u01/app/oracle/product/11.2.0.4/db_1/md/admin/catmd10i.sql" is not writeable.'oracle.sdo, 11.2.0.4.0': Cannot copy file from 'catmd10i.sql' to '/u01/app/oracle/product/11.2.0.4/db_1/md/admin/catmd10i.sql'

看了一下对应的文件或者目录要么oracle没w权限要么，该文件是root的，oracle所在的组没w权限。

 

这应该是安装rac的时候，zip没在oracle或者grid用户解压导致的

 

至于这个PSU补丁，事实证明是不可以在windows下先解压再上传上去，这样权限会出现一堆问题。

最好是把zip上传上去，解压后安装。