p30614411_190000补丁安装

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

冲突检查

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.

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

Do you want to proceed? 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 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.

检查安装

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.

卸载补丁

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 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.