patching Oracle Database 12.2.0.1 Release Update & Release Update Revision January 2021 Critical Issues (Doc ID 2725763.1)
1 Determine current patch level
D:\oracle\product\12.2.0\dbhome_1\OPatch>opatch lsinventory -patch -detail
Oracle Interim Patch Installer version 12.2.0.1.6
Copyright (c) 2021, Oracle Corporation. All rights reserved.
Oracle Home : D:\oracle\product\12.2.0\dbhome_1
Central Inventory : C:\Program Files\Oracle\Inventory
from :
OPatch version : 12.2.0.1.6
OUI version : 12.2.0.1.4
Log file location : D:\oracle\product\12.2.0\dbhome_1\cfgtoollogs\opatch\opatch2021-07-09_12-46-58PM_1.log
Lsinventory Output file location : D:\oracle\product\12.2.0\dbhome_1\cfgtoollogs\opatch\lsinv\lsinventory2021-07-09_12-46-58PM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: xxxx
ARU platform id: 233
ARU platform description:: Microsoft Windows (64-bit AMD)
There are no Interim patches installed in this Oracle Home.
--------------------------------------------------------------------------------
OPatch succeeded.
D:\oracle\product\12.2.0\dbhome_1\OPatch>
2 Check oracle latest Opatch for 12.2.0.1
https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=464077050744474&parent=EXTERNAL_SEARCH&sourceId=REFERENCE&id=2725763.1&_afrWindowMode=0&_adf.ctrl-state=1c5j2nt44m_77
2.1 Patch 31987852: WINDOWS DB BUNDLE PATCH 12.2.0.1.210119
https://support.oracle.com/epmos/faces/PatchResultsNDetails?_adf.ctrl-state=1c5j2nt44m_556&releaseId=600000000018520&requestId=23999087&patchId=31987852&languageId=0&platformId=233&searchdata=%3Ccontext+type%3D%22BASIC%22+search%3D%22%26lt%3BSearch%26gt%3B%26lt%3BFilter+name%3D%26quot%3Bpatch_number%26quot%3B+op%3D%26quot%3Bis%26quot%3B+value%3D%26quot%3B31987852%26quot%3B%2F%26gt%3B%26lt%3B%2FSearch%26gt%3B%22%2F%3E&_afrLoop=466795657461119
2.2 Patch 32392089: WINDOWS DB BUNDLE PATCH 12.2.0.1.210420
https://support.oracle.com/epmos/faces/PatchDetail?_afrLoop=466963245692538&patchId=32392089&languageId=0&platformId=233&_afrWindowMode=0&_adf.ctrl-state=1c5j2nt44m_617
2.3 Download and extract
2.4 Open readme file
2.5 You must use the OPatch utility version 12.2.0.1.7 or later
2.5.1 Download latest OPatch OPatch 12.2.0.1.25 for DB 12.x, 18.x, 19.x, 20.x and 21.x releases (May 2021)https://updates.oracle.com/Orion/PatchDetails/handle_plat_lang_change?release=600000000063735&plat_lang=46P&patch_file=&file_id=&password_required=&password_required_readme=&merged_trans=&aru=24232995&patch_num=6880880&patch_num_id=2875132&default_release=600000000063735&default_plat_lang=233P&default_compatible_with=&patch_password=&orderby=&direction=&no_header=0&sortcolpressed=&tab_number=
2.5.2 Unzip and copy OPatch to oracle home, (rename the old OPatch to different name)
2.6 Installation
2.6.1 Patch Pre-Installation Instructions
Before you install BP 12.2.0.1.210420, perform the following actions to check the environment.
D:\oracle\product\12.2.0\dbhome_1> set PATH=%ORACLE_HOME%\perl\bin;%PATH%
D:\oracle\product\12.2.0\dbhome_1>set ORACLE_HOME=D:\oracle\product\12.2.0\dbhome_1
D:\oracle\product\12.2.0\dbhome_1>
Installation
2.6.2 Shutdown instances and listener
D:\oracle\product\12.2.0\dbhome_1>set ORACLE_HOME=D:\oracle\product\12.2.0\dbhome_1\
D:\oracle\product\12.2.0\dbhome_1>set ORACLE_SID=xxx
D:\oracle\product\12.2.0\dbhome_1>sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Fri Jul 9 14:58:32 2021
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production
SQL> shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
D:\oracle\product\12.2.0\dbhome_1>set ORACLE_SID=hrcm
D:\oracle\product\12.2.0\dbhome_1>sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Fri Jul 9 15:00:28 2021
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production
SQL> shutdown immediate;
2.6.3 Explicitly stop the Distributed Transaction Coordinator service (which is not an Oracle service) if it is running.
net stop msdtc
2.6.4 Set the ORACLE_HOME environment variable pointing to your Database Home, go to the directory where the patch is located and then run the OPatch utility by entering the following commands:
2.6.5 unzip p32392089_122010_MSWIN-x86-64.zip
2.6.6 cd 32392089
2.6.7 opatch apply
1. If there are errors, refer to Section 5, "Known Issues".
D:\>set path=D:\oracle\product\12.2.0\dbhome_1\OPatch\;%path%
C:\Windows\system32>net use x: "\\escitnas\installers\Oracle\Opatch\p32392089_122010_MSWIN-x86-64"
The command completed successfully.
C:\Windows\system32>x:
X:\>dir
Volume in drive X is SUPPORT
Volume Serial Number is 5A5B-0C48
Directory of X:\
07/09/2021 02:09 PM <DIR> .
07/09/2021 02:09 PM <DIR> ..
07/09/2021 01:55 PM <DIR> 32392089
04/20/2021 02:03 AM 459,381 PatchSearch.xml
1 File(s) 459,381 bytes
3 Dir(s) 21,400,371,200 bytes free
X:\>cd 32392089
2.6.8 Error
Following active executables are not used by opatch process :
Following active executables are used by opatch process :
D:\oracle\product\12.2.0\dbhome_1\bin\oracle.exe
UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.
Log file location: D:\oracle\product\12.2.0\dbhome_1\cfgtoollogs\opatch\opatch2021-07-09_15-23-26PM_1.log
OPatch failed with error code = 73
X:\32392089>
2.6.8.1 Troubleshooting
https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=474764228972141&parent=EXTERNAL_SEARCH&sourceId=PROBLEM&id=1942237.1&_afrWindowMode=0&_adf.ctrl-state=191ri7nhwp_4
2.6.8.1.1 this oracle knowledgebase is for linux/unix
SOLUTION
As per opatch*.log, there are still processes using one of the files that is being patched:
Following executables are active :
/u01/app/11.2.0/grid/lib/libclntsh.so.11.1
ACTION PLAN
~~~~~~~~~~~
1. As 'root' user, identify process using this file/library:
# fuser /u01/app/11.2.0/grid/lib/libclntsh.so.11.1
# lsof /u01/app/11.2.0/grid/lib/libclntsh.so.11.1
2. You may shutdown application or kill process using above file/library before trying opatch again.
# crsctl stop crs -f
# fuser /u01/app/11.2.0/grid/lib/libclntsh.so.11.1
# kill -9 <ospid of process identified above>
2.6.8.1.2 For windows
Check the service still running, stop it.
X:\32392089>more D:\oracle\product\12.2.0\dbhome_1\cfgtoollogs\opatch\opatch2021-07-09_15-23-26PM_1.log
2.6.9 Run opatch apply again
X:\32392089>opatch apply
Oracle Interim Patch Installer version 12.2.0.1.25
Copyright (c) 2021, Oracle Corporation. All rights reserved.
Oracle Home : D:\oracle\product\12.2.0\dbhome_1
Central Inventory : C:\Program Files\Oracle\Inventory
from :
OPatch version : 12.2.0.1.25
OUI version : 12.2.0.1.4
Log file location : D:\oracle\product\12.2.0\dbhome_1\cfgtoollogs\opatch\opatch2021-07-09_15-39-38PM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 32392089
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 = 'D:\oracle\product\12.2.0\dbhome_1')
Is the local system ready for patching? [y|n] Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '32392089' to OH 'D:\oracle\product\12.2.0\dbhome_1'
ApplySession: Optional component(s) [ oracle.usm, 12.2.0.1.0 ] , [ oracle.rdbms.ic, 12.2.0.1.0 ] , [ oracle.has.cfs, 12.2.0.1.0 ] , [ oracle.has.crs, 12.2.0.1.0 ] , [ oracle.wlm.dbwlm, 12.2.0.1.0 ] , [ oracle.has.cvu, 12.2.0.1.0 ] , [ oracle.tomcat.crs, 12.2.0.1.0 ] , [ oracle.rdbms.tg4db2, 12.2.0.1.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.ldap.rsf, 12.2.0.1.0...
Patch 32392089 successfully applied.
Log file location: D:\oracle\product\12.2.0\dbhome_1\cfgtoollogs\opatch\opatch2021-07-09_15-39-38PM_1.log
OPatch succeeded.
X:\32392089>
2.7 Veriy Opatch
D:\oracle\product\12.2.0\dbhome_1>cd OPatch
D:\oracle\product\12.2.0\dbhome_1\OPatch>opatch lsinventory -patch -detail
Oracle Interim Patch Installer version 12.2.0.1.25
Copyright (c) 2021, Oracle Corporation. All rights reserved.
Oracle Home : D:\oracle\product\12.2.0\dbhome_1
Central Inventory : C:\Program Files\Oracle\Inventory
from :
OPatch version : 12.2.0.1.25
OUI version : 12.2.0.1.4
Log file location : D:\oracle\product\12.2.0\dbhome_1\cfgtoollogs\opatch\opatch2021-07-09_15-48-29PM_1.log
Lsinventory Output file location : D:\oracle\product\12.2.0\dbhome_1\cfgtoollogs\opatch\lsinv\lsinventory2021-07-09_15-48-29PM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: TEMPPAS.esclhin.on.ca
ARU platform id: 233
ARU platform description:: Microsoft Windows (64-bit AMD)
Interim patches (1) :
Patch 32392089 : applied on Fri Jul 09 15:46:14 EDT 2021
Unique Patch ID: 24130249
Patch description: "Windows Database Bundle Patch : 12.2.0.1.210420 (32392089)"
Created on 29 Mar 2021, 07:18:09 hrs PST8PDT
Bugs fixed:
28767240, 25752755, 27828794, 31104809, 27314206, 25823532, 23065002
25313154, 27443406, 28274557, 29933718, 26051656, 25809524, 26361057
23169712, 25971286, 25360661, 25797305, 25051465, 31001455, 28165439
28757685, 25579458, 25299807, 29831371, 25356118, 26968670, 23599216
28821847, 28535127, 28835937, 25308883, 24661214, 25425983, 27119820
25263960, 21070321, 24567222, 24336973, 25216003, 25810704, 29375984
28483184, 28632559, 29850849, 26243617, 29625065, 27511443, 23533647
30031027, 27131551, 24967993, 18774543, 27087426, 29846645, 28494942
2.8 Verify oracle database
2.8.1 Start all windows services stopped during opatch
Listener and database will be automatically started as well
X:\32392089>set ORACLE_SID=hrcm
X:\32392089>sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Fri Jul 9 15:53:48 2021
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production
SQL> show con_name
CON_NAME
------------------------------
HRCM
SQL> select * from v$database;
Comments
Post a Comment