Bugs Fixed by This Patch

The following are the bugs fixed by this patch:
30614411: LMS IGNORING MESSAGE HANDLER FOR SCN MESSAGE, ORIGINATING INSTANCE WAITING VERY LONG FOR BROADCAST COMPLETION

检查补丁

-bash-4.2$ $ORACLE_HOME/OPatch/opatch lspatches
29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)
29517242;Database Release Update : 19.3.0.0.190416 (29517242)

OPatch succeeded.

检查ORACLE_HOME

-bash-4.2$ echo $ORACLE_HOME
/data/app/oracle/19.0.0/db_home1

解压补丁

-bash-4.2$ unzip p30614411_190000_Linux-x86-64.zip

冲突检查

-bash-4.2$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.2.0.1.17
Copyright (c) 2020, Oracle Corporation. All rights reserved.

PREREQ session

Oracle Home : /data/app/oracle/19.0.0/db_home1
Central Inventory : /data/app/oraInventory
from : /data/app/oracle/19.0.0/db_home1/oraInst.loc
OPatch version : 12.2.0.1.17
OUI version : 12.2.0.7.0
Log file location : /data/app/oracle/19.0.0/db_home1/cfgtoollogs/opatch/opatch2020-07-07_21-41-32PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

安装补丁

-bash-4.2$ $ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local /home/oracle/30614411
Oracle Interim Patch Installer version 12.2.0.1.17
Copyright (c) 2020, Oracle Corporation. All rights reserved.

Oracle Home : /data/app/oracle/19.0.0/db_home1
Central Inventory : /data/app/oraInventory
from : /data/app/oracle/19.0.0/db_home1/oraInst.loc
OPatch version : 12.2.0.1.17
OUI version : 12.2.0.7.0
Log file location : /data/app/oracle/19.0.0/db_home1/cfgtoollogs/opatch/opatch2020-07-07_21-42-58PM_1.log

Verifying environment and performing prerequisite checks…
OPatch continues with these patches: 30614411

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 = '/data/app/oracle/19.0.0/db_home1')

Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files…
Applying interim patch '30614411' to OH '/data/app/oracle/19.0.0/db_home1'

Patching component oracle.rdbms, 19.0.0.0.0…
Patch 30614411 successfully applied.
Log file location: /data/app/oracle/19.0.0/db_home1/cfgtoollogs/opatch/opatch2020-07-07_21-42-58PM_1.log

OPatch succeeded.

检查安装

-bash-4.2$ $ORACLE_HOME/OPatch/opatch lsinv
Oracle Interim Patch Installer version 12.2.0.1.17
Copyright (c) 2020, Oracle Corporation. All rights reserved.

Oracle Home : /data/app/oracle/19.0.0/db_home1
Central Inventory : /data/app/oraInventory
from : /data/app/oracle/19.0.0/db_home1/oraInst.loc
OPatch version : 12.2.0.1.17
OUI version : 12.2.0.7.0
Log file location : /data/app/oracle/19.0.0/db_home1/cfgtoollogs/opatch/opatch2020-07-07_21-44-32PM_1.log

Lsinventory Output file location : /data/app/oracle/19.0.0/db_home1/cfgtoollogs/opatch/lsinv/lsinventory2020-07-07_21-44-32PM.txt

---

Local Machine Information::
Hostname: db19c
ARU platform id: 226
ARU platform description:: Linux x86-64

Installed Top-level Products (1):

Oracle Database 19c 19.0.0.0.0
There are 1 products installed in this Oracle Home.

Interim patches (3) :

Patch 30614411 : applied on Tue Jul 07 21:43:19 CST 2020
Unique Patch ID: 23336374
Patch description: "LMS IGNORING MESSAGE HANDLER FOR SCN MESSAGE, ORIGINATING INSTANCE WAITING VERY LONG FOR BROADCAST COMPLETION"
Created on 27 Jan 2020, 12:27:09 hrs PST8PDT
Bugs fixed:
30614411

-bash-4.2$ $ORACLE_HOME/OPatch/opatch lspatches
30614411;LMS IGNORING MESSAGE HANDLER FOR SCN MESSAGE, ORIGINATING INSTANCE WAITING VERY LONG FOR BROADCAST COMPLETION
29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)
29517242;Database Release Update : 19.3.0.0.190416 (29517242)

OPatch succeeded.

卸载补丁

-bash-4.2$ $ORACLE_HOME/OPatch/opatch rollback -local -id 30614411 -oh $ORACLE_HOME
Oracle Interim Patch Installer version 12.2.0.1.17
Copyright (c) 2020, Oracle Corporation. All rights reserved.

Oracle Home : /data/app/oracle/19.0.0/db_home1
Central Inventory : /data/app/oraInventory
from : /data/app/oracle/19.0.0/db_home1/oraInst.loc
OPatch version : 12.2.0.1.17
OUI version : 12.2.0.7.0
Log file location : /data/app/oracle/19.0.0/db_home1/cfgtoollogs/opatch/opatch2020-07-07_21-45-39PM_1.log

Patches will be rolled back in the following order:
30614411
The following patch(es) will be rolled back: 30614411

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/data/app/oracle/19.0.0/db_home1')

Is the local system ready for patching? [y|n]
y
User Responded with: Y

Rolling back patch 30614411…

RollbackSession rolling back interim patch '30614411' from OH '/data/app/oracle/19.0.0/db_home1'

Patching component oracle.rdbms, 19.0.0.0.0…
RollbackSession removing interim patch '30614411' from inventory
Log file location: /data/app/oracle/19.0.0/db_home1/cfgtoollogs/opatch/opatch2020-07-07_21-45-39PM_1.log

OPatch succeeded.

检查卸载

-bash-4.2$ $ORACLE_HOME/OPatch/opatch lspatches
29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)
29517242;Database Release Update : 19.3.0.0.190416 (29517242)

OPatch succeeded.