This document describes how to apply JAN 2020 PSU patches on 12.1.0.2 database in 2 node RAC.
Below are the steps to complete PSU patch on database Home.
1. Download PSU patch
2. Upgrade opatch to latest version
3. Analyze the patches (prepatch analysis)
4. Apply PSU patch on DB home
5. Apply OJVM patch
6. Post patch installation steps
1. Download DB and OJVM PSU patch
Download database and ojvm patch from metalink.
2. Upgrade opatch to latest version
Take backup of OPatch folder which is under $ORACLE_HOME
Unzip the patch under $ORACLE_HOME
[oraprod@server1 dbhome_1]$ unzip p6880880_180000_Linux-x86-64.zip
3. Analyze the patches (prepatch analysis)
Analyze the patch with below command. Please raise merge patch request to SR if any conflicts come.
[oraprod@server1 30340202]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.2.0.1.21
Copyright (c) 2020, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/oracle/product/12.1.0/dbhome_1
Central Inventory : /u01/app/grid/oraInventory
from : /u01/app/oracle/product/12.1.0/dbhome_1/oraInst.loc
OPatch version : 12.2.0.1.21
OUI version : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2020-05-03_14-52-11PM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
[oraprod@server1 30340202]$
4. Apply PSU patch on DB home
Proceed to apply PSU patch if there is no conflicts come.
[oraprod@server1 30340202]$ opatch apply -local
Oracle Interim Patch Installer version 12.2.0.1.21
Copyright (c) 2020, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/12.1.0/dbhome_1
Central Inventory : /u01/app/grid/oraInventory
from : /u01/app/oracle/product/12.1.0/dbhome_1/oraInst.loc
OPatch version : 12.2.0.1.21
OUI version : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2020-05-03_14-52-53PM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 19769480 20299023 20831110 21359755 21948354 22291127 23054246 24006101 24732082 25171037 25755742 26609783 26713565 26925311 27338041 27547329 28259833 28729169 29141015 29494060 29918340 30340202
Do you want to proceed? [y|n]
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/oracle/product/12.1.0/dbhome_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying sub-patch '19769480' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'
Patching component oracle.rdbms.deconfig, 12.1.0.2.0...
Patching component oracle.xdk, 12.1.0.2.0...
Patching component oracle.tfa, 12.1.0.2.0...
Patching component oracle.rdbms.util, 12.1.0.2.0...
Patching component oracle.rdbms, 12.1.0.2.0...
Post Install patch steps:
Start the database and run datapatch verbose.
[oraprod@server1 OPatch]$ ./datapatch -verbose
SQL Patching tool version 12.1.0.2.0 Production on Sun May 3 16:23:44 2020
Copyright (c) 2012, 2016, Oracle. All rights reserved.
Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_6268_2020_05_03_16_23_48/sqlpatch_invocation.log
Connecting to database...OK
Bootstrapping registry and package to current versions...done
Determining current state...done
Current state of SQL patches:
Bundle series PSU:
ID 200114 in the binary registry and not installed in the SQL registry
Adding patches to installation queue and performing prereq checks...
Installation queue:
Nothing to roll back
The following patches will be applied:
30340202 (DATABASE PATCH SET UPDATE 12.1.0.2.200114)
Installing patches...
Patch installation complete. Total patches installed: 1
Validating logfiles...
Patch 30340202 apply: SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/30340202/23284744/30340202_apply_GOLD_2020May03_16_49_42.log (no errors)
SQL Patching tool complete on Sun May 3 16:56:13 2020
[oraprod@server1 OPatch]$
Apply the patch in 2nd node as well.
5. Apply OJVM patch
Apply OJVM patch if the environment is enable for OJVM.
[oraprod@server1 30502041]$ /u01/app/oracle/product/12.1.0/dbhome_1/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.2.0.1.21
Copyright (c) 2020, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/oracle/product/12.1.0/dbhome_1
Central Inventory : /u01/app/grid/oraInventory
from : /u01/app/oracle/product/12.1.0/dbhome_1//oraInst.loc
OPatch version : 12.2.0.1.21
OUI version : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2020-05-06_08-29-35AM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
[oraprod@server1 30502041]$
[oraprod@server1 30502041]$ /u01/app/oracle/product/12.1.0/dbhome_1/OPatch/opatch apply -local
Oracle Interim Patch Installer version 12.2.0.1.21
Copyright (c) 2020, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/12.1.0/dbhome_1
Central Inventory : /u01/app/grid/oraInventory
from : /u01/app/oracle/product/12.1.0/dbhome_1//oraInst.loc
OPatch version : 12.2.0.1.21
OUI version : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2020-05-06_08-30-51AM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 30502041
Do you want to proceed? [y|n]
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/oracle/product/12.1.0/dbhome_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '30502041' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'
ApplySession: Optional component(s) [ oracle.sqlj, 12.1.0.2.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.javavm.server, 12.1.0.2.0...
Patching component oracle.javavm.server.core, 12.1.0.2.0...
Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...
Patching component oracle.rdbms, 12.1.0.2.0...
Patching component oracle.javavm.client, 12.1.0.2.0...
Patching component oracle.dbjava.jdbc, 12.1.0.2.0...
Patching component oracle.dbjava.ic, 12.1.0.2.0...
Patch 30502041 successfully applied.
Log file location: /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2020-05-06_08-30-51AM_1.log
OPatch succeeded.
[oraprod@server1 30502041]$
Apply the patch in 2nd node as well.
6. Post patch installation steps
Apply post install patch steps as per Readme.txt file.
SQL> startup upgrade
ORACLE instance started.
Total System Global Area 1140850688 bytes
Fixed Size 2923584 bytes
Variable Size 486540224 bytes
Database Buffers 637534208 bytes
Redo Buffers 13852672 bytes
Database mounted.
Database opened.
SQL> exit
[oraprod@server1 OPatch]$ ./datapatch -verbose
SQL Patching tool version 12.1.0.2.0 Production on Wed May 6 12:04:16 2020
Copyright (c) 2012, 2016, Oracle. All rights reserved.
Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_27693_2020_05_06_12_04_16/sqlpatch_invocation.log
Connecting to database...OK
Bootstrapping registry and package to current versions...done
Determining current state...done
Current state of SQL patches:
Patch 30502041 (Database PSU 12.1.0.2.200114, Oracle JavaVM Component (JAN2020)):
Installed in the binary registry only
Bundle series PSU:
ID 200114 in the binary registry and ID 200114 in the SQL registry
Adding patches to installation queue and performing prereq checks...
Installation queue:
Nothing to roll back
The following patches will be applied:
30502041 (Database PSU 12.1.0.2.200114, Oracle JavaVM Component (JAN2020))
Installing patches...
Patch installation complete. Total patches installed: 1
Validating logfiles...
Patch 30502041 apply: SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/30502041/23243463/30502041_apply_GOLD_2020May06_12_05_00.log (no errors)
SQL Patching tool complete on Wed May 6 12:06:44 2020
[oraprod@server1 OPatch]$
No comments:
Post a Comment