探索Oracle之数据库升级四
11.2.0.4.0 PSU 11.2.0.4.3
一、 检查当前数据库PSU号:
[oracle@db01 ~]$ cd/DBSoft/Product/11.2.4/db_1/OPatch/ [oracle@db01 OPatch]$ ls crs docs emdpatch.pl jlib ocm opatch opatch.bat opatchdiag opatchdiag.bat opatch.ini opatch.pl opatchprereqs oplan [oracle@db01 OPatch]$./opatch version OPatch Version: 11.2.0.3.4 OPatch succeeded. [oracle@db01 OPatch]$ [oracle@db01 OPatch]$./opatch lsinventory Oracle Interim PatchInstaller version 11.2.0.3.4 Copyright (c) 2012, OracleCorporation. All rights reserved. Oracle Home : /DBSoft/Product/11.2.4/db_1 Central Inventory :/DBSoft/oraInventory from :/DBSoft/Product/11.2.4/db_1/oraInst.loc OPatch version : 11.2.0.3.4 OUI version : 11.2.0.4.0 Log file location :/DBSoft/Product/11.2.4/db_1/cfgtoollogs/opatch/opatch2014-10-04_05-20-14AM_1.log Lsinventory Output filelocation :/DBSoft/Product/11.2.4/db_1/cfgtoollogs/opatch/lsinv/lsinventory2014-10-04_05-20-14AM.txt -------------------------------------------------------------------------------- Installed Top-level Products(1): Oracle Database 11g 11.2.0.4.0 There are 1 productsinstalled in this Oracle Home. There are no Interim patchesinstalled in this Oracle Home. -------------------------------------------------------------------------------- OPatch succeeded. [oracle@db01 OPatch]$
二、 关闭数据库:
SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> host lsnrctl stop LSNRCTL for Linux: Version11.2.0.4.0 - Production on 04-OCT-2014 05:47:04 Copyright (c) 1991, 2013,Oracle. All rights reserved. Connecting to(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) The command completedsuccessfully SQL>
三、 上传新下载的PSU11.2.0.4.3补丁包并解压
##PSU11.2.0.4.3 补丁下载参考:18522509.8 [oracle@db01 ~]$ ll p18522509_112040_Linux-x86-64.zip -rw-r--r-- 1 oracle oinstall25449098 Oct 4 05:22p18522509_112040_Linux-x86-64.zip [oracle@db01 ~]$ unzipp18522509_112040_Linux-x86-64.zip ##解压完之后将会多出18522509目录 [oracle@db01 ~]$ ll total 107544 drwxrwxr-x 5 oracle oinstall 4096 Jun 30 23:15 18522509 drwxr-xr-x 2 oracleoinstall 4096 Oct 3 23:44 Desktop -rw-r--r-- 1 oracle oinstall25449098 Oct 4 05:22p18522509_112040_Linux-x86-64.zip
四、进入18522509目录进行PSU升级
[oracle@db01 ~]$ ls 18522509 Desktop p18522509_112040_Linux-x86-64.zip PatchSearch.xml upgrade.log [oracle@db01 ~]$ cd18522509/ [oracle@db01 18522509]$ ls 17478514 18031668 18522509 patchmd.xml README.html README.txt [oracle@db01 18522509]$/DBSoft/Product/11.2.4/db_1/OPatch/opatch apply Oracle Interim PatchInstaller version 11.2.0.3.4 Copyright (c) 2012, OracleCorporation. All rights reserved. Oracle Home : /DBSoft/Product/11.2.4/db_1 Central Inventory :/DBSoft/oraInventory from :/DBSoft/Product/11.2.4/db_1/oraInst.loc OPatch version : 11.2.0.3.4 OUI version : 11.2.0.4.0 Log file location :/DBSoft/Product/11.2.4/db_1/cfgtoollogs/opatch/opatch2014-10-04_05-25-14AM_1.log Verifying environment andperforming prerequisite checks... Prerequisite check"CheckMinimumOPatchVersion" failed. The details are: The OPatch being used hasversion 11.2.0.3.4 while the following patch(es) require higher versions: Patch 17478514 requiresOPa