<<Back to DB Administration Main Page
How to Patch oracle 18c/19c Non RAC (Single Instance) database
NOTE: Starting from 18c Oracle calls Patch Set Update (PSU), as Release Update (RU).S
tep1> Download the Patch
Download the patch to be applied from oracle support
Step2> Transfer the patch on the sever and unzip it using unzip utility
Note: I am using OCT2019 PSU(RU) together with OJVM patch
p30112122_180000_Linux-x86-64.zip <= OCT DB PSU (DB RU)
p30133603_180000_Linux-x86-64.zip <= OCT JAVA Patch
$unzip p30112122_180000_Linux-x86-64.zip -d /OCT_2019_PSU/
$unzip p30133603_180000_Linux-x86-64.zip -d /OCT_2019_PSU/
Step3> Verify Utility the Opatch version
OPatch Utility:
You must use the OPatch utility version as described in README file for the patch. Oracle recommends that you use the latest released OPatch version for 18c, which is available for download from My Oracle Support patch 6880880 by selecting the 18.0.0.0.0 release.
$export PATH=$PATH:$ORACLE_HOME/OPatch
$opatch version
OPatch Version: 12.2.0.1.17
OPatch succeeded.
Step4> Perform Patch Conflict Detection and Resolution
export ORACLE_HOME=/u01/app/product/18c/db_home
export PATH=$PATH:$ORACLE_HOME/OPatch
cd /OCT_2019_PSU/30112122/
opatch prereq CheckConflictAgainstOHWithDetail -ph ./
cd /OCT_2019_PSU/30133603/
opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Logs Provided Below "Conflict Resolution Run Log"
Step5> Apply the patch
To apply the patch shut down all the database listener from the OH you are going to patch
Apply DB PSU
as oracle user
$cd /OCT_2019_PSU/30112122/$opatch apply
Apply Java Patch
$cd /OCT_2019_PSU/30133603/
$opatch apply
logs for DB patch and JAVA patch provided below
"DB Patch Run Log"
"JAVA Patch Run Log"
sqlplus /nolog
SQL> Connect / as sysdba
SQL> startup
SQL> alter pluggable database all open;
SQL> quit
$lsnrctl start LISTENER01
Step7> Load Modified SQL Files into the Database
cd $ORACLE_HOME/OPatch
./datapatch -verbose
Logs provided below "Datapatch Run Log"
Step8> Run utlrp.slq to compile the invalid Objects
cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> @utlrp.sql
=========================================================
Conflict Resolution Run Log
opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.2.0.1.17
Copyright (c) 2019, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/product/18c/db_home
Central Inventory : /u01/oraInventory
from : /u01/app/product/18c/db_home/oraInst.loc
OPatch version : 12.2.0.1.17
OUI version : 12.2.0.4.0
Log file location : /u01/app/product/18c/db_home/cfgtoollogs/opatch/opatch2019-10-25_09-21-50AM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
=========================================================
=========================================================
DB Patch Run Log
export ORACLE_HOME=/u01/app/product/18c/db_home
export PATH=$PATH:$ORACLE_HOME/OPatch
cd /OCT_2019_PSU/30112122/
opatch apply
Oracle Interim Patch Installer version 12.2.0.1.17
Copyright (c) 2019, Oracle Corporation. All rights reserved.
export PATH=$PATH:$ORACLE_HOME/OPatch
cd /OCT_2019_PSU/30112122/
opatch apply
Oracle Interim Patch Installer version 12.2.0.1.17
Copyright (c) 2019, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/product/18c/db_home
Central Inventory : /home/oracle/oraInventory
from : /u01/app/product/18c/db_home/oraInst.loc
OPatch version : 12.2.0.1.17
OUI version : 12.2.0.4.0
Log file location : /u01/app/product/18c/db_home/cfgtoollogs/opatch/opatch2019-10-25_09-35-06AM_1.log
Central Inventory : /home/oracle/oraInventory
from : /u01/app/product/18c/db_home/oraInst.loc
OPatch version : 12.2.0.1.17
OUI version : 12.2.0.4.0
Log file location : /u01/app/product/18c/db_home/cfgtoollogs/opatch/opatch2019-10-25_09-35-06AM_1.log
Verifying environment and performing prerequisite checks...
--------------------------------------------------------------------------------
Start OOP by Prereq process.
Launch OOP...
Start OOP by Prereq process.
Launch OOP...
Oracle Interim Patch Installer version 12.2.0.1.17
Copyright (c) 2019, Oracle Corporation. All rights reserved.
Copyright (c) 2019, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/product/18c/db_home
Central Inventory : /home/oracle/oraInventory
from : /u01/app/product/18c/db_home/oraInst.loc
OPatch version : 12.2.0.1.17
OUI version : 12.2.0.4.0
Log file location : /u01/app/product/18c/db_home/cfgtoollogs/opatch/opatch2019-10-25_09-35-24AM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 30112122
OPatch continues with these patches: 30112122
Do you want to proceed? [y|n]
Y (auto-answered by -silent)
User Responded with: Y
All checks passed.
Y (auto-answered by -silent)
User Responded with: Y
All checks passed.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/product/18c/db_home')
(Oracle Home = '/u01/app/product/18c/db_home')
Is the local system ready for patching? [y|n]
Y (auto-answered by -silent)
User Responded with: Y
Backing up files...
Applying interim patch '30112122' to OH '/u01/app/product/18c/db_home'
ApplySession: Optional component(s) [ oracle.assistants.server.oui, 18.0.0.0.0 ] , [ oracle.has.crs, 18.0.0.0.0 ] , [ oracle.network.gsm, 18.0.0.0.0 ] , [ oracle.rdbms.tg4db2, 18.0.0.0.0 ] , [ oracle.network.cman, 18.0.0.0.0 ] , [ oracle.crs, 18.0.0.0.0 ] , [ oracle.assistants.usm, 18.0.0.0.0 ] , [ oracle.tfa, 18.0.0.0.0 ] , [ oracle.rdbms.tg4tera, 18.0.0.0.0 ] , [ oracle.rdbms.tg4msql, 18.0.0.0.0 ] , [ oracle.rdbms.tg4ifmx, 18.0.0.0.0 ] , [ oracle.assistants.asm, 18.0.0.0.0 ] , [ oracle.rdbms.tg4sybs, 18.0.0.0.0 ] , [ oracle.ons.daemon, 18.0.0.0.0 ] , [ oracle.options.olap, 18.0.0.0.0 ] , [ oracle.net.cman, 18.0.0.0.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.rdbms.rsf, 18.0.0.0.0...
Patching component oracle.rdbms, 18.0.0.0.0...
Patching component oracle.assistants.acf, 18.0.0.0.0...
Patching component oracle.assistants.server, 18.0.0.0.0...
Patching component oracle.ctx, 18.0.0.0.0...
Patching component oracle.dbjava.ic, 18.0.0.0.0...
Patching component oracle.dbjava.jdbc, 18.0.0.0.0...
Patching component oracle.dbjava.ucp, 18.0.0.0.0...
Patching component oracle.javavm.client, 18.0.0.0.0...
Patching component oracle.ldap.owm, 18.0.0.0.0...
Patching component oracle.ldap.rsf, 18.0.0.0.0...
Patching component oracle.ldap.security.osdt, 18.0.0.0.0...
Patching component oracle.network.rsf, 18.0.0.0.0...
Patching component oracle.rdbms.dbscripts, 18.0.0.0.0...
Patching component oracle.rdbms.install.common, 18.0.0.0.0...
Patching component oracle.rdbms.install.plugins, 18.0.0.0.0...
Patching component oracle.rdbms.oci, 18.0.0.0.0...
Patching component oracle.sdo, 18.0.0.0.0...
Patching component oracle.sdo.locator.jrf, 18.0.0.0.0...
Patching component oracle.sqlplus, 18.0.0.0.0...
Patching component oracle.precomp.rsf, 18.0.0.0.0...
Patching component oracle.sqlplus.ic, 18.0.0.0.0...
Patching component oracle.xdk.rsf, 18.0.0.0.0...
Patching component oracle.rdbms.hsodbc, 18.0.0.0.0...
Patching component oracle.ons, 18.0.0.0.0...
Patching component oracle.rdbms.rman, 18.0.0.0.0...
Patching component oracle.oracore.rsf, 18.0.0.0.0...
Patching component oracle.rdbms.crs, 18.0.0.0.0...
Patching component oracle.ctx.rsf, 18.0.0.0.0...
Patching component oracle.network.client, 18.0.0.0.0...
Patching component oracle.server, 18.0.0.0.0...
Patching component oracle.oraolap.dbscripts, 18.0.0.0.0...
Patching component oracle.nlsrtl.rsf.core, 18.0.0.0.0...
Patching component oracle.rdbms.util, 18.0.0.0.0...
Patching component oracle.oraolap, 18.0.0.0.0...
Patching component oracle.odbc, 18.0.0.0.0...
Patching component oracle.sdo.locator, 18.0.0.0.0...
Patching component oracle.nlsrtl.rsf, 18.0.0.0.0...
Patching component oracle.ldap.rsf.ic, 18.0.0.0.0...
Patching component oracle.assistants.deconfig, 18.0.0.0.0...
Patching component oracle.xdk, 18.0.0.0.0...
Patching component oracle.install.deinstalltool, 18.0.0.0.0...
Patching component oracle.duma, 18.0.0.0.0...
Patching component oracle.ctx.atg, 18.0.0.0.0...
Patching component oracle.xdk.parser.java, 18.0.0.0.0...
Patching component oracle.rdbms.deconfig, 18.0.0.0.0...
Patching component oracle.network.listener, 18.0.0.0.0...
Patching component oracle.rdbms.rsf.ic, 18.0.0.0.0...
Patching component oracle.precomp.lang, 18.0.0.0.0...
Patching component oracle.precomp.common, 18.0.0.0.0...
Patch 30112122 successfully applied.
Sub-set patch [29757256] has become inactive due to the application of a super-set patch [30112122].
Please refer to Doc ID 2161861.1 for any possible further required actions.
Log file location: /u01/app/product/18c/db_home/cfgtoollogs/opatch/opatch2019-10-25_09-35-24AM_1.log
Patch 30112122 successfully applied.
Sub-set patch [29757256] has become inactive due to the application of a super-set patch [30112122].
Please refer to Doc ID 2161861.1 for any possible further required actions.
Log file location: /u01/app/product/18c/db_home/cfgtoollogs/opatch/opatch2019-10-25_09-35-24AM_1.log
OPatch succeeded.
=========================================================
=========================================================
cd /OCT_2019_PSU/30133603/
opatch apply
opatch apply
Oracle Interim Patch Installer version 12.2.0.1.17
Copyright (c) 2019, Oracle Corporation. All rights reserved.
Copyright (c) 2019, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/product/18c/db_home
Central Inventory : /home/oracle/oraInventory
from : /u01/app/product/18c/db_home/oraInst.loc
OPatch version : 12.2.0.1.17
OUI version : 12.2.0.4.0
Log file location : /u01/app/product/18c/db_home/cfgtoollogs/opatch/opatch2019-10-25_09-40-40AM_1.log
Central Inventory : /home/oracle/oraInventory
from : /u01/app/product/18c/db_home/oraInst.loc
OPatch version : 12.2.0.1.17
OUI version : 12.2.0.4.0
Log file location : /u01/app/product/18c/db_home/cfgtoollogs/opatch/opatch2019-10-25_09-40-40AM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 30133603
OPatch continues with these patches: 30133603
Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
y
User Responded with: Y
All checks passed.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/product/18c/db_home')
(Oracle Home = '/u01/app/product/18c/db_home')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '30133603' to OH '/u01/app/product/18c/db_home'
Patching component oracle.javavm.server, 18.0.0.0.0...
Patching component oracle.javavm.server.core, 18.0.0.0.0...
Patching component oracle.rdbms.dbscripts, 18.0.0.0.0...
Patching component oracle.rdbms, 18.0.0.0.0...
Patching component oracle.javavm.client, 18.0.0.0.0...
Patch 30133603 successfully applied.
Sub-set patch [29774410] has become inactive due to the application of a super-set patch [30133603].
Please refer to Doc ID 2161861.1 for any possible further required actions.
Log file location: /u01/app/product/18c/db_home/cfgtoollogs/opatch/opatch2019-10-25_09-40-40AM_1.log
Patch 30133603 successfully applied.
Sub-set patch [29774410] has become inactive due to the application of a super-set patch [30133603].
Please refer to Doc ID 2161861.1 for any possible further required actions.
Log file location: /u01/app/product/18c/db_home/cfgtoollogs/opatch/opatch2019-10-25_09-40-40AM_1.log
OPatch succeeded.
=========================================================
=========================================================
cd $ORACLE_HOME/OPatch
./datapatch -verbose
SQL Patching tool version 18.0.0.0.0 Production on Fri Oct 25 10:01:01 2019
Copyright (c) 2012, 2019, Oracle. All rights reserved.
Log file for this invocation: /u01/cfgtoollogs/sqlpatch/sqlpatch_12096_2019_10_25_10_01_01/sqlpatch_invocation.log
Connecting to database...OK
Gathering database info...done
Note: Datapatch will only apply or rollback SQL fixes for PDBs
that are in an open state, no patches will be applied to closed PDBs.
Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation
(Doc ID 1585822.1)
Bootstrapping registry and package to current versions...done
Determining current state...done
Current state of interim SQL patches:
Interim patch 27923415 (OJVM RELEASE UPDATE: 18.3.0.0.180717 (27923415)):
Binary registry: Not installed
PDB CDB$ROOT: Not installed
PDB PDB$SEED: Not installed
Interim patch 29774410 (OJVM RELEASE UPDATE: 18.7.0.0.190716 (29774410)):
Binary registry: Not installed
PDB CDB$ROOT: Applied successfully on 18-OCT-19 01.07.10.275874 PM
PDB PDB$SEED: Applied successfully on 18-OCT-19 01.07.12.312324 PM
Interim patch 30133603 (OJVM RELEASE UPDATE: 18.8.0.0.191015 (30133603)):
Binary registry: Installed
PDB CDB$ROOT: Not installed
PDB PDB$SEED: Not installed
Current state of release update SQL patches:
Binary registry:
18.8.0.0.0 Release_Update 1909032123: Installed
PDB CDB$ROOT:
Applied 18.7.0.0.0 Release_Update 1906241920 successfully on 18-OCT-19 01.07.10.269630 PM
PDB PDB$SEED:
Applied 18.7.0.0.0 Release_Update 1906241920 successfully on 18-OCT-19 01.07.12.305647 PM
Adding patches to installation queue and performing prereq checks...done
Installation queue:
For the following PDBs: CDB$ROOT PDB$SEED
The following interim patches will be rolled back:
29774410 (OJVM RELEASE UPDATE: 18.7.0.0.190716 (29774410))
Patch 30112122 (Database Release Update : 18.8.0.0.191015 (30112122)):
Apply from 18.7.0.0.0 Release_Update 1906241920 to 18.8.0.0.0 Release_Update 1909032123
The following interim patches will be applied:
30133603 (OJVM RELEASE UPDATE: 18.8.0.0.191015 (30133603))
Installing patches...
Patch installation complete. Total patches installed: 6
Validating logfiles...done
Patch 29774410 rollback (pdb CDB$ROOT): SUCCESS
logfile: /u01/cfgtoollogs/sqlpatch/29774410/22958594/29774410_rollback_CDBORCL_CDBROOT_2019Oct25_10_02_01.log (no errors)
Patch 30112122 apply (pdb CDB$ROOT): SUCCESS
logfile: /u01/cfgtoollogs/sqlpatch/30112122/23124066/30112122_apply_CDBORCL_CDBROOT_2019Oct25_10_02_01.log (no errors)
Patch 30133603 apply (pdb CDB$ROOT): SUCCESS
logfile: /u01/cfgtoollogs/sqlpatch/30133603/23088986/30133603_apply_CDBORCL_CDBROOT_2019Oct25_10_02_23.log (no errors)
Patch 29774410 rollback (pdb PDB$SEED): SUCCESS
logfile: /u01/cfgtoollogs/sqlpatch/29774410/22958594/29774410_rollback_CDBORCL_PDBSEED_2019Oct25_10_02_27.log (no errors)
Patch 30112122 apply (pdb PDB$SEED): SUCCESS
logfile: /u01/cfgtoollogs/sqlpatch/30112122/23124066/30112122_apply_CDBORCL_PDBSEED_2019Oct25_10_02_27.log (no errors)
Patch 30133603 apply (pdb PDB$SEED): SUCCESS
logfile: /u01/cfgtoollogs/sqlpatch/30133603/23088986/30133603_apply_CDBORCL_PDBSEED_2019Oct25_10_02_39.log (no errors)
SQL Patching tool complete on Fri Oct 25 10:03:02 2019
=========================================================
Comments
Post a Comment