oracle11gOpatch补丁升级

查看数据库版本及补丁信息
SQL> select version,id,bundle_series,comments from dba_registry_history;


VERSION        ID   BUNDLE_SERIES  COMMENTS
---------- ----------    -------------- --------------------
11.2.0.4             0    PSU             Patchset 11.2.0.2.0
11.2.0.4             0    PSU             Patchset 11.2.0.2.0

补丁包
[oracle@enmo ~]$ ll
total 122728
-rwxrwxr-x. 1 oracle oinstall 72935202 Mar  9 19:35 p21352635_112040_Linux-x86-64.zip
-rwxrwxr-x. 1 oracle oinstall 52733900 Mar  9 19:35 p6880880_112000_Linux-x86-64.zip

[oracle@enmo ~]$ unzip p21352635_112040_Linux-x86-64.zip
[oracle@enmo ~]$ unzip p6880880_112000_Linux-x86-64.zip

[oracle@enmo ~]$ ls
21352635  OPatch  p21352635_112040_Linux-x86-64.zip  p6880880_112000_Linux-x86-64.zip  PatchSearch.xml
[oracle@enmo ~]$ cd $ORACLE_HOME/
[oracle@enmo dbhome_1]$ mv OPatch/ OPatch.bak/
[oracle@enmo dbhome_1]$ cd -
/home/oracle
[oracle@enmo ~]$ mv OPatch/ $ORACLE_HOME/
[oracle@enmo ~]$ cd 21352635/


关闭数据库
[oracle@enmo 21352635]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Wed Mar 9 19:47:46 2016

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit

升级oracle软件
[oracle@enmo 21352635]$ /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/opatch  apply
Oracle Interim Patch Installer version 11.2.0.3.12
Copyright (c) 2016, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version    : 11.2.0.3.12
OUI version       : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2016-03-09_19-50-03PM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   17478514  18031668  18522509  19121551  19769489  20299013  20760982  21352635  

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/dbhome_1')


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

Patching component oracle.rdbms, 11.2.0.4.0...

Patching component oracle.rdbms.rsf, 11.2.0.4.0...

Patching component oracle.sdo, 11.2.0.4.0...

Patching component oracle.sysman.agent, 10.2.0.4.5...

Patching component oracle.rdbms, 11.2.0.4.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...

Patching component oracle.ordim.client, 11.2.0.4.0...

Patching component oracle.ordim.jai, 11.2.0.4.0...
Applying sub-patch '19769489' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
ApplySession: Optional component(s) [ oracle.sysman.agent, 11.2.0.4.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.precomp.common, 11.2.0.4.0...

Patching component oracle.rdbms.deconfig, 11.2.0.4.0...
Applying sub-patch '20299013' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'

Patching component oracle.rdbms.dv, 11.2.0.4.0...

Patching component oracle.rdbms.deconfig, 11.2.0.4.0...
Applying sub-patch '20760982' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'

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

Patching component oracle.rdbms, 11.2.0.4.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
Applying sub-patch '21352635' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'

Patching component oracle.sysman.agent, 10.2.0.4.5...

Patching component oracle.rdbms.rsf, 11.2.0.4.0...

Patching component oracle.rdbms.rman, 11.2.0.4.0...

Patching component oracle.rdbms, 11.2.0.4.0...
Composite patch 21352635 successfully applied.
Log file location: /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2016-03-09_19-50-03PM_1.log

[oracle@enmo 21352635]$ ls
17478514  18031668  18522509  19121551  19769489  20299013  20760982  21352635  patchmd.xml  README.html  README.txt
[oracle@enmo 21352635]$ firefox README.html


[oracle@enmo 21352635]$ cd /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/admin/

升级数据库
[oracle@enmo admin]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Wed Mar 9 20:27:56 2016

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area  835104768 bytes
Fixed Size            2257840 bytes
Variable Size          541068368 bytes
Database Buffers      289406976 bytes
Redo Buffers            2371584 bytes
Database mounted.
Database opened.

SQL> @catbundle.sql psu apply
SQL> @utlrp.sql
SQL> select version,id,bundle_series,comments from dba_registry_history;

VERSION        ID    BUNDLE_SERIES  COMMENTS
---------- ----------      -------------- --------------------
11.2.0.4             0      PSU            Patchset 11.2.0.2.0
11.2.0.4             0      PSU            Patchset 11.2.0.2.0
11.2.0.4             8      PSU            PSU 11.2.0.4.8

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

检查opatch版本
[oracle@enmo admin]$  $ORACLE_HOME/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.12
Copyright (c) 2016, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version    : 11.2.0.3.12
OUI version       : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2016-03-09_20-57-52PM_1.log

Lsinventory Output file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2016-03-09_20-57-52PM.txt

--------------------------------------------------------------------------------
Local Machine Information::
Hostname: enmo
ARU platform id: 226
ARU platform description:: Linux x86-64

Installed Top-level Products (1):

Oracle Database 11g                                                  11.2.0.4.0
There are 1 products installed in this Oracle Home.


Interim patches (1) :

Patch  21352635     : applied on Wed Mar 09 19:56:40 CST 2016
Unique Patch ID:  19227862
Patch description:  "Database Patch Set Update : 11.2.0.4.8 (21352635)"
   Created on 1 Sep 2015, 07:49:44 hrs
Sub-patch  20760982; "Database Patch Set Update : 11.2.0.4.7 (20760982)"
Sub-patch  20299013; "Database Patch Set Update : 11.2.0.4.6 (20299013)"
Sub-patch  19769489; "Database Patch Set Update : 11.2.0.4.5 (19769489)"
Sub-patch  19121551; "Database Patch Set Update : 11.2.0.4.4 (19121551)"
Sub-patch  18522509; "Database Patch Set Update : 11.2.0.4.3 (18522509)"
Sub-patch  18031668; "Database Patch Set Update : 11.2.0.4.2 (18031668)"
Sub-patch  17478514; "Database Patch Set Update : 11.2.0.4.1 (17478514)"


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

OPatch succeeded.
[oracle@enmo admin]$ $ORACLE_HOME/OPatch/opatch version
OPatch Version: 11.2.0.3.12

OPatch succeeded.





- - END - -

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

转载于:http://blog.itpub.net/30606744/viewspace-2052200/