Patching

How to Apply Patch in Oracle Database

Keeping your database running with the newest release of Oracle software might be a critical job for DBA to implement. In this post, I will talk about the steps that we apply patch.

Pre-Patching

1. Get the Latest OPatch

Before any patching, you have to make sure your OPatch utility is the latest version in order to apply your patches successfully.

2. Upload and Unzip Patch

You can create a directory to put all your patches and unzip them for use. In this case, we take patch P27734982 for an example for release 11.2.0.4 on Linux 64-bit. Suppose the zipped patch file has been uploaded to the server via sftp.

[oracle@test ~]$ cd patches
[oracle@test patches]$ unzip -q p27734982_112040_Linux-x86-64.zip

3. Stop All Services

Not all patches require a stopped database before patching, you have to check readme.txt in your patch files.

[oracle@test patches]$ dbshut $ORACLE_HOME
Processing Database instance "ORCL": log file /u01/app/oracle/product/11.2.0/dbhome_1/shutdown.log

Both instance and listener will be stopped if /etc/oratab is properly set.

4. List Inventory Before Patching

For demonstrating now and then, we list the inventory of Oracle software before patching.

[oracle@test patches]$ opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.19
Copyright (c) 2018, 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.19
OUI version       : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2018-09-11_20-27-24PM_1.log

Lsinventory Output file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2018-09-11_20-27-24PM.txt

--------------------------------------------------------------------------------
Local Machine Information::
Hostname: test
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.


There are no Interim patches installed in this Oracle Home.


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

OPatch succeeded.

Apply Patch

1. Switch to the Directory of Patch

Please note that P27734982 is a patch set that contains several sub patches for solving several bugs.

[oracle@test patches]$ cd 27734982/
[oracle@test 27734982]$ ll
total 148
drwxrwxrwx. 4 oracle oinstall  4096 May 31 16:37 17478514
drwxrwxrwx. 4 oracle oinstall  4096 May 31 16:37 18031668
drwxrwxrwx. 4 oracle oinstall  4096 May 31 16:37 18522509
drwxrwxrwx. 4 oracle oinstall  4096 May 31 16:37 19121551
drwxrwxrwx. 4 oracle oinstall  4096 May 31 16:37 19769489
drwxrwxrwx. 4 oracle oinstall  4096 May 31 16:37 20299013
drwxrwxrwx. 4 oracle oinstall  4096 May 31 16:37 20760982
drwxrwxrwx. 4 oracle oinstall  4096 May 31 16:37 21352635
drwxrwxrwx. 4 oracle oinstall  4096 May 31 16:37 21948347
drwxrwxrwx. 4 oracle oinstall  4096 May 31 16:37 22502456
drwxrwxrwx. 4 oracle oinstall  4096 May 31 16:37 23054359
drwxrwxrwx. 4 oracle oinstall  4096 May 31 16:37 24006111
drwxrwxrwx. 4 oracle oinstall  4096 May 31 16:37 24732075
drwxrwxrwx. 4 oracle oinstall  4096 May 31 16:37 25869727
drwxrwxrwx. 4 oracle oinstall  4096 May 31 16:37 26392168
drwxrwxrwx. 4 oracle oinstall  4096 May 31 16:37 26609445
drwxrwxrwx. 4 oracle oinstall  4096 May 31 16:37 26925576
drwxrwxrwx. 4 oracle oinstall  4096 May 31 16:37 27338049
drwxrwxrwx. 4 oracle oinstall  4096 May 31 16:37 27734982
-rw-rw-rw-. 1 oracle oinstall  3073 May 31 16:38 patchmd.xml
-rw-rw-r--. 1 oracle oinstall 64953 Jul 12 14:37 README.html
-rw-rw-rw-. 1 oracle oinstall    21 May 31 16:37 README.txt

2. Check Any Conflicts

[oracle@test 27734982]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 11.2.0.3.19
Copyright (c) 2018, Oracle Corporation.  All rights reserved.

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.19
OUI version       : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2018-09-14_19-34-35PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

More options about opatch command can be found at OPatch Syntax and Commands.

3. Start to Apply Patch

[oracle@test 27734982]$ opatch apply
Oracle Interim Patch Installer version 11.2.0.3.19
Copyright (c) 2018, 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.19
OUI version       : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2018-09-11_20-32-19PM_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  26609445  26392168  26925576  27338049  27734982

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.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 sub-patch '26609445' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'

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

Patching component oracle.rdbms, 11.2.0.4.0...
Applying sub-patch '26392168' 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.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.rman, 11.2.0.4.0...
Applying sub-patch '26925576' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'

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.rdbms.rsf, 11.2.0.4.0...
Applying sub-patch '27338049' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'

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.rdbms.dbscripts, 11.2.0.4.0...
Applying sub-patch '27734982' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'

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/app/oracle/product/11.2.0/dbhome_1/bin/extjobO': Operation not permitted
make: [iextjob] Error 1 (ignored)


Composite patch 27734982 successfully applied.
OPatch Session completed with warnings.
Log file location: /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2018-09-11_20-32-19PM_1.log

OPatch completed with warnings.

The warnings can be ignored.

Post-Patching

1. List Inventory After Patching

Let’s see the current status of Oracle software.

[oracle@test ~]$ opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.19
Copyright (c) 2018, 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.19
OUI version       : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2018-09-13_19-04-46PM_1.log

Lsinventory Output file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2018-09-13_19-04-46PM.txt

--------------------------------------------------------------------------------
Local Machine Information::
Hostname: test
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  27734982     : applied on Tue Sep 11 20:35:44 CST 2018
Unique Patch ID:  22229176
Patch description:  "Database Patch Set Update : 11.2.0.4.180717 (27734982)"
   Created on 31 May 2018, 01:37:49 hrs PST8PDT
Sub-patch  27338049; "Database Patch Set Update : 11.2.0.4.180417 (27338049)"
Sub-patch  26925576; "Database Patch Set Update : 11.2.0.4.180116 (26925576)"
Sub-patch  26392168; "Database Patch Set Update : 11.2.0.4.171017 (26392168)"
Sub-patch  26609445; "Database Patch Set Update : 11.2.0.4.170814 (26609445)"
Sub-patch  25869727; "Database Patch Set Update : 11.2.0.4.170718 (25869727)"
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:
     21174504, 17184721, 21538558, 16091637, 18092127, 17381384, 15979965
     20671094, 16731148, 16314254, 13837378, 18441944, 17835048, 13558557
     17008068, 17201159, 25427662, 17853498, 20717359, 17246576, 18356166
     18681862, 18440047, 20569094, 20031873, 16875449, 20387265, 19788842
     17296856, 21330264, 14010183, 17648596, 17551063, 17025461, 24719736
     17267114, 22507210, 17912217, 17889583, 18202441, 17040764, 17478145
     16524926, 25655390, 19358317, 22148226, 18747196, 26544823, 18641419
     17036973, 18948177, 17811789, 16542886, 14285317, 18009564, 16618694
     8322815, 16832076, 18247991, 16692232, 22507234, 17570240, 13871092
     24624166, 24348685, 17848897, 17441661, 14034426, 17465741, 16596890
     17437634, 21343897, 20506706, 21453153, 18339044, 17951233, 22321741
     21795111, 18430495, 21787056, 22380919, 19469538, 20506715, 17811429
     19721304, 17903598, 18230522, 19554106, 19458377, 21281607, 17612828
     6599380, 22092979, 22321756, 17040527, 17811438, 18641461, 14657740
     13364795, 21387964, 19490948, 17346671, 17588480, 22351572, 18235390
     26474853, 18849970, 17889549, 19309466, 16472716, 20596234, 18331850
     18641451, 17344412, 21179898, 19461270, 17546761, 24842886, 14521849
     18203835, 18203838, 18964939, 18203837, 17313525, 22195457, 18139690
     16837842, 22296366, 14106803, 17842825, 21352646, 22657942, 16360112
     20657441, 22195441, 17389192, 26198926, 14565184, 17205719, 18440095
     14764829, 22195448, 14354737, 13944971, 16571443, 21868720, 17186905
     17080436, 18673342, 22905130, 17027426, 27374796, 19972569, 19972568
     20144308, 19972566, 17282229, 19972564, 16870214, 21629064, 19615136
     21354456, 17390431, 18762750, 23007241, 16613964, 17957017, 18098207
     18471685, 19730508, 21538485, 18264060, 17323222, 17754782, 17600719
     18317531, 17852463, 17596908, 17655634, 16228604, 27053456, 20074391
     19972570, 18090142, 18996843, 19854503, 16042673, 17835627, 20334344
     17393683, 20861693, 18000422, 17551709, 26575788, 23315889, 20506699
     19006849, 18277454, 18456514, 19174430, 17258090, 17174582, 25654936
     17242746, 16399083, 17824637, 21132297, 22465352, 17762296, 22168163
     17397545, 16450169, 12364061, 20067212, 18856999, 19211724, 19463893
     19463897, 21343775, 17853456, 18673304, 20004021, 26030218, 21668627
     16194160, 17477958, 16538760, 12982566, 24570598, 20828947, 18259031
     20296213, 18293054, 17610798, 19699191, 23065323, 17311728, 18135678
     18774543, 23294548, 16785708, 10136473, 24560906, 22551446, 19777862
     17786518, 18315328, 18334586, 12747740, 18096714, 19032867, 21641760
     17390160, 18899974, 17232014, 20598042, 18673325, 16422541, 18155762
     14015842, 19827973, 22683225, 17726838, 18554871, 23177648, 18051556
     20803583, 21972320, 15990359, 17922254, 18282562, 16855292, 16668584
     21343838, 20299015, 17446237, 18093615, 18043064, 23713236, 17694209
     17288409, 18308268, 20475845, 17274537, 13955826, 16934803, 17634921
     17501491, 16315398, 23725036, 22683212, 17006183, 13829543, 18191164
     17655240, 26746894, 22809871, 18384391, 19393542, 21538567, 16198143
     21847223, 25823754, 17892268, 20142975, 19584068, 17165204, 25165496
     18604493, 21756699, 18508861, 16901385, 18554763, 21532755, 18189036
     17443671, 17385178, 14829250, 17936109, 20925795, 20509482, 17478514
     27441326, 16850630, 13951456, 16595641, 14054676, 15861775, 21142837
     16912439, 17299889, 17297939, 23003979, 18619917, 16833527, 17798953
     17816865, 18607546, 17571306, 21286665, 17341326, 26910644, 17851160
     20558005, 17586955, 19049453, 21051840, 17587063, 16956380, 18328509
     25423453, 14133975, 18061914, 18522509, 21051833, 20294666, 18765602
     20860659, 20324049, 18199537, 17332800, 13609098, 22502493, 18384537
     14338435, 17945983, 16392068, 21067387, 17752995, 21051862, 16863422
     25505382, 17237521, 18244962, 19544839, 24433711, 24717859, 17156148
     18973907, 23026585, 17877323, 17449815, 18180390, 17088068, 17037130
     20004087, 21422580, 19466309, 11733603, 25505371, 21051858, 18084625
     18674024, 21051852, 18091059, 25369547, 16306373, 18306996, 17787259
     18193833, 19915271, 20513399, 20631274, 25879656, 16344544, 14692762
     18614015, 17346091, 18228645, 17721717, 18436307, 21756677, 19888853
     11883252, 17891943, 19475971, 22353199, 16384983, 19121551, 27825893
     12816846, 17982555, 17761775, 22243719, 17265217, 25505394, 17071721
     16721594, 18262334, 21756661, 17891946, 15913355, 17672719, 17602269
     17239687, 17042658, 17238511, 17811456, 17284817, 17752121, 20879889
     21380789, 17394950, 17011832, 16579084, 22195465, 14602788, 18325460
     24476265, 26569225, 24476274, 12611721, 16903536, 17006570, 19689979
     16043574, 18783224, 24662775, 16494615, 21526048, 17392698, 19197175
     16069901, 17811447, 27870645, 17308789, 22195477, 24835538, 17865671
     17343514, 19013183, 17325413, 18316692, 16180763, 17348614, 14368995
     21983325, 17393915, 16285691, 19211433, 20331945, 17883081, 17705023
     24316947, 17614227, 19578350, 22195485, 14084247, 13645875, 16777840
     19727057, 14852021, 18744139, 18674047, 17716305, 19285025, 18482502
     27534509, 17622427, 19289642, 22195492, 25947799, 14458214, 20869721
     21172913, 17767676, 18723434, 25505407, 17786278, 19258504, 17082983
     21351877, 17365043, 13498382, 18331812, 16065166, 25489607, 16685417
     18031668, 22893153, 16943711, 19272701, 21517440, 25897615, 17649265
     13866822, 18094246, 24528741, 17783588, 14245531, 17082359, 18280813
     20448824, 23330119, 16268425, 19487147, 25600421, 18018515, 17302277
     17215560, 24411921, 19271443, 25764020, 17016369, 20777150, 23330124
     16756406, 20441797, 19769489, 28100487, 17545847, 25093656, 18260550
     13853126, 17227277, 23536835, 25957038, 24652769, 19207117, 9756271
     18868646, 17614134, 26667023, 17546973, 18704244, 19680952, 26667015
     17050888, 18828868, 18273830, 17360606, 16992075, 24563422, 17375354
     12905058, 18362222, 21429602, 27086138, 17571039, 17468141, 18436647
     17235750, 21168487, 16220077, 16929165



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

OPatch succeeded.

Obviously, the patch set is applied into Oracle software.

2. Startup the Database

[oracle@test 27734982]$ sqlplus / as sysdba
...
SQL> startup
...

3. Load Modified SQL Files into the Database

The catbundle.sql execution is reflected in the dba_registry_history view by a row associated with bundle series PSU. For patch sets updates (PSU), we add option psu apply after catbundle.sql.

SQL> @?/rdbms/admin/catbundle.sql psu apply
...

4. Recompile All Invalid Objects

utlrp.sql is meant to recompile invalid programming units in the database. In some situations, this step may be skipped. You have to check the readme.txt in the patch files for sure.

SQL> @?/rdbms/admin/utlrp.sql
...

Now the database is ready for users to use.

More guides and techniques can be found at Introduction to OPatch and Patching.

2 thoughts on “How to Apply Patch in Oracle Database

  1. Good Day,

    I am trying to apply a patching on WLS 12.1.2. It shows the patching is successful. opatch lsinventory command also shows the patching was successful. The problem, the same thing doesnt reflect on Weblogic console. On the General tab, it still showing the old version. Need some enlightenment.

Leave a Reply

Your email address will not be published. Required fields are marked *