oracle 11g 文件系统单机PSU补丁升级安装(二)

oracle 11g 文件系统单机PSU补丁升级安装(二)概述 PSU 补丁系列 二 1 OPatch 版本升级 oracle 11g cd ORACLE HOME oracle 11g 11 2 0 cd OPatch oracle 11g OPatch opatch version OPatch Version 11 2 0 3 4

大家好,我是讯享网,很高兴认识大家。

概述:PSU补丁系列(二)

1、OPatch版本升级

[oracle@11g ~]$ cd $ORACLE_HOME
[oracle@11g 11.2.0]$ cd OPatch/
[oracle@11g OPatch]$ ./opatch version
OPatch Version: 11.2.0.3.4

OPatch succeeded.
[oracle@11g OPatch]$ cd ..
[oracle@11g 11.2.0]$ mv OPatch/ OPatchold
[oracle@11g 11.2.0]$ OPatch/opatch version
OPatch Version: 11.2.0.3.16

OPatch succeeded.

2、补丁升级前环境监测

[oracle@11g ]$ /u01/ora/app/product/11.2.0/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 11.2.0.3.16
Copyright (c) 2018, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/ora/app/product/11.2.0
Central Inventory : /u01/ora/oraInventory
   from           : /u01/ora/app/product/11.2.0/oraInst.loc
OPatch version    : 11.2.0.3.16
OUI version       : 11.2.0.4.0
Log file location : /u01/ora/app/product/11.2.0/cfgtoollogs/opatch/opatch2018-09-12_09-55-57AM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

3、关闭数据库及监听

[oracle@11g 11.2.0]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Wed Sep 12 09:58:01 2018

Copyright (c) 1982, 2013, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
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
[oracle@11g 11.2.0]$ lsnrctl stop

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 12-SEP-2018 09:58:18

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

4、psu补丁应用

[oracle@11g ]$ /u01/ora/app/product/11.2.0/OPatch/opatch apply
Oracle Interim Patch Installer version 11.2.0.3.16
Copyright (c) 2018, Oracle Corporation.  All rights reserved.
Oracle Home       : /u01/ora/app/product/11.2.0
Central Inventory : /u01/ora/oraInventory
   from           : /u01/ora/app/product/11.2.0/oraInst.loc
OPatch version    : 11.2.0.3.16
OUI version       : 11.2.0.4.0
Log file location : /u01/ora/app/product/11.2.0/cfgtoollogs/opatch/opatch2018-09-12_09-58-23AM_1.log

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: 


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

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.xdk, 11.2.0.4.0...

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

Patching component oracle.sdo.locator, 11.2.0.4.0...

Patching component oracle.nlsrtl.rsf, 11.2.0.4.0...

Patching component oracle.xdk.rsf, 11.2.0.4.0...

Patching component oracle.rdbms, 11.2.0.4.0...

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

Patching component oracle.ldap.rsf, 11.2.0.4.0...

Patching component oracle.rdbms.crs, 11.2.0.4.0...

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

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

Patching component oracle.rdbms.deconfig, 11.2.0.4.0...

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

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

Patching component oracle.rdbms, 11.2.0.4.0...

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

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

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

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

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

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...

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 '' to OH '/u01/ora/app/product/11.2.0'
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.ovm, 11.2.0.4.0...

Patching component oracle.xdk, 11.2.0.4.0...

Patching component oracle.rdbms.util, 11.2.0.4.0...

Patching component oracle.rdbms, 11.2.0.4.0...

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

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

Patching component oracle.oraolap, 11.2.0.4.0...

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

Patching component oracle.xdk.rsf, 11.2.0.4.0...

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

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

Patching component oracle.rdbms.oci, 11.2.0.4.0...

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

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

Patching component oracle.xdk, 11.2.0.4.0...

Patching component oracle.sysman.common, 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.xdk.parser.java, 11.2.0.4.0...

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

Patching component oracle.xdk.rsf, 11.2.0.4.0...

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

Patching component oracle.sysman.common.core, 10.2.0.4.5...

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

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...

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...
Applying sub-patch '' to OH '/u01/ora/app/product/11.2.0'
ApplySession: Optional component(s) [ oracle.tfa, 11.2.0.4.0 ]  not present in the Oracle Home or a higher version is found.


讯享网

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

Patching component oracle.ovm, 11.2.0.4.0...

Patching component oracle.xdk, 11.2.0.4.0...

Patching component oracle.rdbms, 11.2.0.4.0...

Patching component oracle.nlsrtl.rsf, 11.2.0.4.0...

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

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

Patching component oracle.xdk.rsf, 11.2.0.4.0...

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

Patching component oracle.sysman.oms.core, 10.2.0.4.5...
Applying sub-patch '' to OH '/u01/ora/app/product/11.2.0'
ApplySession: Optional component(s) [ oracle.tfa, 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.oraolap.dbscripts, 11.2.0.4.0...

Patching component oracle.rdbms.olap, 11.2.0.4.0...

Patching component oracle.oraolap, 11.2.0.4.0...

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...

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

Patching component oracle.rdbms, 11.2.0.4.0...

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

Patching component oracle.sqlplus.ic, 11.2.0.4.0...

Patching component oracle.sqlplus, 11.2.0.4.0...

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

Patching component oracle.rdbms, 11.2.0.4.0...

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

Patching component oracle.sysman.plugin.db.main.agent, 11.2.0.4.0...

Patching component oracle.sqlplus.ic, 11.2.0.4.0...

Patching component oracle.sqlplus, 11.2.0.4.0...

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

Patching component oracle.rdbms, 11.2.0.4.0...

Patching component oracle.rdbms.util, 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...

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

Patching component oracle.ldap.rsf, 11.2.0.4.0...

Patching component oracle.oracore.rsf, 11.2.0.4.0...

Patching component oracle.rdbms, 11.2.0.4.0...

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

Patching component oracle.oracore.rsf, 11.2.0.4.0...

Patching component oracle.rdbms, 11.2.0.4.0...
Applying sub-patch '' to OH '/u01/ora/app/product/11.2.0'
ApplySession: Optional component(s) [ oracle.oid.client, 11.2.0.4.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.network.rsf, 11.2.0.4.0...

Patching component oracle.ldap.client, 11.2.0.4.0...

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

Patching component oracle.xdk, 11.2.0.4.0...

Patching component oracle.rdbms, 11.2.0.4.0...

Patching component oracle.network.listener, 11.2.0.4.0...

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

Patching component oracle.nlsrtl.rsf, 11.2.0.4.0...

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

Patching component oracle.xdk.rsf, 11.2.0.4.0...

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

Patching component oracle.rdbms, 11.2.0.4.0...

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

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

Patching component oracle.assistants.server, 11.2.0.4.0...

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

Patching component oracle.rdbms, 11.2.0.4.0...

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

Patching component oracle.ctx, 11.2.0.4.0...

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

Patching component oracle.ctx.rsf, 11.2.0.4.0...

Patching component oracle.rdbms, 11.2.0.4.0...

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

OPatch found the word "error" in the stderr of the make command.
Please look at this stderr. You can re-run this make command.
Stderr output:
chmod: changing permissions of `/u01/ora/app/product/11.2.0/bin/extjobO': Operation not permitted
make: [iextjob] Error 1 (ignored)


Composite patch successfully applied.
OPatch Session completed with warnings.
Log file location: /u01/ora/app/product/11.2.0/cfgtoollogs/opatch/opatch2018-09-12_09-58-23AM_1.log

OPatch completed with warnings.

5、补丁应用情况:

[oracle@11g OPatch]$ ./opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.16
Copyright (c) 2018, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/ora/app/product/11.2.0
Central Inventory : /u01/ora/oraInventory
   from           : /u01/ora/app/product/11.2.0/oraInst.loc
OPatch version    : 11.2.0.3.16
OUI version       : 11.2.0.4.0
Log file location : /u01/ora/app/product/11.2.0/cfgtoollogs/opatch/opatch2018-09-12_10-17-48AM_1.log

Lsinventory Output file location : /u01/ora/app/product/11.2.0/cfgtoollogs/opatch/lsinv/lsinventory2018-09-12_10-17-48AM.txt

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

Installed Top-level Products (1): 

Patch       : applied on Wed Sep 12 10:02:22 CST 2018
Unique Patch ID:  
Patch description:  "Database Patch Set Update : 11.2.0.4. ()"
   Created on 31 May 2018, 01:37:49 hrs PST8PDT
Sub-patch  ; "Database Patch Set Update : 11.2.0.4. ()"
Sub-patch  ; "Database Patch Set Update : 11.2.0.4. ()"
Sub-patch  ; "Database Patch Set Update : 11.2.0.4. ()"
Sub-patch  ; "Database Patch Set Update : 11.2.0.4. ()"
Sub-patch  ; "Database Patch Set Update : 11.2.0.4. ()"
Sub-patch  ; "Database Patch Set Update : 11.2.0.4. ()"
Sub-patch  ; "Database Patch Set Update : 11.2.0.4. ()"
Sub-patch  ; "Database Patch Set Update : 11.2.0.4. ()"
Sub-patch  ; "Database Patch Set Update : 11.2.0.4. ()"
Sub-patch  ; "Database Patch Set Update : 11.2.0.4. ()"
Sub-patch  ; "Database Patch Set Update : 11.2.0.4.8 ()"
Sub-patch  ; "Database Patch Set Update : 11.2.0.4.7 ()"
Sub-patch  ; "Database Patch Set Update : 11.2.0.4.6 ()"
Sub-patch  ; "Database Patch Set Update : 11.2.0.4.5 ()"
Sub-patch  ; "Database Patch Set Update : 11.2.0.4.4 ()"
Sub-patch  ; "Database Patch Set Update : 11.2.0.4.3 ()"
Sub-patch  ; "Database Patch Set Update : 11.2.0.4.2 ()"
Sub-patch  ; "Database Patch Set Update : 11.2.0.4.1 ()"
   Bugs fixed:
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , , , , ,
     , , ,

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

OPatch succeeded.

6、数据库补丁应用:

ACTION_TIME                    ACTION     NAMESPACE  VERSION            ID BUNDLE_SERIES                  COMMENTS
------------------------------ ---------- ---------- ---------- ---------- ------------------------------ ------------------------------
24-AUG-13 12.03.45. PM   APPLY      SERVER     11.2.0.4            0 PSU                            Patchset 11.2.0.2.0
12-SEP-18 09.44.40. AM   APPLY      SERVER     11.2.0.4            0 PSU                            Patchset 11.2.0.2.0


SQL> @/u01/ora/app/product/11.2.0/rdbms/admin/catbundle.sql psu apply

select * from DBA_REGISTRY_HISTORY;

ACTION_TIME                    ACTION     NAMESPACE  VERSION            ID BUNDLE_SERIES                  COMMENTS
------------------------------ ---------- ---------- ---------- ---------- ------------------------------ ------------------------------
24-AUG-13 12.03.45. PM   APPLY      SERVER     11.2.0.4            0 PSU                            Patchset 11.2.0.2.0
12-SEP-18 09.44.40. AM   APPLY      SERVER     11.2.0.4            0 PSU                            Patchset 11.2.0.2.0
12-SEP-18 10.12.57. AM   APPLY      SERVER     11.2.0.4       PSU                            PSU 11.2.0.4.

SQL> @/u01/ora/app/product/11.2.0/rdbms/admin/utlrp.sql

完成

 

 

小讯
上一篇 2025-04-06 23:12
下一篇 2025-01-27 14:35

相关推荐

版权声明:本文内容由互联网用户自发贡献,该文观点仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容,请联系我们,一经查实,本站将立刻删除。
如需转载请保留出处:https://51itzy.com/kjqy/80776.html