環境

OS：CentOS 7.3 x64

Database:11.2.0.4 x64

1、首先檢視作業系統和資料庫的當前版本資訊

OS：

[root@seiang ~]# cat /etc/redhat-release

CentOS Linux release 7.3.1611 (Core)

[root@seiang ~]#

[root@seiang ~]# uname -r

3.10.0-514.el7.x86_64

Database：

SYS@seiang11g>select * from v$version;

BANNER

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

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

PL/SQL Release 11.2.0.4.0 - Production

CORE 11.2.0.4.0 Production

TNS for Linux: Version 11.2.0.4.0 - Production

NLSRTL Version 11.2.0.4.0 – Production

2、檢視各主件相關資訊

SYS@seiang11g>select COMP_ID,COMP_NAME,VERSION,STATUS from dba_registry;

COMP_ID COMP_NAME VERSION STATUS

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

EM Oracle Enterprise Manager 11.2.0.4.0 VALID

OWB OWB 11.2.0.4.0 VALID

APEX Oracle Application Express 3.2.1.00.12 VALID

AMD OLAP Catalog 11.2.0.4.0 VALID

SDO Spatial 11.2.0.4.0 VALID

ORDIM Oracle Multimedia 11.2.0.4.0 VALID

XDB Oracle XML Database 11.2.0.4.0 VALID

CONTEXT Oracle Text 11.2.0.4.0 VALID

EXF Oracle Expression Filter 11.2.0.4.0 VALID

RUL Oracle Rules Manager 11.2.0.4.0 VALID

OWM Oracle Workspace Manager 11.2.0.4.0 VALID

CATALOG Oracle Database Catalog Views 11.2.0.4.0 VALID

CATPROC Oracle Database Packages and Types 11.2.0.4.0 VALID

JAVAVM JServer JAVA Virtual Machine 11.2.0.4.0 VALID

XML Oracle XDK 11.2.0.4.0 VALID

CATJAVA Oracle Database Java Packages 11.2.0.4.0 VALID

APS OLAP Analytic Workspace 11.2.0.4.0 VALID

XOQ Oracle OLAP API 11.2.0.4.0 VALID

18 rows selected.

3、檢視補丁的情況

SYS@seiang11g>select ACTION_TIME, ACTION,version, COMMENTS from sys.DBA_REGISTRY_HISTORY;

ACTION_TIME ACTION VERSION COMMENTS

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

24-AUG-13 12.03.45.119862 PM APPLY 11.2.0.4 Patchset 11.2.0.2.0

13-JUL-17 01.06.33.092315 PM APPLY 11.2.0.4 Patchset 11.2.0.2.0

4、檢視是否存在無效物件

SYS@seiang11g>select count(*) from dba_objects where status<>'VALID';

COUNT(*)

----------

0

下面就開始正式進入打補丁的環節：

5、下載PSU包和OPatch包，並上傳到伺服器上

[oracle@seiang patch]$ ll

total 251632

-rw-r--r-- 1 oracle oinstall 159231647 Jan 19 17:25 p26031209_112040_Linux-x86-64.zip

-rw-r--r-- 1 oracle oinstall 98352086 Jan 19 17:06 p6880880_112000_Linux-x86-64(OPatch11.2.0.3.15).zip

6、檢視當前資料庫的OPatch版本

[oracle@seiang ~]$ cd $ORACLE_HOME/OPatch/

[oracle@seiang OPatch]$ ./opatch version

OPatch Version: 11.2.0.3.4

OPatch succeeded.

7、解壓壓縮包，並把解壓的OPatch替換原ORACLE_HOME裡的OPatch目錄

[oracle@seiang patch]$ unzip p6880880_112000_Linux-x86-64$OPatch11.2.0.3.15$.zip

備註：下面是解壓後README.txt檔案的內容，有更新Opatch的步驟，更新OPatch版本，需要更新11.2.0.3.15，OPatch直接壓縮替換就可以了

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 make sure no directory ORACLE_HOME/OPatch exist.

(3) Please unzip the OPatch downloaded zip into ORACLE_HOME directory.

To check the version of the opatch utility installed in the above step,

go to the OPatch directory and run "opatch version".

8、用解壓下來的OPatch替換原ORACLE_HOME裡的OPatch目錄

[oracle@seiang dbhome_1]$ mv $ORACLE_HOME/OPatch $ORACLE_HOME/OPatch.old

[oracle@seiang dbhome_1]$ mv /u01/software/patch/OPatch $ORACLE_HOME

[oracle@seiang dbhome_1]$ ls -ld OP*

drwxr-x--- 15 oracle oinstall 4096 Aug 24 2016 OPatch

drwxr-xr-x 8 oracle oinstall 212 Jul 13 2017 OPatch.old

9、檢視更新後的OPatch版本

[oracle@seiang dbhome_1]$ cd OPatch

[oracle@seiang OPatch]$ ./opatch version

OPatch Version: 11.2.0.3.15

OPatch succeeded.

10、解壓PSU補丁包

[oracle@seiang patch]$ unzip p26031209_112040_Linux-x86-64.zip

[oracle@seiang patch]$ ll

total 1034016

drwxr-xr-x 4 oracle oinstall 75 Jul 18 2017 26031209

-rw-r--r-- 1 oracle oinstall 159231647 Jan 19 17:25 p26031209_112040_Linux-x86-64.zip

-rw-r--r-- 1 oracle oinstall 98352086 Jan 19 17:06 p6880880_112000_Linux-x86-64(OPatch11.2.0.3.15).zip

-rw-rw-r-- 1 oracle oinstall 85048 Jul 24 10:33 PatchSearch.xml

11、相容性測試，升級前檢查是否有衝突

[oracle@seiang OPatch]$ ./opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/software/patch/26031209 -oh $ORACLE_HOME

Oracle Interim Patch Installer version 11.2.0.3.15

PREREQ session

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

OUI version : 11.2.0.4.0

Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2018-01-22_10-21-53AM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

12、打PSU前，為了安全起見，最好對資料庫做一次全備份（冷備）

[oracle@seiang dbhome_1]$ rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Mon Jan 22 10:24:57 2018

connected to target database: ORADB11G (DBID=3377212249)

RMAN> run {

2> shutdown immediate;

3> startup mount;

4> allocate channel c1 type disk;

5> allocate channel c2 type disk;

6> backup full tag='db_full_bak' database format '/u01/app/oracle/Cold_backup/full_cold_%d_%s.bak';

7> alter database open;

8> }

using target database control file instead of recovery catalog

database closed

database dismounted

Oracle instance shut down

connected to target database (not started)

Oracle instance started

database mounted

Total System Global Area 1252663296 bytes

Fixed Size 2252824 bytes

Variable Size 738201576 bytes

Database Buffers 503316480 bytes

Redo Buffers 8892416 bytes

allocated channel: c1

channel c1: SID=133 device type=DISK

allocated channel: c2

channel c2: SID=10 device type=DISK

Starting backup at 22-JAN-18

channel c1: starting full datafile backup set

channel c1: specifying datafile(s) in backup set

input datafile file number=00006 name=/u01/app/oracle/oradata/OraDB11g/seiang01.dbf

input datafile file number=00001 name=/u01/app/oracle/oradata/OraDB11g/system01.dbf

input datafile file number=00008 name=/u01/app/oracle/oradata/OraDB11g/test_index01.dbf

input datafile file number=00003 name=/u01/app/oracle/oradata/OraDB11g/undotbs01.dbf

channel c1: starting piece 1 at 22-JAN-18

channel c2: starting full datafile backup set

channel c2: specifying datafile(s) in backup set

input datafile file number=00002 name=/u01/app/oracle/oradata/OraDB11g/sysaux01.dbf

input datafile file number=00007 name=/u01/app/oracle/oradata/OraDB11g/test_data01.dbf

input datafile file number=00005 name=/u01/app/oracle/oradata/OraDB11g/example01.dbf

input datafile file number=00004 name=/u01/app/oracle/oradata/OraDB11g/users01.dbf

channel c2: starting piece 1 at 22-JAN-18

channel c1: finished piece 1 at 22-JAN-18

piece handle=/u01/app/oracle/Cold_backup/full_cold_ORADB11G_12.bak tag=DB_FULL_BAK comment=NONE

channel c1: backup set complete, elapsed time: 00:01:27

channel c1: starting full datafile backup set

channel c1: specifying datafile(s) in backup set

channel c2: finished piece 1 at 22-JAN-18

piece handle=/u01/app/oracle/Cold_backup/full_cold_ORADB11G_13.bak tag=DB_FULL_BAK comment=NONE

channel c2: backup set complete, elapsed time: 00:01:26

channel c2: starting full datafile backup set

channel c2: specifying datafile(s) in backup set

including current SPFILE in backup set

channel c2: starting piece 1 at 22-JAN-18

channel c2: finished piece 1 at 22-JAN-18

piece handle=/u01/app/oracle/Cold_backup/full_cold_ORADB11G_15.bak tag=DB_FULL_BAK comment=NONE

channel c2: backup set complete, elapsed time: 00:00:01

including current control file in backup set

channel c1: starting piece 1 at 22-JAN-18

channel c1: finished piece 1 at 22-JAN-18

piece handle=/u01/app/oracle/Cold_backup/full_cold_ORADB11G_14.bak tag=DB_FULL_BAK comment=NONE

channel c1: backup set complete, elapsed time: 00:00:01

Finished backup at 22-JAN-18

database opened

released channel: c1

released channel: c2

RMAN>

13、冷備完成後，關閉資料庫，監聽，EM及相關服務等

SYS@seiang11g>shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

[oracle@seiang Cold_backup]$ lsnrctl stop

14、給database打補丁

安裝Patch包，單例項的資料庫按如下方法打patch就可以了，如果是RAC則需要詳細檢視README.html

[oracle@seiang OPatch]$ ./opatch napply -oh $ORACLE_HOME -local /u01/software/patch/26031209

Oracle Interim Patch Installer version 11.2.0.3.15

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

OUI version : 11.2.0.4.0

Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2018-01-22_10-48-30AM_1.log

Verifying environment and performing prerequisite checks...

Prerequisite check "CheckActiveFilesAndExecutables" failed.

The details are:

Following executables are active :

/u01/app/oracle/product/11.2.0/dbhome_1/bin/rman

/u01/app/oracle/product/11.2.0/dbhome_1/lib/libclntsh.so.11.1

UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.

Log file location: /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2018-01-22_10-48-30AM_1.log

OPatch failed with error code 73

在打patch中出現如上的報錯資訊：

可能是有些執行程式應用到了它，解決方法是可以檢查是哪些執行程式應用到了它，然後手動的把它關閉即可，也可以使用fuser查詢出來之後kill掉

[oracle@seiang OPatch]$ fuser /u01/app/oracle/product/11.2.0/dbhome_1/lib/libclntsh.so.11.1

15、重新打補丁

[oracle@seiang OPatch]$ ./opatch napply -oh $ORACLE_HOME -local /u01/software/patch/26031209

Oracle Interim Patch Installer version 11.2.0.3.15

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

OUI version : 11.2.0.4.0

Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2018-01-22_10-55-45AM_1.log

Verifying environment and performing prerequisite checks...

OPatch continues with these patches: 17478514 18031668 18522509 19121551 19769489 20299013 20760982 21352635 21948347 22502456 23054359 24006111 24732075 25869727 26027154

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

Applying sub-patch '18031668' 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.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.rman, 11.2.0.4.0...

Applying sub-patch '18522509' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'

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.rdbms.deconfig, 11.2.0.4.0...

Applying sub-patch '19121551' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'

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

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

Applying sub-patch '21948347' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'

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 '22502456' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'

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

Applying sub-patch '23054359' 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, 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...

Applying sub-patch '24006111' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'

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

Applying sub-patch '24732075' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'

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 '25869727' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'

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.rdbms.rman, 11.2.0.4.0...

Applying interim patch '26027154' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'

ApplySession: Optional component(s) [ oracle.sqlj, 11.2.0.4.0 ] , [ oracle.sqlj.companion, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.

Patching component oracle.javavm.server, 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.dbjava.jdbc, 11.2.0.4.0...

Patching component oracle.dbjava.ic, 11.2.0.4.0...

Patching component oracle.javavm.client, 11.2.0.4.0...

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

*******************************************************************************************************

** ATTENTION **

** **

** It is critical and essential to complete the post installation (if you are applying the patch) or **

** post deinstallation (if you are doing rollback of the patch) as per Readme to have a working **

** and functional Oracle JavaVM Component. **

** Failure to follow the instructions could lead to inconsistencies in the database. **

** **

*******************************************************************************************************

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

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:

/bin/ld: warning: -z lazyload ignored.

/bin/ld: warning: -z nolazyload ignored.

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:

/bin/ld: warning: -z lazyload ignored.

/bin/ld: warning: -z nolazyload ignored.

Composite patch 25869727 successfully applied.

Patch 26027154 successfully applied.

OPatch Session completed with warnings.

Log file location: /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2018-01-22_10-55-45AM_1.log

OPatch completed with warnings.

16、檢視打補丁的情況

[oracle@seiang OPatch]$ ./opatch lsinventory

Oracle Interim Patch Installer version 11.2.0.3.15

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

OUI version : 11.2.0.4.0

Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2018-01-22_11-04-40AM_1.log

Lsinventory Output file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2018-01-22_11-04-40AM.txt

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

Local Machine Information::

Hostname: seiang.comsys.com

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 (2) :

Patch 26027154 : applied on Mon Jan 22 11:01:27 CST 2018

Unique Patch ID: 21333327

Patch description: "OJVM PATCH SET UPDATE 11.2.0.4.170718"

Created on 7 Jun 2017, 05:23:50 hrs PST8PDT

Bugs fixed:

18933818, 19176885, 17201047, 25067795, 14774730, 19153980, 21911849

23727132, 18166577, 24448240, 17056813, 21811517, 19909862, 25494379

22675136, 24534298, 19895326, 22253904, 17804361, 19231857, 17528315

26023002, 19058059, 19554117, 19007266, 17285560, 22670385, 23265914

18458318, 19187988, 19006757, 19699946, 19374518, 19223010, 25076732

22118835, 19852360, 20408829, 21047766, 21566944

Patch 25869727 : applied on Mon Jan 22 11:01:05 CST 2018

Unique Patch ID: 21364644

Patch description: "Database Patch Set Update : 11.2.0.4.170718 (25869727)"

Created on 21 Jun 2017, 01:40:19 hrs PST8PDT

Sub-patch 24732075; "Database Patch Set Update : 11.2.0.4.170418 (24732075)"

Sub-patch 24006111; "Database Patch Set Update : 11.2.0.4.161018 (24006111)"

Sub-patch 23054359; "Database Patch Set Update : 11.2.0.4.160719 (23054359)"

Sub-patch 22502456; "Database Patch Set Update : 11.2.0.4.160419 (22502456)"

Sub-patch 21948347; "Database Patch Set Update : 11.2.0.4.160119 (21948347)"

Sub-patch 21352635; "Database Patch Set Update : 11.2.0.4.8 (21352635)"

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)"

Bugs fixed:

17184721, 21538558, 16091637, 18092127, 17381384, 15979965, 16731148

13837378, 18441944, 16314254, 17835048, 13558557, 17201159, 25427662

17853498, 17246576, 18356166, 18440047, 18681862, 20387265, 16875449

19788842, 17296856, 21330264, 14010183, 17648596, 17551063, 17025461

17267114, 22507210, 17912217, 17889583, 18202441, 17040764, 25655390

16524926, 17478145, 19358317, 22148226, 18747196, 18641419, 17036973

17811789, 14285317, 16542886, 18009564, 16618694, 8322815, 16832076

16692232, 18247991, 22507234, 17570240, 13871092, 17848897, 17441661

14034426, 17465741, 16596890, 17437634, 20506706, 21343897, 21453153

18339044, 22321741, 17951233, 18430495, 21787056, 22380919, 19469538

20506715, 17811429, 19721304, 18230522, 19554106, 19458377, 17612828

6599380, 22092979, 22321756, 17040527, 17811438, 18641461, 14657740

13364795, 21387964, 17346671, 17588480, 18235390, 17889549, 19309466

16472716, 20596234, 18331850, 18641451, 17344412, 19461270, 21179898

17546761, 24842886, 14521849, 18203835, 18964939, 18203838, 18203837

17313525, 22195457, 18139690, 16837842, 22296366, 14106803, 17842825

22657942, 21352646, 20657441, 16360112, 22195441, 17389192, 14565184

17205719, 18440095, 22195448, 14354737, 14764829, 13944971, 16571443

21868720, 17186905, 17080436, 18673342, 22905130, 17027426, 19972569

19972568, 19972566, 17282229, 19972564, 16870214, 19615136, 17390431

18762750, 16613964, 18098207, 17957017, 18471685, 19730508, 21538485

18264060, 17323222, 17754782, 17600719, 18317531, 17852463, 17596908

17655634, 16228604, 20074391, 19972570, 18996843, 19854503, 16042673

17835627, 20334344, 18000422, 20861693, 17393683, 17551709, 20506699

19006849, 18456514, 18277454, 17258090, 17174582, 17242746, 16399083

17824637, 17762296, 22168163, 17397545, 16450169, 12364061, 20067212

18856999, 19211724, 19463893, 21343775, 19463897, 17853456, 18673304

20004021, 26030218, 21668627, 16194160, 17477958, 16538760, 12982566

18259031, 20296213, 18293054, 17610798, 19699191, 18135678, 17311728

16785708, 10136473, 19777862, 24560906, 17786518, 18315328, 18334586

12747740, 19032867, 18096714, 18899974, 17390160, 17232014, 16422541

18673325, 18155762, 14015842, 19827973, 22683225, 17726838, 18554871

23177648, 18051556, 20803583, 17922254, 15990359, 21972320, 18282562

16855292, 16668584, 21343838, 20299015, 18043064, 17446237, 18093615

17694209, 17288409, 17274537, 13955826, 16934803, 17634921, 17501491

16315398, 22683212, 17006183, 13829543, 18191164, 17655240, 19393542

18384391, 21538567, 16198143, 21847223, 25823754, 17892268, 20142975

19584068, 17165204, 18508861, 21756699, 16901385, 18554763, 18189036

17443671, 17385178, 17936109, 14829250, 20925795, 20509482, 17478514

16850630, 13951456, 16595641, 15861775, 14054676, 16912439, 17299889

17297939, 18619917, 16833527, 17798953, 17816865, 18607546, 17571306

21286665, 17341326, 17851160, 20558005, 17586955, 19049453, 21051840

17587063, 16956380, 18328509, 25423453, 14133975, 18061914, 21051833

18522509, 18765602, 18199537, 17332800, 13609098, 18384537, 22502493

14338435, 17945983, 21067387, 16392068, 17752995, 21051862, 25505382

17237521, 16863422, 18244962, 19544839, 24433711, 17156148, 18973907

17877323, 17449815, 18180390, 17088068, 17037130, 20004087, 19466309

25505371, 11733603, 18084625, 21051858, 18674024, 21051852, 18091059

16306373, 25369547, 18306996, 19915271, 18193833, 17787259, 20631274

25879656, 16344544, 14692762, 18614015, 17346091, 18228645, 17721717

18436307, 19888853, 21756677, 11883252, 17891943, 22353199, 16384983

19121551, 12816846, 17982555, 17761775, 22243719, 17265217, 25505394

17071721, 16721594, 21756661, 18262334, 15913355, 17891946, 17672719

17602269, 17239687, 17042658, 17238511, 17811456, 17284817, 20879889

17752121, 17394950, 16579084, 17011832, 22195465, 14602788, 18325460

24476265, 24476274, 12611721, 16903536, 19689979, 17006570, 16043574

18783224, 16494615, 21526048, 19197175, 16069901, 17811447, 17308789

22195477, 17865671, 19013183, 17343514, 17325413, 18316692, 16180763

17348614, 14368995, 21983325, 17393915, 16285691, 20331945, 17883081

24316947, 17705023, 17614227, 19578350, 22195485, 14084247, 13645875

16777840, 19727057, 14852021, 18744139, 18674047, 17716305, 18482502

17622427, 19289642, 22195492, 14458214, 18723434, 17767676, 25505407

19258504, 17786278, 17082983, 17365043, 21351877, 13498382, 18331812

16065166, 16685417, 18031668, 22893153, 16943711, 21517440, 17649265

13866822, 18094246, 24528741, 14245531, 17783588, 17082359, 20448824

18280813, 23330119, 16268425, 25600421, 17302277, 18018515, 17215560

24411921, 19271443, 17016369, 20777150, 23330124, 20441797, 19769489

25093656, 17545847, 18260550, 13853126, 23536835, 17227277, 25957038

19207117, 9756271, 18868646, 17614134, 17546973, 18704244, 19680952

17050888, 18828868, 18273830, 17360606, 16992075, 17375354, 12905058

18362222, 17571039, 17468141, 18436647, 17235750, 21168487, 16220077

16929165

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

OPatch succeeded.

17、開啟資料庫，升級資料字典

SYS@seiang11g>startup

ORACLE instance started.

Total System Global Area 1252663296 bytes

Fixed Size 2252824 bytes

Variable Size 738201576 bytes

Database Buffers 503316480 bytes

Redo Buffers 8892416 bytes

Database mounted.

Database opened.

SYS@seiang11g>

SYS@seiang11g>@?/rdbms/admin/catbundle.sql psu apply

......(此處省略N行內容)

SYS@seiang11g>COMMIT;

Commit complete.

SYS@seiang11g>SPOOL off

SYS@seiang11g>SET echo off

Check the following log file for errors:

/u01/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_ORADB11G_APPLY_2018Jan22_11_07_33.log

18、升級資料字典結束後，編譯無效物件

SYS@seiang11g>select count(*) from dba_objects where status<>'VALID';

COUNT(*)

----------

75

1 row selected.

SYS@seiang11g>@?/rdbms/admin/utlrp.sql

...... (此處省略N行內容)

Function created.

PL/SQL procedure successfully completed.

Function dropped.

PL/SQL procedure successfully completed.

SYS@seiang11g>select count(*) from dba_objects where status<>'VALID';

COUNT(*)

----------

0

1 row selected.

19、檢視補丁的更新情況

SYS@seiang11g>select ACTION_TIME, ACTION,version, COMMENTS from sys.DBA_REGISTRY_HISTORY;

ACTION_TIME ACTION VERSION COMMENTS

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

24-AUG-13 12.03.45.119862 PM APPLY 11.2.0.4 Patchset 11.2.0.2.0

13-JUL-17 01.06.33.092315 PM APPLY 11.2.0.4 Patchset 11.2.0.2.0

22-JAN-18 11.09.22.892779 AM jvmpsu.sql 11.2.0.4.170718OJVMPSU RAN jvmpsu.sql

22-JAN-18 11.10.32.421155 AM APPLY 11.2.0.4 PSU 11.2.0.4.170718

補丁升級完成！

作者：SEian.G（苦練七十二變，笑對八十一難）

Oracle 11.2.0.4打PSU至11.2.0.4.170718

相關文章