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

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

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

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

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]

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]

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

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

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;

Search This Blog

George Zhou Zhiqing

patching Oracle Database 12.2.0.1 Release Update & Release Update Revision January 2021 Critical Issues (Doc ID 2725763.1)

Comments

Post a Comment

Popular posts from this blog

Sysaux tablespace is too big