ITPub博客

首页 > 数据库 > Oracle > oracle 11g 单实例打补丁操作步骤

oracle 11g 单实例打补丁操作步骤

原创 Oracle 作者:feelpurple 时间:2015-10-28 17:10:14 0 删除 编辑


查看补丁压缩包

[oracle@GTFDBDG ~]$ ll
total 600696
drwxrwxr-x 10 oracle oinstall      4096 Oct 11  2013 16902043
drwxrwxrwx  5 oracle oinstall      4096 Oct 11  2013 17076717
-rw-rw-rw-  1 oracle oinstall         0 Oct 11  2013 atp_lfp
-rw-rw-rw-  1 oracle oinstall       450 Oct 11  2013 bundle.xml
-rw-r--r--  1 oracle oinstall 582007538 Oct 28 15:47 p17272731_112030_Linux-x86-64.zip
-rw-r--r--  1 oracle oinstall  33020933 Oct 28 15:47 p6880880_112000_Linux-x86-64.zip
-rw-rw-r--  1 oracle oinstall     59968 Oct 15  2013 README.html
-rw-rw-rw-  1 oracle oinstall        21 Oct 11  2013 README.txt

将压缩包解压

[oracle@GTFDBDG ~]$ unzip p6880880_112000_Linux-x86-64.zip 
Archive:  p6880880_112000_Linux-x86-64.zip
   creating: OPatch/
   creating: OPatch/jlib/
  inflating: OPatch/jlib/oracle.opatch.classpath.jar  
  inflating: OPatch/jlib/oracle.opatch.classpath.windows.jar  
  inflating: OPatch/jlib/opatch.jar  
   creating: OPatch/jlib/fa/
  inflating: OPatch/jlib/fa/oracle.opatch.fa.classpath.windows.jar  
  inflating: OPatch/jlib/fa/oracle.opatch.fa.classpath.unix.jar  
  inflating: OPatch/jlib/fa/oracle.opatch.fa.classpath.jar  
  inflating: OPatch/jlib/opatchsdk.jar  
  inflating: OPatch/jlib/oracle.opatch.classpath.unix.jar  
.....
[oracle@GTFDBDG ~]$ unzip p17272731_112030_Linux-x86-64.zip
.....

[oracle@GTFDBDG ~]$ ll
total 600700
drwxrwxr-x 10 oracle oinstall      4096 Oct 11  2013 16902043
drwxrwxrwx  5 oracle oinstall      4096 Oct 11  2013 17076717
-rw-rw-rw-  1 oracle oinstall         0 Oct 11  2013 atp_lfp
-rw-rw-rw-  1 oracle oinstall       450 Oct 11  2013 bundle.xml
drwxr-xr-x  8 oracle oinstall      4096 Dec 14  2013 OPatch
-rw-r--r--  1 oracle oinstall 582007538 Oct 28 15:47 p17272731_112030_Linux-x86-64.zip
-rw-r--r--  1 oracle oinstall  33020933 Oct 28 15:47 p6880880_112000_Linux-x86-64.zip
-rw-rw-r--  1 oracle oinstall     59968 Oct 15  2013 README.html
-rw-rw-rw-  1 oracle oinstall        21 Oct 11  2013 README.txt

[root@GTFDBDG /]# su - oracle
[oracle@GTFDBDG ~]$ cd /u01/app/oracle/product/11.2.0/db_1/OPatch

备份原来的 OPatch 目录

[oracle@GTFDBDG OPatch]$ tar -cvf opatch.11.2.0.1.7.tar ./
./
./docs/
./docs/Prereq_Users_Guide.txt
./docs/Users_Guide.txt
./docs/FAQ
./opatch.ini
./opatch
./jlib/
./jlib/fa/
./jlib/fa/oracle.opatch.fa.classpath.unix.jar
./jlib/fa/oracle.opatch.fa.classpath.windows.jar
./jlib/fa/oracle.opatch.fa.classpath.jar
./jlib/oracle.opatch.classpath.jar
./jlib/oracle.opatch.classpath.unix.jar
./jlib/opatch.jar
./jlib/oracle.opatch.classpath.windows.jar
./jlib/opatchsdk.jar

安装前验证补丁冲突

[oracle@GTFDBDG OPatch]$ ./opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/oracle/17076717/ -oh $ORACLE_HOME
Oracle Interim Patch Installer version 11.2.0.3.6
Copyright (c) 2013, Oracle Corporation.  All rights reserved.


PREREQ session


Oracle Home       : /u01/app/oracle/product/11.2.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc
OPatch version    : 11.2.0.3.6
OUI version       : 11.2.0.3.0
Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2015-10-28_15-56-43PM_1.log


Invoking prereq "checkconflictagainstohwithdetail"


Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

[oracle@GTFDBDG OPatch]$ ./opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/oracle/16902043/ -oh $ORACLE_HOME
Oracle Interim Patch Installer version 11.2.0.3.6
Copyright (c) 2013, Oracle Corporation.  All rights reserved.


PREREQ session


Oracle Home       : /u01/app/oracle/product/11.2.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc
OPatch version    : 11.2.0.3.6
OUI version       : 11.2.0.3.0
Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2015-10-28_15-57-10PM_1.log


Invoking prereq "checkconflictagainstohwithdetail"


Prereq "checkConflictAgainstOHWithDetail" passed.


OPatch succeeded.

关闭数据库和监听

[oracle@GTFDBDG OPatch]$ sqlplus / as sysdba


SQL*Plus: Release 11.2.0.3.0 Production on Wed Oct 28 16:06:17 2015


Copyright (c) 1982, 2011, Oracle.  All rights reserved.




Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options


SQL> shutdown immediate

[oracle@GTFDBDG OPatch]$ lsnrctl stop


LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 28-OCT-2015 16:06:45


Copyright (c) 1991, 2011, Oracle.  All rights reserved.


Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=GTFDBDG)(PORT=1521)))

安装补丁

[oracle@GTFDBDG OPatch]$ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch apply -oh /u01/app/oracle/product/11.2.0/db_1 -local /home/oracle/16902043
Oracle Interim Patch Installer version 11.2.0.3.6
Copyright (c) 2013, Oracle Corporation.  All rights reserved.




Oracle Home       : /u01/app/oracle/product/11.2.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc
OPatch version    : 11.2.0.3.6
OUI version       : 11.2.0.3.0
Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2015-10-28_16-06-58PM_1.log


Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   13343438  13696216  13923374  14275605  14727310  16056266  16619892  16902043  


Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
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






Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/11.2.0/db_1')




Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying sub-patch '13343438' to OH '/u01/app/oracle/product/11.2.0/db_1'


Patching component oracle.rdbms.rsf, 11.2.0.3.0...


Patching component oracle.rdbms, 11.2.0.3.0...


Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...


Verifying the update...
Applying sub-patch '13696216' to OH '/u01/app/oracle/product/11.2.0/db_1'


Patching component oracle.rdbms.rsf, 11.2.0.3.0...


Patching component oracle.rdbms, 11.2.0.3.0...


Patching component oracle.sdo.locator, 11.2.0.3.0...


Patching component oracle.sysman.console.db, 11.2.0.3.0...


Patching component oracle.sysman.oms.core, 10.2.0.4.4...


Verifying the update...
Applying sub-patch '13923374' to OH '/u01/app/oracle/product/11.2.0/db_1'
ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.3.0 ]  not present in the Oracle Home or a higher version is found.


Patching component oracle.rdbms.rsf, 11.2.0.3.0...


Patching component oracle.rdbms, 11.2.0.3.0...


Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...


Patching component oracle.network.rsf, 11.2.0.3.0...


Patching component oracle.network.listener, 11.2.0.3.0...


Patching component oracle.sysman.console.db, 11.2.0.3.0...


Verifying the update...
Applying sub-patch '14275605' to OH '/u01/app/oracle/product/11.2.0/db_1'
ApplySession: Optional component(s) [ oracle.precomp.lang, 11.2.0.3.0 ]  not present in the Oracle Home or a higher version is found.


Patching component oracle.network.client, 11.2.0.3.0...


Patching component oracle.network.rsf, 11.2.0.3.0...


Patching component oracle.precomp.common, 11.2.0.3.0...


Patching component oracle.rdbms, 11.2.0.3.0...


Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...


Patching component oracle.rdbms.rman, 11.2.0.3.0...


Patching component oracle.rdbms.rsf, 11.2.0.3.0...


Patching component oracle.rdbms.util, 11.2.0.3.0...


Verifying the update...
Applying sub-patch '14727310' to OH '/u01/app/oracle/product/11.2.0/db_1'


Patching component oracle.rdbms, 11.2.0.3.0...


Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...


Patching component oracle.rdbms.rsf, 11.2.0.3.0...


Patching component oracle.sdo.locator, 11.2.0.3.0...


Patching component oracle.sysman.console.db, 11.2.0.3.0...


Patching component oracle.sysman.oms.core, 10.2.0.4.4...


Verifying the update...
Applying sub-patch '16056266' to OH '/u01/app/oracle/product/11.2.0/db_1'
ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.3.0 ]  not present in the Oracle Home or a higher version is found.


Patching component oracle.network.listener, 11.2.0.3.0...


Patching component oracle.network.rsf, 11.2.0.3.0...


Patching component oracle.ovm, 11.2.0.3.0...


Patching component oracle.rdbms, 11.2.0.3.0...


Patching component oracle.rdbms.rman, 11.2.0.3.0...


Patching component oracle.rdbms.rsf, 11.2.0.3.0...


Patching component oracle.sdo.locator, 11.2.0.3.0...


Patching component oracle.rdbms.deconfig, 11.2.0.3.0...


Verifying the update...
Applying sub-patch '16619892' to OH '/u01/app/oracle/product/11.2.0/db_1'
ApplySession: Optional component(s) [ oracle.precomp.lang, 11.2.0.3.0 ]  not present in the Oracle Home or a higher version is found.


Patching component oracle.marvel, 11.2.0.3.0...


Patching component oracle.precomp.common, 11.2.0.3.0...


Patching component oracle.rdbms, 11.2.0.3.0...


Patching component oracle.rdbms.rman, 11.2.0.3.0...


Patching component oracle.rdbms.rsf, 11.2.0.3.0...


Patching component oracle.sysman.agent, 10.2.0.4.3...


Patching component oracle.sysman.console.db, 11.2.0.3.0...


Patching component oracle.sysman.repository.core, 10.2.0.4.4...


Patching component oracle.xdk, 11.2.0.3.0...


Patching component oracle.xdk.parser.java, 11.2.0.3.0...


Patching component oracle.xdk.rsf, 11.2.0.3.0...


Verifying the update...
Applying sub-patch '16902043' to OH '/u01/app/oracle/product/11.2.0/db_1'
ApplySession: Optional component(s) [ oracle.idm.oid, 11.2.0.3.0 ]  not present in the Oracle Home or a higher version is found.


Patching component oracle.ldap.rsf, 11.2.0.3.0...


Patching component oracle.ldap.rsf.ic, 11.2.0.3.0...


Patching component oracle.owb.rsf, 11.2.0.3.0...


Patching component oracle.rdbms, 11.2.0.3.0...


Patching component oracle.rdbms.rsf, 11.2.0.3.0...


Patching component oracle.sysman.console.db, 11.2.0.3.0...


Verifying the update...


OPatch found the word "warning" in the stderr of the make command.
Please look at this stderr. You can re-run this make command.
Stderr output:
ins_precomp.mk:19: warning: overriding commands for target `pcscfg.cfg'
/u01/app/oracle/product/11.2.0/db_1/precomp/lib/env_precomp.mk:2160: warning: ignoring old commands for target `pcscfg.cfg'
/u01/app/oracle/product/11.2.0/db_1/precomp/lib/ins_precomp.mk:19: warning: overriding commands for target `pcscfg.cfg'
/u01/app/oracle/product/11.2.0/db_1/precomp/lib/env_precomp.mk:2160: warning: ignoring old commands for target `pcscfg.cfg'






OPatch found the word "warning" in the stderr of the make command.
Please look at this stderr. You can re-run this make command.
Stderr output:
ins_emagent.mk:113: warning: overriding commands for target `nmosudo'
ins_emagent.mk:52: warning: ignoring old commands for target `nmosudo'
/u01/app/oracle/product/11.2.0/db_1/sysman/lib/ins_emagent.mk:113: warning: overriding commands for target `nmosudo'
/u01/app/oracle/product/11.2.0/db_1/sysman/lib/ins_emagent.mk:52: warning: ignoring old commands for target `nmosudo'




Composite patch 16902043 successfully applied.




来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/26506993/viewspace-1817558/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2014-08-01

  • 博文量
    404
  • 访问量
    1673924