oracle database psu 11.2.0.3.0 到11.2.0.3.9
1.下载psu包，当然要有MOS账号才能下载啦。 unzip oracle_database_psu_11.2.0.3.9_Linux-x86-64.zip
2.给数据库软件打PATCH pri:orcl > ls -lrt total 71268 drwxrwxr-x 11 oracle oinstall 4096 Jan 7 18:23 17540582 -rw-rw-r-- 1 oracle oinstall 69702 Jan 13 19:18 PatchSearch.xml -rwxr-xr-x 1 oracle oinstall 72815847 Apr 14 09:34 oracle_database_psu_11.2.0.3.9_Linux-x86-64.zip
#我们看到有很多个patch，我以为进入最后一个patch来应用，前面的就会应用上。 pri:orcl > cd 17540582 pri:orcl > ls 13343438 13696216 13923374 14275605 14727310 16056266 16619892 16902043 17540582 patchmd.xml README.html README.txt
#opatch apply 发现出错，报错135 pri:orcl > opatch apply Invoking OPatch 11.2.0.1.7 Oracle Interim Patch Installer version 11.2.0.1.7 Copyright (c) 2011, Oracle Corporation. All rights reserved. Argument(s) Error... For the composite patch you have specified, the number of entries in the composite.xml does not equal the number of inventory.xml's. This could mean you are trying to apply the active constituent alone. Please supply the top-level directory of the composite patch, not one of its subdirectories, for opatch apply. If you still get this error after applying the top-level directory the composite patch may be improperly packaged. Please check the arguments and try again. OPatch failed with error code 135
#原来是version版本问题。根据自述文档，是要11.2.0.3.0的opatch工具才行。 You must use the OPatch utility version 11.2.0.3.0 or later to apply this patch. Oracle recommends that you use the latest released OPatch version for 11.2, which is available for download from My Oracle Support patch 6880880 by selecting the 11.2.0.0.0 release.
pri:orcl > opatch version Invoking OPatch 11.2.0.1.7 OPatch Version: 11.2.0.1.7 OPatch succeeded.
更新Opatch工具方法，需要从MOS上下载对应patch，然后覆盖到ORACLE_HOME下的Opatch目录即可。覆盖之前最好备份下。覆盖完后： pri:orcl > opatch version OPatch Version: 11.2.0.3.6 OPatch succeeded.
再来一次。 pri:orcl > opatch apply Oracle Interim Patch Installer version 11.2.0.3.6 Copyright (c) 2013, Oracle Corporation. All rights reserved. Argument(s) Error... Illegal file format for composite patch. There is no composite.xml file. Either this composite patch is not packaged properly, or you are applying a constituent individually. Please check the arguments and try again. OPatch failed with error code 135
可能是我的Patch工具没有安装好，重新去看下自述文件。
How to install the utility: --------------------------- To install this patch, Please extract the file "zipped file" using unzip or
winzip, depending upon the platform. You should extract the zip file directly under the ORACLE_HOME. Please follow the following steps for extracting the zip file of OPatch. (1) Please take a backup of $ORACLE_HOME/OPatch into a dedicated backup location. (2) Please remove the contents of $ORACLE_HOME/OPatch directory (Please do not remove $ORACLE_HOME/OPatch directory itself) (3) Please unzip the OPatch downloaded zip into $ORACLE_HOME directory.
我当时是没备份，然后将整个OPatch目录覆盖了。怀疑是不是覆盖掉了更多的东西，比如旧目录下有composite.xml file这个文件。因为没有备份，只有重新安装11.2.0.3.0软件，将OPatch目录提取出来看看了。后来发现，没差别的。尽管我重新按照上面的3个步骤去做了，也一样出现这个错误，让我们再详细看看这个错误。 pri:orcl2 > opatch apply Oracle Interim Patch Installer version 11.2.0.3.6 Copyright (c) 2013, Oracle Corporation. All rights reserved. Argument(s) Error... Illegal file format for composite patch. There is no composite.xml file. Either this composite patch is not packaged properly, or you are applying a constituent individually. Please check the arguments and try again. OP |