https:\/\/updates.oracle.com\/Orion\/Services\/download?type=readme&aru=24017144<\/a><\/p>\nFirst of all, we check the current patch level on the GRID home.<\/p>\n
\n[oracle@ocm199 ~]$ . GRID\n[oracle@ocm199 ~]$\n[oracle@ocm199 ~]$ opatch lsinv\nOracle Interim Patch Installer version 12.2.0.1.24\nCopyright (c) 2021, Oracle Corporation. All rights reserved.\n\nOracle Home : \/u01\/grid\/19c\nCentral Inventory : \/u01\/app\/oraInventory\n from : \/u01\/grid\/19c\/oraInst.loc\nOPatch version : 12.2.0.1.24\nOUI version : 12.2.0.7.0\nLog file location : \/u01\/grid\/19c\/cfgtoollogs\/opatch\/opatch2021-03-02_03-21-27AM_1.log\n\nLsinventory Output file location : \/u01\/grid\/19c\/cfgtoollogs\/opatch\/lsinv\/lsinventory2021-03-02_03-21-27AM.txt\n--------------------------------------------------------------------------------\nLocal Machine Information::\nHostname: ocm199\nARU platform id: 226\nARU platform description:: Linux x86-64\n\nInstalled Top-level Products (1):\n\nOracle Grid Infrastructure 19c 19.0.0.0.0\nThere are 1 products installed in this Oracle Home.\n\nInterim patches (4) :\n\nPatch 31780966 : applied on Tue Oct 27 03:45:37 EDT 2020\nUnique Patch ID: 23770942\nPatch description: "TOMCAT RELEASE UPDATE 19.0.0.0.0 (31780966)"\n Created on 20 Aug 2020, 09:07:34 hrs PST8PDT\n Bugs fixed:\n 30009095, 31657943, 29286300, 30997459, 30729044\n\nPatch 31773437 : applied on Tue Oct 27 03:45:10 EDT 2020\nUnique Patch ID: 23768260\nPatch description: "ACFS RELEASE UPDATE 19.9.0.0.0 (31773437)"\n Created on 24 Aug 2020, 22:19:56 hrs PST8PDT\n Bugs fixed:\n 27494830, 27917085, 28064731, 28293236, 28321248, 28375150, 28531803\n 28553487, 28611527, 28649123, 28687713, 28701011, 28740425, 28818513\n 28825772, 28837603, 28844788, 28855761, 28860451, 28900212, 28951588\n...\n...\n\nPatch 31772784 : applied on Tue Oct 27 03:44:20 EDT 2020\nUnique Patch ID: 23854876\nPatch description: "OCW RELEASE UPDATE 19.9.0.0.0 (31772784)"\n Created on 10 Oct 2020, 04:06:52 hrs PST8PDT\n Bugs fixed:\n 17787434, 25736599, 26675491, 26813848, 27092095, 27148384, 27222128\n 27262781, 27505699, 27526265, 27572040, 27604329, 27663388, 27760043\n 27877830, 27935374, 28302439, 28302580, 28319989, 28336118, 28344129\n 28406406, 28441307, 28462255, 28470673, 28554809, 28567875, 28621543\n...\n...\n\nPatch 31771877 : applied on Tue Oct 27 03:41:58 EDT 2020\nUnique Patch ID: 23869227\nPatch description: "Database Release Update : 19.9.0.0.201020 (31771877)"\n Created on 7 Oct 2020, 21:34:19 hrs PST8PDT\n Bugs fixed:\n 30150710, 31935717, 7391838, 8460502, 8476681, 14735102, 17428816\n 17468475, 19080742, 19697993, 20313356, 21374587, 21639146, 21888352\n 21965541, 22580355, 22729345, 22748979, 23294761, 23296836, 23606241\n 23645975, 23734075, 23763462, 24596874, 24669730, 24687075, 24833686\n 24971456, 25030027, 25092651, 25093917, 25404117, 25416731, 25560538\n 25756945, 25804387, 25806201, 25809128, 25883179, 25905368, 25986062\n...\n...\n 31668061, 31672605, 31683044, 31718134, 31718346, 31747989, 31758846\n 31781897, 31792615, 31796208, 31796277, 31820859, 31833172, 31867037\n 31876368, 31886547, 31888148, 31897786, 31905033\n\n--------------------------------------------------------------------------------\n\nOPatch succeeded.\n[oracle@ocm199 ~]$\n<\/pre>\nAnd also check the current patch level of the Oracle home:<\/p>\n
\n[oracle@ocm199 ~]$ . ORACLE\n[oracle@ocm199 ~]$ opatch lsinv\nOracle Interim Patch Installer version 12.2.0.1.24\nCopyright (c) 2021, Oracle Corporation. All rights reserved.\n\n\nOracle Home : \/u01\/app\/oracle\/product\/19c\nCentral Inventory : \/u01\/app\/oraInventory\n from : \/u01\/app\/oracle\/product\/19c\/oraInst.loc\nOPatch version : 12.2.0.1.24\nOUI version : 12.2.0.7.0\nLog file location : \/u01\/app\/oracle\/product\/19c\/cfgtoollogs\/opatch\/opatch2021-03-02_03-22-35AM_1.log\n\nLsinventory Output file location : \/u01\/app\/oracle\/product\/19c\/cfgtoollogs\/opatch\/lsinv\/lsinventory2021-03-02_03-22-35AM.txt\n--------------------------------------------------------------------------------\nLocal Machine Information::\nHostname: ocm199\nARU platform id: 226\nARU platform description:: Linux x86-64\n\nInstalled Top-level Products (1):\n\nOracle Database 19c 19.0.0.0.0\nThere are 1 products installed in this Oracle Home.\n\nInterim patches (2) :\n\nPatch 31772784 : applied on Tue Oct 27 06:05:45 EDT 2020\nUnique Patch ID: 23854876\nPatch description: "OCW RELEASE UPDATE 19.9.0.0.0 (31772784)"\n Created on 10 Oct 2020, 04:06:52 hrs PST8PDT\n Bugs fixed:\n 17787434, 25736599, 26675491, 26813848, 27092095, 27148384, 27222128\n 27262781, 27505699, 27526265, 27572040, 27604329, 27663388, 27760043\n 27877830, 27935374, 28302439, 28302580, 28319989, 28336118, 28344129\n 28406406, 28441307, 28462255, 28470673, 28554809, 28567875, 28621543\n 28628631, 28642469, 28697242, 28697896, 28699321, 28704073, 28710663\n...\n...\n\nPatch 31771877 : applied on Tue Oct 27 06:04:27 EDT 2020\nUnique Patch ID: 23869227\nPatch description: "Database Release Update : 19.9.0.0.201020 (31771877)"\n Created on 7 Oct 2020, 21:34:19 hrs PST8PDT\n Bugs fixed:\n 30150710, 31935717, 7391838, 8460502, 8476681, 14735102, 17428816\n 17468475, 19080742, 19697993, 20313356, 21374587, 21639146, 21888352\n 21965541, 22580355, 22729345, 22748979, 23294761, 23296836, 23606241\n 23645975, 23734075, 23763462, 24596874, 24669730, 24687075, 24833686\n 24971456, 25030027, 25092651, 25093917, 25404117, 25416731, 25560538\n 25756945, 25804387, 25806201, 25809128, 25883179, 25905368, 25986062\n...\n...\n 31668061, 31672605, 31683044, 31718134, 31718346, 31747989, 31758846\n 31781897, 31792615, 31796208, 31796277, 31820859, 31833172, 31867037\n 31876368, 31886547, 31888148, 31897786, 31905033\n\n--------------------------------------------------------------------------------\n\nOPatch succeeded.\n[oracle@ocm199 ~]$\n<\/pre>\nAfter checking the current patch level, it is advisable to run the OPatch conflict check. This is still an online operation and no downtime until now. By checking it beforehand, you can save a lot of time, in case some errors should be reported.<\/p>\n
For Grid Infrastructure Home, as home user run the following commands:<\/p>\n
\n$ORACLE_HOME\/OPatch\/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir \/u01\/app\/oracle\/product\/stage\/19.10\/32226239\/32218454\n$ORACLE_HOME\/OPatch\/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir \/u01\/app\/oracle\/product\/stage\/19.10\/32226239\/32222571\n$ORACLE_HOME\/OPatch\/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir \/u01\/app\/oracle\/product\/stage\/19.10\/32226239\/32218663\n$ORACLE_HOME\/OPatch\/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir \/u01\/app\/oracle\/product\/stage\/19.10\/32226239\/29340594\n$ORACLE_HOME\/OPatch\/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir \/u01\/app\/oracle\/product\/stage\/19.10\/32226239\/32240590\n<\/pre>\nFor Database home, as home user run the following commands:<\/p>\n
\n$ORACLE_HOME\/OPatch\/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir \/u01\/app\/oracle\/product\/stage\/19.10\/32226239\/32218454\n$ORACLE_HOME\/OPatch\/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir \/u01\/app\/oracle\/product\/stage\/19.10\/32226239\/32222571\n<\/pre>\n\n[oracle@ocm199 ~]$ . GRID\n[oracle@ocm199 ~]$\n[oracle@ocm199 ~]$ $ORACLE_HOME\/OPatch\/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir \/u01\/app\/oracle\/product\/stage\/19.10\/32226239\/32218454\nOracle Interim Patch Installer version 12.2.0.1.24\nCopyright (c) 2021, Oracle Corporation. All rights reserved.\n\nPREREQ session\n\nOracle Home : \/u01\/grid\/19c\nCentral Inventory : \/u01\/app\/oraInventory\n from : \/u01\/grid\/19c\/oraInst.loc\nOPatch version : 12.2.0.1.24\nOUI version : 12.2.0.7.0\nLog file location : \/u01\/grid\/19c\/cfgtoollogs\/opatch\/opatch2021-03-02_03-26-13AM_1.log\n\nInvoking prereq "checkconflictagainstohwithdetail"\n\nPrereq "checkConflictAgainstOHWithDetail" passed.\n\nOPatch succeeded.\n\n[oracle@ocm199 ~]$ $ORACLE_HOME\/OPatch\/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir \/u01\/app\/oracle\/product\/stage\/19.10\/32226239\/32222571\nOracle Interim Patch Installer version 12.2.0.1.24\nCopyright (c) 2021, Oracle Corporation. All rights reserved.\n\nPREREQ session\n\nOracle Home : \/u01\/grid\/19c\nCentral Inventory : \/u01\/app\/oraInventory\n from : \/u01\/grid\/19c\/oraInst.loc\nOPatch version : 12.2.0.1.24\nOUI version : 12.2.0.7.0\nLog file location : \/u01\/grid\/19c\/cfgtoollogs\/opatch\/opatch2021-03-02_03-27-34AM_1.log\n\nInvoking prereq "checkconflictagainstohwithdetail"\n\nPrereq "checkConflictAgainstOHWithDetail" passed.\n\nOPatch succeeded.\n\n[oracle@ocm199 ~]$ $ORACLE_HOME\/OPatch\/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir \/u01\/app\/oracle\/product\/stage\/19.10\/32226239\/32218663\nOracle Interim Patch Installer version 12.2.0.1.24\nCopyright (c) 2021, Oracle Corporation. All rights reserved.\n\nPREREQ session\n\nOracle Home : \/u01\/grid\/19c\nCentral Inventory : \/u01\/app\/oraInventory\n from : \/u01\/grid\/19c\/oraInst.loc\nOPatch version : 12.2.0.1.24\nOUI version : 12.2.0.7.0\nLog file location : \/u01\/grid\/19c\/cfgtoollogs\/opatch\/opatch2021-03-02_03-27-54AM_1.log\n\nInvoking prereq "checkconflictagainstohwithdetail"\n\nPrereq "checkConflictAgainstOHWithDetail" passed.\n\nOPatch succeeded.\n\n[oracle@ocm199 ~]$ $ORACLE_HOME\/OPatch\/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir \/u01\/app\/oracle\/product\/stage\/19.10\/32226239\/29340594\nOracle Interim Patch Installer version 12.2.0.1.24\nCopyright (c) 2021, Oracle Corporation. All rights reserved.\n\nPREREQ session\n\nOracle Home : \/u01\/grid\/19c\nCentral Inventory : \/u01\/app\/oraInventory\n from : \/u01\/grid\/19c\/oraInst.loc\nOPatch version : 12.2.0.1.24\nOUI version : 12.2.0.7.0\nLog file location : \/u01\/grid\/19c\/cfgtoollogs\/opatch\/opatch2021-03-02_03-28-14AM_1.log\n\nInvoking prereq "checkconflictagainstohwithdetail"\n\nPrereq "checkConflictAgainstOHWithDetail" passed.\n\nOPatch succeeded.\n\n[oracle@ocm199 ~]$ $ORACLE_HOME\/OPatch\/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir \/u01\/app\/oracle\/product\/stage\/19.10\/32226239\/32240590\nOracle Interim Patch Installer version 12.2.0.1.24\nCopyright (c) 2021, Oracle Corporation. All rights reserved.\n\nPREREQ session\n\nOracle Home : \/u01\/grid\/19c\nCentral Inventory : \/u01\/app\/oraInventory\n from : \/u01\/grid\/19c\/oraInst.loc\nOPatch version : 12.2.0.1.24\nOUI version : 12.2.0.7.0\nLog file location : \/u01\/grid\/19c\/cfgtoollogs\/opatch\/opatch2021-03-02_03-28-38AM_1.log\n\nInvoking prereq "checkconflictagainstohwithdetail"\n\nPrereq "checkConflictAgainstOHWithDetail" passed.\n\nOPatch succeeded.\n\n[oracle@ocm199 ~]$ . ORACLE\n[oracle@ocm199 ~]$\n[oracle@ocm199 ~]$\n[oracle@ocm199 ~]$ $ORACLE_HOME\/OPatch\/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir \/u01\/app\/oracle\/product\/stage\/19.10\/32226239\/32218454\nOracle Interim Patch Installer version 12.2.0.1.24\nCopyright (c) 2021, Oracle Corporation. All rights reserved.\n\nPREREQ session\n\nOracle Home : \/u01\/app\/oracle\/product\/19c\nCentral Inventory : \/u01\/app\/oraInventory\n from : \/u01\/app\/oracle\/product\/19c\/oraInst.loc\nOPatch version : 12.2.0.1.24\nOUI version : 12.2.0.7.0\nLog file location : \/u01\/app\/oracle\/product\/19c\/cfgtoollogs\/opatch\/opatch2021-03-02_03-30-11AM_1.log\n\nInvoking prereq "checkconflictagainstohwithdetail"\n\nPrereq "checkConflictAgainstOHWithDetail" passed.\n\nOPatch succeeded.\n[oracle@ocm199 ~]$ $ORACLE_HOME\/OPatch\/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir \/u01\/app\/oracle\/product\/stage\/19.10\/32226239\/32222571\nOracle Interim Patch Installer version 12.2.0.1.24\nCopyright (c) 2021, Oracle Corporation. All rights reserved.\n\nPREREQ session\n\nOracle Home : \/u01\/app\/oracle\/product\/19c\nCentral Inventory : \/u01\/app\/oraInventory\n from : \/u01\/app\/oracle\/product\/19c\/oraInst.loc\nOPatch version : 12.2.0.1.24\nOUI version : 12.2.0.7.0\nLog file location : \/u01\/app\/oracle\/product\/19c\/cfgtoollogs\/opatch\/opatch2021-03-02_03-30-24AM_1.log\n\nInvoking prereq "checkconflictagainstohwithdetail"\n\nPrereq "checkConflictAgainstOHWithDetail" passed.\n\nOPatch succeeded.\n\n<\/pre>\nIf everything succeeds, it is time the run the opatchauto. Be careful, the next step is bringing down CRS service on home \/u01\/grid\/19c, incl. ASM and all associated DB’s with it.<\/p>\n
To start the patching procedure, login as root and run opatchauto.<\/p>\n
\n[root@ocm199 19.10]# \/u01\/grid\/19c\/OPatch\/opatchauto apply \/u01\/app\/oracle\/product\/stage\/19.10\/32226239 -oh \/u01\/grid\/19c\n\nOPatchauto session is initiated at Tue Mar 2 03:33:53 2021\n\nSystem initialization log file is \/u01\/grid\/19c\/cfgtoollogs\/opatchautodb\/systemconfig2021-03-02_03-33-55AM.log.\n\nSession log file is \/u01\/grid\/19c\/cfgtoollogs\/opatchauto\/opatchauto2021-03-02_03-33-58AM.log\nThe id for this session is M34Q\n\nExecuting OPatch prereq operations to verify patch applicability on home \/u01\/grid\/19c\nPatch applicability verified successfully on home \/u01\/grid\/19c\n\nExecuting patch validation checks on home \/u01\/grid\/19c\nPatch validation checks successfully completed on home \/u01\/grid\/19c\n\nPerforming prepatch operations on CRS - bringing down CRS service on home \/u01\/grid\/19c\nPrepatch operation log file location: \/u01\/app\/oracle\/crsdata\/ocm199\/crsconfig\/hapatch_2021-03-02_03-34-30AM.log\nCRS service brought down successfully on home \/u01\/grid\/19c\n\nStart applying binary patch on home \/u01\/grid\/19c\nBinary patch applied successfully on home \/u01\/grid\/19c\n\nPerforming postpatch operations on CRS - starting CRS service on home \/u01\/grid\/19c\nPostpatch operation log file location: \/u01\/app\/oracle\/crsdata\/ocm199\/crsconfig\/hapatch_2021-03-02_03-42-35AM.log\nCRS service started successfully on home \/u01\/grid\/19c\n\nOPatchAuto successful.\n\n--------------------------------Summary--------------------------------\n\nPatching is completed successfully. Please find the summary as follows:\n\nHost:ocm199\nSIHA Home:\/u01\/grid\/19c\nVersion:19.0.0.0.0\nSummary:\n\n==Following patches were SUCCESSFULLY applied:\n\nPatch: \/u01\/app\/oracle\/product\/stage\/19.10\/32226239\/29340594\nLog: \/u01\/grid\/19c\/cfgtoollogs\/opatchauto\/core\/opatch\/opatch2021-03-02_03-34-57AM_1.log\n\nPatch: \/u01\/app\/oracle\/product\/stage\/19.10\/32226239\/32218454\nLog: \/u01\/grid\/19c\/cfgtoollogs\/opatchauto\/core\/opatch\/opatch2021-03-02_03-34-57AM_1.log\n\nPatch: \/u01\/app\/oracle\/product\/stage\/19.10\/32226239\/32218663\nLog: \/u01\/grid\/19c\/cfgtoollogs\/opatchauto\/core\/opatch\/opatch2021-03-02_03-34-57AM_1.log\n\nPatch: \/u01\/app\/oracle\/product\/stage\/19.10\/32226239\/32222571\nLog: \/u01\/grid\/19c\/cfgtoollogs\/opatchauto\/core\/opatch\/opatch2021-03-02_03-34-57AM_1.log\n\nPatch: \/u01\/app\/oracle\/product\/stage\/19.10\/32226239\/32240590\nLog: \/u01\/grid\/19c\/cfgtoollogs\/opatchauto\/core\/opatch\/opatch2021-03-02_03-34-57AM_1.log\n\nOPatchauto session completed at Tue Mar 2 03:43:38 2021\nTime taken to complete the session 9 minutes, 46 seconds\n[root@ocm199 19.10]#\n<\/pre>\nCluster resources and the DB are started automatically again after the patching is done<\/p>\n
\n[oracle@ocm199 OPatch]$ crsctl stat res -t\n--------------------------------------------------------------------------------\nName Target State Server State details\n--------------------------------------------------------------------------------\nLocal Resources\n--------------------------------------------------------------------------------\nora.DATA.dg\n ONLINE ONLINE ocm199 STABLE\nora.FRA.dg\n ONLINE ONLINE ocm199 STABLE\nora.LISTENER.lsnr\n ONLINE ONLINE ocm199 STABLE\nora.asm\n ONLINE ONLINE ocm199 Started,STABLE\nora.ons\n OFFLINE OFFLINE ocm199 STABLE\n--------------------------------------------------------------------------------\nCluster Resources\n--------------------------------------------------------------------------------\nora.cdb.db\n 1 ONLINE ONLINE ocm199 Open,HOME=\/u01\/app\/o\n racle\/product\/19c,ST\n ABLE\nora.cssd\n 1 ONLINE ONLINE ocm199 STABLE\nora.diskmon\n 1 OFFLINE OFFLINE STABLE\nora.evmd\n 1 ONLINE ONLINE ocm199 STABLE\n--------------------------------------------------------------------------------\n[oracle@ocm199 OPatch]$\n<\/pre>\nApply RU to the Oracle home<\/h3>\n
Now we are patching the Oracle home. Take care, the patching is bringing down database service which are attached to the home \/u01\/app\/oracle\/product\/19c<\/p>\n
\n\n[root@ocm199 19.10]# \/u01\/app\/oracle\/product\/19c\/OPatch\/opatchauto apply \/u01\/app\/oracle\/product\/stage\/19.10\/32226239 -oh \/u01\/app\/oracle\/product\/19c\n\nOPatchauto session is initiated at Tue Mar 2 03:53:42 2021\n\nSystem initialization log file is \/u01\/app\/oracle\/product\/19c\/cfgtoollogs\/opatchautodb\/systemconfig2021-03-02_03-53-44AM.log.\n\nSession log file is \/u01\/app\/oracle\/product\/19c\/cfgtoollogs\/opatchauto\/opatchauto2021-03-02_03-53-47AM.log\nThe id for this session is 2X84\n\nExecuting OPatch prereq operations to verify patch applicability on home \/u01\/app\/oracle\/product\/19c\nPatch applicability verified successfully on home \/u01\/app\/oracle\/product\/19c\n\nExecuting patch validation checks on home \/u01\/app\/oracle\/product\/19c\nPatch validation checks successfully completed on home \/u01\/app\/oracle\/product\/19c\n\nVerifying SQL patch applicability on home \/u01\/app\/oracle\/product\/19c\nSQL patch applicability verified successfully on home \/u01\/app\/oracle\/product\/19c\n\nPreparing to bring down database service on home \/u01\/app\/oracle\/product\/19c\nSuccessfully prepared home \/u01\/app\/oracle\/product\/19c to bring down database service\n\nBringing down database service on home \/u01\/app\/oracle\/product\/19c\nFollowing database has been stopped and will be restarted later during the session: cdb\nDatabase service successfully brought down on home \/u01\/app\/oracle\/product\/19c\n\nStart applying binary patch on home \/u01\/app\/oracle\/product\/19c\nBinary patch applied successfully on home \/u01\/app\/oracle\/product\/19c\n\nStarting database service on home \/u01\/app\/oracle\/product\/19c\nDatabase service successfully started on home \/u01\/app\/oracle\/product\/19c\n\nPreparing home \/u01\/app\/oracle\/product\/19c after database service restarted\nNo step execution required.........\n\nTrying to apply SQL patch on home \/u01\/app\/oracle\/product\/19c\nSQL patch applied successfully on home \/u01\/app\/oracle\/product\/19c\n\nOPatchAuto successful.\n\n--------------------------------Summary--------------------------------\n\nPatching is completed successfully. Please find the summary as follows:\n\nHost:ocm199\nSIDB Home:\/u01\/app\/oracle\/product\/19c\nVersion:19.0.0.0.0\nSummary:\n\n==Following patches were SKIPPED:\n\nPatch: \/u01\/app\/oracle\/product\/stage\/19.10\/32226239\/32218663\nReason: This patch is not applicable to this specified target type - "oracle_database"\n\nPatch: \/u01\/app\/oracle\/product\/stage\/19.10\/32226239\/29340594\nReason: This patch is not applicable to this specified target type - "oracle_database"\n\nPatch: \/u01\/app\/oracle\/product\/stage\/19.10\/32226239\/32240590\nReason: This patch is not applicable to this specified target type - "oracle_database"\n\n==Following patches were SUCCESSFULLY applied:\n\nPatch: \/u01\/app\/oracle\/product\/stage\/19.10\/32226239\/32218454\nLog: \/u01\/app\/oracle\/product\/19c\/cfgtoollogs\/opatchauto\/core\/opatch\/opatch2021-03-02_03-55-16AM_1.log\n\nPatch: \/u01\/app\/oracle\/product\/stage\/19.10\/32226239\/32222571\nLog: \/u01\/app\/oracle\/product\/19c\/cfgtoollogs\/opatchauto\/core\/opatch\/opatch2021-03-02_03-55-16AM_1.log\n\nOPatchauto session completed at Tue Mar 2 04:05:51 2021\nTime taken to complete the session 12 minutes, 10 seconds\n[root@ocm199 19.10]#\n<\/pre>\nFrom the alert.log you can see that the dictionary scripts run against the CDB$ROOT and PDB$SEED automatically. All other PDB’s are excluded from this automation process.<\/p>\n
\n...\n...\nStarting ORACLE instance (normal) (OS id: 23607)\n2021-03-02T03:59:12.877637-05:00\n****************************************************\n Sys-V shared memory will be used for creating SGA\n ****************************************************\n2021-03-02T03:59:12.878078-05:00\n**********************************************************************\n2021-03-02T03:59:12.878115-05:00\nDump of system resources acquired for SHARED GLOBAL AREA (SGA)\n\n2021-03-02T03:59:12.878164-05:00\n Per process system memlock (soft) limit = UNLIMITED\n2021-03-02T03:59:12.878211-05:00\n Expected per process system memlock (soft) limit to lock\n instance MAX SHARED GLOBAL AREA (SGA) into memory: 3074M\n2021-03-02T03:59:12.878269-05:00\n Available system pagesizes:\n 4K, 2048K\n2021-03-02T03:59:12.878384-05:00\n Supported system pagesize(s):\n2021-03-02T03:59:12.878446-05:00\n PAGESIZE AVAILABLE_PAGES EXPECTED_PAGES ALLOCATED_PAGES ERROR(s)\n2021-03-02T03:59:12.878474-05:00\n 4K Configured 8 786440 NONE\n2021-03-02T03:59:12.878595-05:00\n 2048K 0 1537 0 NONE\n2021-03-02T03:59:12.878634-05:00\nRECOMMENDATION:\n2021-03-02T03:59:12.878665-05:00\n 1. For optimal performance, configure system with expected number\n of pages for every supported system pagesize prior to the next\n instance restart operation.\n2021-03-02T03:59:12.880799-05:00\n**********************************************************************\nLICENSE_MAX_SESSION = 0\nLICENSE_SESSIONS_WARNING = 0\nInitial number of CPU is 4\nNumber of processor cores in the system is 4\nNumber of processor sockets in the system is 1\nCapability Type : Network\ncapabilities requested : 7 detected : 0 Simulated : 0\nCapability Type : Runtime Environment\ncapabilities requested : 400000FF detected : 40000000 Simulated : 0\nCapability Type : Engineered Systems\ncapabilities requested : F detected : 0 Simulated : 0\nCapability Type : Database Test\ncapabilities requested : 3 detected : 0 Simulated : 0\nCapability Type : Database Editions\ncapabilities requested : C detected : 8 Simulated : 0\nUsing LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST\nAutotune of undo retention is turned on.\nIMODE=BR\nILAT =55\nLICENSE_MAX_USERS = 0\nSYS auditing is enabled\nNOTE: remote asm mode is local (mode 0x1; from cluster type)\nNOTE: Using default ASM root directory ASM\nNOTE: remote asm mode is local (mode 0x1; from cluster type)\nNOTE: Cluster configuration type = SIHA [3]\nOracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\nVersion 19.10.0.0.0.\nORACLE_HOME: \/u01\/app\/oracle\/product\/19c\nSystem name: Linux\nNode name: ocm199\nRelease: 4.18.0-240.10.1.el8_3.x86_64\nVersion: #1 SMP Mon Jan 18 17:05:51 UTC 2021\nMachine: x86_64\nUsing parameter settings in server-side spfile +DATA\/CDB\/PARAMETERFILE\/spfile.270.1054881393\nSystem parameters with non-default values:\n processes = 320\n nls_language = "AMERICAN"\n nls_territory = "AMERICA"\n sga_target = 3G\n control_files = "+DATA\/CDB\/CONTROLFILE\/current.261.1054880119"\n control_files = "+FRA\/CDB\/CONTROLFILE\/current.256.1054880119"\n control_file_record_keep_time= 144\n db_block_size = 8192\n compatible = "19.0.0"\n log_archive_format = "%t_%s_%r.dbf"\n db_create_file_dest = "+DATA"\n db_recovery_file_dest = "+FRA"\n db_recovery_file_dest_size= 12732M\n undo_tablespace = "UNDOTBS1"\n remote_login_passwordfile= "EXCLUSIVE"\n dispatchers = "(PROTOCOL=TCP) (SERVICE=CDBXDB)"\n local_listener = "LISTENER_CDB"\n audit_file_dest = "\/u01\/app\/oracle\/admin\/CDB\/adump"\n audit_trail = "DB"\n db_name = "CDB"\n open_cursors = 300\n pga_aggregate_target = 2G\n diagnostic_dest = "\/u01\/app\/oracle"\n enable_pluggable_database= TRUE\n2021-03-02T03:59:13.093221-05:00\n============================================================\nNOTE: PatchLevel of this instance 0\n============================================================\n2021-03-02T03:59:14.275231-05:00\nStarting background process PMON\n2021-03-02T03:59:14.282646-05:00\nPMON started with pid=2, OS id=23622\nStarting background process CLMN\n2021-03-02T03:59:14.290915-05:00\nCLMN started with pid=3, OS id=23626\nStarting background process PSP0\n2021-03-02T03:59:14.299010-05:00\nPSP0 started with pid=4, OS id=23630\nStarting background process VKTM\n2021-03-02T03:59:15.332574-05:00\nVKTM started with pid=5, OS id=23634 at elevated (RT) priority\n2021-03-02T03:59:15.332615-05:00\nStarting background process GEN0\n2021-03-02T03:59:15.333494-05:00\nVKTM running at (1)millisec precision with DBRM quantum (100)ms\n2021-03-02T03:59:15.339782-05:00\nGEN0 started with pid=6, OS id=23640\n...\n...\nStarting background process MMON\n2021-03-02T03:59:15.554759-05:00\nMMON started with pid=34, OS id=23718\nStarting background process MMNL\n2021-03-02T03:59:15.567505-05:00\nMMNL started with pid=35, OS id=23720\n2021-03-02T03:59:15.571143-05:00\nstarting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...\n2021-03-02T03:59:15.571323-05:00\nNOTE: ASMB (index:0) registering with ASM instance as Standard client 0xffffffffffffffff (reg:602057471) (startid:1066103953) (new connection)\nstarting up 1 shared server(s) ...\nStarting background process TMON\n2021-03-02T03:59:15.603334-05:00\nTMON started with pid=38, OS id=23728\nSetting CPU count to 4\nORACLE_BASE from environment = \/u01\/app\/oracle\n2021-03-02T03:59:15.628817-05:00\nNOTE: ASMB (index:0) (23710) connected to ASM instance +ASM, osid: 23722 (Standard mode; client id 0xffffffffffffffff)\nNOTE: initiating MARK startup\nStarting background process MARK\n2021-03-02T03:59:15.636542-05:00\nMARK started with pid=40, OS id=23732\n2021-03-02T03:59:15.637735-05:00\nNOTE: MARK has subscribed\n2021-03-02T03:59:15.653909-05:00\nALTER DATABASE MOUNT \/* db agent *\/\/* {0:0:344} *\/\n2021-03-02T03:59:18.398830-05:00\nUsing default pga_aggregate_limit of 4096 MB\n2021-03-02T03:59:18.755586-05:00\nNOTE: ASMB mounting group 1 (DATA)\nNOTE: Assigning number (1,0) to disk (\/dev\/oracleasm\/asmdisk01)\nNOTE: Assigning number (1,1) to disk (\/dev\/oracleasm\/asmdisk02)\nNOTE: Assigning number (1,2) to disk (\/dev\/oracleasm\/asmdisk03)\nSUCCESS: mounted group 1 (DATA)\nNOTE: grp 1 disk 0: DATA_0000 path:\/dev\/oracleasm\/asmdisk01\nNOTE: grp 1 disk 1: DATA_0001 path:\/dev\/oracleasm\/asmdisk02\nNOTE: grp 1 disk 2: DATA_0002 path:\/dev\/oracleasm\/asmdisk03\nNOTE: ASMB mounting group 2 (FRA)\n2021-03-02T03:59:18.851218-05:00\nNOTE: dependency between database CDB and diskgroup resource ora.DATA.dg is established\n2021-03-02T03:59:18.857326-05:00\nNOTE: Assigning number (2,0) to disk (\/dev\/oracleasm\/asmdisk04)\nNOTE: Assigning number (2,1) to disk (\/dev\/oracleasm\/asmdisk05)\nNOTE: Assigning number (2,2) to disk (\/dev\/oracleasm\/asmdisk06)\nNOTE: Assigning number (2,3) to disk (\/dev\/oracleasm\/asmdisk07)\nSUCCESS: mounted group 2 (FRA)\nNOTE: grp 2 disk 0: FRA_0000 path:\/dev\/oracleasm\/asmdisk04\nNOTE: grp 2 disk 1: FRA_0001 path:\/dev\/oracleasm\/asmdisk05\nNOTE: grp 2 disk 2: FRA_0002 path:\/dev\/oracleasm\/asmdisk06\nNOTE: grp 2 disk 3: FRA_0003 path:\/dev\/oracleasm\/asmdisk07\n2021-03-02T03:59:18.879311-05:00\nNOTE: dependency between database CDB and diskgroup resource ora.FRA.dg is established\n2021-03-02T03:59:23.038061-05:00\n.... (PID:23730): Redo network throttle feature is disabled at mount time\n2021-03-02T03:59:23.106351-05:00\nSuccessful mount of redo thread 1, with mount id 2182720275\n2021-03-02T03:59:23.110361-05:00\nDatabase mounted in Exclusive Mode\nLost write protection disabled\n.... (PID:23730): Using STANDBY_ARCHIVE_DEST parameter default value as USE_DB_RECOVERY_FILE_DEST [krsd.c:18158]\nCompleted: ALTER DATABASE MOUNT \/* db agent *\/\/* {0:0:344} *\/\nALTER DATABASE OPEN \/* db agent *\/\/* {0:0:344} *\/\nPing without log force is disabled:\n instance mounted in exclusive mode.\n2021-03-02T03:59:23.492696-05:00\nCrash Recovery excluding pdb 2 which was cleanly closed.\n2021-03-02T03:59:23.492802-05:00\nCrash Recovery excluding pdb 3 which was cleanly closed.\nEndian type of dictionary set to little\n2021-03-02T03:59:23.544072-05:00\nTT00 (PID:23752): Gap Manager starting\n2021-03-02T03:59:23.550639-05:00\nTMON (PID:23728): STARTING ARCH PROCESSES\nStarting background process ARC0\n2021-03-02T03:59:23.556960-05:00\nARC0 started with pid=47, OS id=23756\nStarting background process ARC1\n2021-03-02T03:59:23.563197-05:00\nARC1 started with pid=48, OS id=23758\nStarting background process ARC2\n2021-03-02T03:59:23.569188-05:00\nARC2 started with pid=49, OS id=23760\nStarting background process ARC3\n2021-03-02T03:59:23.575332-05:00\nARC3 started with pid=50, OS id=23762\nTMON (PID:23728): ARC0: Archival started\nTMON (PID:23728): ARC1: Archival started\nTMON (PID:23728): ARC2: Archival started\n2021-03-02T03:59:23.575594-05:00\nARC0 (PID:23756): Becoming a 'no FAL' ARCH\nARC0 (PID:23756): Becoming the 'no SRL' ARCH\n2021-03-02T03:59:23.585630-05:00\nTMON (PID:23728): ARC3: Archival started\nTMON (PID:23728): STARTING ARCH PROCESSES COMPLETE\n2021-03-02T03:59:23.602466-05:00\nRedo log for group 1, sequence 31 is not located on DAX storage\nThread 1 opened at log sequence 31\n Current log# 1 seq# 31 mem# 0: +DATA\/CDB\/ONLINELOG\/group_1.263.1054880121\n Current log# 1 seq# 31 mem# 1: +FRA\/CDB\/ONLINELOG\/group_1.259.1054880135\nSuccessful open of redo thread 1\n2021-03-02T03:59:23.614852-05:00\nMTTR advisory is disabled because FAST_START_MTTR_TARGET is not set\nStopping change tracking\n2021-03-02T03:59:25.738279-05:00\nUndo initialization recovery: Parallel FPTR complete: start:4799362 end:4799377 diff:15 ms (0.0 seconds)\nUndo initialization recovery: err:0 start: 4799352 end: 4799377 diff: 25 ms (0.0 seconds)\n[23730] Successfully onlined Undo Tablespace 2.\nUndo initialization online undo segments: err:0 start: 4799377 end: 4800236 diff: 859 ms (0.9 seconds)\nUndo initialization finished serial:0 start:4799352 end:4800255 diff:903 ms (0.9 seconds)\nVerifying minimum file header compatibility for tablespace encryption for pdb 1..\nVerifying file header compatibility for tablespace encryption completed for pdb 1\nDatabase Characterset is AL32UTF8\n2021-03-02T03:59:27.079477-05:00\nNo Resource Manager plan active\n2021-03-02T03:59:29.605186-05:00\njoxcsys_required_dirobj_exists: directory object exists with required path \/u01\/app\/oracle\/product\/19c\/javavm\/admin\/, pid 23730 cid 1\nreplication_dependency_tracking turned off (no async multimaster replication found)\n2021-03-02T03:59:31.399959-05:00\nStarting background process AQPC\n2021-03-02T03:59:31.406043-05:00\nAQPC started with pid=54, OS id=23774\nPDB$SEED(2):Autotune of undo retention is turned on.\n2021-03-02T03:59:32.059670-05:00\nPDB$SEED(2):Endian type of dictionary set to little\nPDB$SEED(2):Undo initialization finished serial:0 start:4805960 end:4805960 diff:0 ms (0.0 seconds)\n2021-03-02T03:59:32.541459-05:00\nPDB$SEED(2):Database Characterset for PDB$SEED is AL32UTF8\n2021-03-02T03:59:35.855992-05:00\nPDB$SEED(2):Opening pdb with no Resource Manager plan active\n2021-03-02T03:59:36.002336-05:00\nQPI: opatch file present, opatch\nQPI: qopiprep.bat file present\n2021-03-02T03:59:37.330985-05:00\nStarting background process CJQ0\n2021-03-02T03:59:37.341372-05:00\nCJQ0 started with pid=65, OS id=23798\nCompleted: ALTER DATABASE OPEN \/* db agent *\/\/* {0:0:344} *\/\n2021-03-02T03:59:40.263766-05:00\nalter pluggable database "PDB$SEED" close immediate force instances=('CDB')\n2021-03-02T03:59:40.296724-05:00\nPDB$SEED(2):JIT: pid 24232 requesting stop\nPDB$SEED(2):Buffer Cache flush started: 2\nPDB$SEED(2):Buffer Cache flush finished: 2\nPluggable database PDB$SEED closed\n2021-03-02T03:59:41.609292-05:00\n===========================================================\nDumping current patch information\n===========================================================\nPatch Id: 32218454\nPatch Description: Database Release Update : 19.10.0.0.210119 (32218454)\nPatch Apply Time: 2021-03-02T03:56:47-05:00\nBugs Fixed: 7391838,8460502,8476681,14735102,16664572,17428816,17468475,\n19080742,19138896,19697993,20313356,20867658,21232786,21374587,21528318,\n21629064,21639146,21888352,21965541,22580355,22729345,22748979,23294761,\n23296836,23606241,23645975,23734075,23763462,24596874,24669730,24687075,\n24833686,24957575,24971456,25030027,25092651,25093917,25404117,25416731,\n25560538,25607406,25756945,25792962,25804387,25806201,25809128,25883179,\n25905368,25986062,25997810,26001677,26127355,26173091,26284288,26352615,\n26440142,26476244,26499997,26611353,26668264,26739322,26777814,26819036,\n26872233,27004828,27036163,27044169,27101798,27126122,27126938,27130348,\n...\n...\n32101305,32113113,32118727,32121326,32129659,32130083,32130504,32150818,\n32169151,32172777,32174571,32207088,32212635,32221141,32234161,32290399,\n32296941,32321765\n\nPatch Id: 32222571\nPatch Description: OCW Interim patch for 32222571\nPatch Apply Time: 2021-03-02T03:58:54-05:00\nBugs Fixed: 3,17787434,25736599,26305045,26675491,26813848,27092095,27148384,\n27222128,27262781,27505699,27526265,27572040,27604329,27663388,27760043,\n27877830,27935374,28302439,28302580,28319989,28336118,28344129,28406406,\n...\n...\n29154631,29154636,29154829,29159216,29159661,29160462,29161923,29169540,\n29169739,29170717,29173618,29178563,29181568,29182920,29183298,29186091,\n29191827,29201143,29201695,29202442,29203691,29209545,29209972,29210577,\n29210610,29210624,29210683,29213641,29214935,29218185,29219627,29224294,\n2021-03-02T03:59:41.630143-05:00\nCompleted: alter pluggable database "PDB$SEED" close immediate force instances=('CDB')\n29225861,29229839,29231008,29235934,29242906,29243749,29244495,29244766,\n29244968,29248723,29249583,29251564,29254863,29255616,29256021,29257308,\n29260224,29261171,29261695,29266584,29268887,29271019,29273360,29273690,\n29274911,29275362,29276220,29280752,29282090,29282666,29283505,29285453,\n29285621,29288842,29289634,29290235,29292232,29293806,29293928,29294753,\n29299830,29307090,29307109,29311336,29311884,29318127,29321965,29326865,\n29329675,29330791,29338139,29339299,29340414,29342966,29347106,29351297,\n29351881,29357821,29359713,29360467,29360775,29367971,29368725,29372221,\n...\n...\n31742512,31748711,31751387,31752814,31752990,31753874,31756012,31765043,\n31772216,31775359,31775363,31777242,31778138,31779513,31794046,31795055,\n31825446,31825584,31835699,31837685,31837842,31837923,31839233,31848063,\n31849609,31856488,31857840,31864173,31887422,31900921,31901236,31935022,\n31943944,31987354,31992593,32069815,32137544,32178524\n===========================================================\n2021-03-02T03:59:42.378872-05:00\nalter pluggable database "PDB$SEED" open READ WRITE services=NONE\nPDB$SEED(2):Autotune of undo retention is turned on.\n2021-03-02T03:59:42.814536-05:00\nPDB$SEED(2):Endian type of dictionary set to little\nPDB$SEED(2):Undo initialization recovery: Parallel FPTR complete: start:4816793 end:4816828 diff:35 ms (0.0 seconds)\nPDB$SEED(2):Undo initialization recovery: err:0 start: 4816786 end: 4816828 diff: 42 ms (0.0 seconds)\n2021-03-02T03:59:43.914061-05:00\nPDB$SEED(2):[24261] Successfully onlined Undo Tablespace 2.\nPDB$SEED(2):Undo initialization online undo segments: err:0 start: 4816828 end: 4817555 diff: 727 ms (0.7 seconds)\nPDB$SEED(2):Undo initialization finished serial:0 start:4816786 end:4817583 diff:797 ms (0.8 seconds)\nPDB$SEED(2):Database Characterset for PDB$SEED is AL32UTF8\n2021-03-02T03:59:46.987155-05:00\nPDB$SEED(2):Opening pdb with no Resource Manager plan active\nPDB$SEED(2):joxcsys_required_dirobj_exists: directory object exists with required path \/u01\/app\/oracle\/product\/19c\/javavm\/admin\/, pid 24261 cid 2\n2021-03-02T03:59:48.307188-05:00\nPluggable database PDB$SEED opened read write\nCompleted: alter pluggable database "PDB$SEED" open READ WRITE services=NONE\n2021-03-02T03:59:52.433649-05:00\nQPI: opatch file present, opatch\nQPI: qopiprep.bat file present\n2021-03-02T04:00:05.639682-05:00\n\nXDB installed.\n\nXDB initialized.\n2021-03-02T04:00:07.105682-05:00\nResize operation completed for file# 201, old size 50176K, new size 51200K\nResize operation completed for file# 201, old size 51200K, new size 52224K\nResize operation completed for file# 201, old size 52224K, new size 53248K\nResize operation completed for file# 201, old size 53248K, new size 54272K\nResize operation completed for file# 201, old size 54272K, new size 55296K\nResize operation completed for file# 1, old size 993280K, new size 1003520K\n2021-03-02T04:00:08.485323-05:00\nResize operation completed for file# 1, old size 1003520K, new size 1013760K\nResize operation completed for file# 1, old size 1013760K, new size 1024000K\n2021-03-02T04:00:09.532655-05:00\nPL\/SQL package SYS.DBMS_BACKUP_RESTORE version is not current\n2021-03-02T04:00:10.502747-05:00\nResize operation completed for file# 1, old size 1024000K, new size 1034240K\n2021-03-02T04:00:11.217719-05:00\nPL\/SQL package SYS.DBMS_RCVMAN version 19.09.00.00 is too old\n2021-03-02T04:00:12.035839-05:00\nResize operation completed for file# 201, old size 55296K, new size 56320K\n2021-03-02T04:00:12.736045-05:00\nResize operation completed for file# 201, old size 56320K, new size 57344K\n2021-03-02T04:00:12.748278-05:00\nResize operation completed for file# 1, old size 1034240K, new size 1044480K\n2021-03-02T04:00:12.808727-05:00\ndb_recovery_file_dest_size of 12732 MB is 31.47% used. This is a\nuser-specified limit on the amount of space that will be used by this\ndatabase for recovery-related files, and does not reflect the amount of\nspace available in the underlying filesystem or ASM diskgroup.\n2021-03-02T04:00:13.227171-05:00\nResize operation completed for file# 201, old size 57344K, new size 58368K\n2021-03-02T04:00:14.201895-05:00\nResize operation completed for file# 1, old size 1044480K, new size 1054720K\n2021-03-02T04:00:18.896878-05:00\nPDB$SEED(2):\nPDB$SEED(2):XDB installed.\nPDB$SEED(2):\nPDB$SEED(2):XDB initialized.\n2021-03-02T04:00:21.152316-05:00\nPDB$SEED(2):Resize operation completed for file# 202, old size 50176K, new size 51200K\nPDB$SEED(2):Resize operation completed for file# 202, old size 51200K, new size 52224K\nPDB$SEED(2):Resize operation completed for file# 202, old size 52224K, new size 53248K\nPDB$SEED(2):Resize operation completed for file# 202, old size 53248K, new size 54272K\nPDB$SEED(2):Resize operation completed for file# 202, old size 54272K, new size 55296K\nPDB$SEED(2):Resize operation completed for file# 5, old size 317440K, new size 327680K\n2021-03-02T04:00:22.410727-05:00\nPDB$SEED(2):Resize operation completed for file# 5, old size 327680K, new size 337920K\nPDB$SEED(2):Resize operation completed for file# 5, old size 337920K, new size 348160K\n2021-03-02T04:00:23.650667-05:00\nPDB$SEED(2):Resize operation completed for file# 5, old size 348160K, new size 358400K\nPDB$SEED(2):Resize operation completed for file# 5, old size 358400K, new size 368640K\nPDB$SEED(2):Resize operation completed for file# 5, old size 368640K, new size 378880K\n2021-03-02T04:00:25.342960-05:00\nThread 1 cannot allocate new log, sequence 32\nPrivate strand flush not complete\n Current log# 1 seq# 31 mem# 0: +DATA\/CDB\/ONLINELOG\/group_1.263.1054880121\n Current log# 1 seq# 31 mem# 1: +FRA\/CDB\/ONLINELOG\/group_1.259.1054880135\n2021-03-02T04:00:28.436170-05:00\nThread 1 advanced to log sequence 32 (LGWR switch), current SCN: 4202114\n Current log# 2 seq# 32 mem# 0: +DATA\/CDB\/ONLINELOG\/group_2.262.1054880121\n Current log# 2 seq# 32 mem# 1: +FRA\/CDB\/ONLINELOG\/group_2.257.1054880135\n2021-03-02T04:00:28.659253-05:00\nALTER SESSION DISABLE LOGICAL REPLICATION invoked from session 18.14773 at SCN 0x00007ffc9404b880\n\nXDB initialized.\n2021-03-02T04:00:31.380727-05:00\nARC1 (PID:23758): Archived Log entry 21 added for T-1.S-31 ID 0x816e34f6 LAD:1\n2021-03-02T04:02:42.376084-05:00\nALTER SESSION ENABLE LOGICAL REPLICATION invoked from session 18.14773 at SCN 0x00007ffc9404b88c\nSERVER ACTION=RU_APPLY id=: Patch applied from 19.9.0.0.0 to 19.10.0.0.0: Release_Update - 210108185017 Container=CDB$ROOT Id=1\n2021-03-02T04:02:53.378228-05:00\nTABLE SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY: ADDED INTERVAL PARTITION SYS_P353 (44256) VALUES LESS THAN (TO_DATE(' 2021-03-03 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))\nTABLE SYS.WRI$_OPTSTAT_HISTGRM_HISTORY: ADDED INTERVAL PARTITION SYS_P356 (44256) VALUES LESS THAN (TO_DATE(' 2021-03-03 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))\n2021-03-02T04:03:17.214029-05:00\nPDB$SEED(2):TABLE AUDSYS.AUD$UNIFIED: ADDED INTERVAL PARTITION SYS_P248 (81) VALUES LESS THAN (TIMESTAMP' 2021-04-01 00:00:00')\n2021-03-02T04:03:18.826819-05:00\nPDB$SEED(2):ALTER SESSION DISABLE LOGICAL REPLICATION invoked from session 18.14773 at SCN 0x00007ffc9404b880\nPDB$SEED(2):\nPDB$SEED(2):XDB initialized.\n2021-03-02T04:03:23.114903-05:00\nTABLE SYS.WRP$_REPORTS: ADDED INTERVAL PARTITION SYS_P357 (4079) VALUES LESS THAN (TO_DATE(' 2021-03-03 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))\nTABLE SYS.WRP$_REPORTS_DETAILS: ADDED INTERVAL PARTITION SYS_P358 (4079) VALUES LESS THAN (TO_DATE(' 2021-03-03 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))\nTABLE SYS.WRP$_REPORTS_TIME_BANDS: ADDED INTERVAL PARTITION SYS_P361 (4078) VALUES LESS THAN (TO_DATE(' 2021-03-02 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))\n2021-03-02T04:04:37.763092-05:00\nPDB$SEED(2):Resize operation completed for file# 6, old size 389120K, new size 399360K\n2021-03-02T04:04:38.252197-05:00\nPDB$SEED(2):Resize operation completed for file# 6, old size 399360K, new size 409600K\n2021-03-02T04:04:54.162608-05:00\nThread 1 advanced to log sequence 33 (LGWR switch), current SCN: 4268486\n Current log# 3 seq# 33 mem# 0: +DATA\/CDB\/ONLINELOG\/group_3.264.1054880121\n Current log# 3 seq# 33 mem# 1: +FRA\/CDB\/ONLINELOG\/group_3.258.1054880135\n2021-03-02T04:04:56.697903-05:00\nARC2 (PID:23760): Archived Log entry 22 added for T-1.S-32 ID 0x816e34f6 LAD:1\n2021-03-02T04:04:57.218593-05:00\nPDB$SEED(2):ALTER SESSION ENABLE LOGICAL REPLICATION invoked from session 18.14773 at SCN 0x00007ffc9404b88c\nPDB$SEED(2):SERVER ACTION=RU_APPLY id=: Patch applied from 19.9.0.0.0 to 19.10.0.0.0: Release_Update - 210108185017 Container=PDB$SEED Id=2\n2021-03-02T04:05:04.249820-05:00\nPDB$SEED(2):TABLE SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY: ADDED INTERVAL PARTITION SYS_P268 (44256) VALUES LESS THAN (TO_DATE(' 2021-03-03 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))\nPDB$SEED(2):TABLE SYS.WRI$_OPTSTAT_HISTGRM_HISTORY: ADDED INTERVAL PARTITION SYS_P271 (44256) VALUES LESS THAN (TO_DATE(' 2021-03-03 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))\n2021-03-02T04:05:04.809327-05:00\nPDB$SEED(2):Resize operation completed for file# 202, old size 55296K, new size 56320K\n2021-03-02T04:05:43.603419-05:00\nalter pluggable database "PDB$SEED" close immediate force instances=('CDB')\n2021-03-02T04:05:43.801142-05:00\nPDB$SEED(2):JIT: pid 24863 requesting stop\nPDB$SEED(2):Closing sequence subsystem (5177673387).\nPDB$SEED(2):Buffer Cache flush started: 2\n2021-03-02T04:05:45.988537-05:00\nPDB$SEED(2):Buffer Cache flush finished: 2\nPluggable database PDB$SEED closed\nCompleted: alter pluggable database "PDB$SEED" close immediate force instances=('CDB')\n2021-03-02T04:05:46.329905-05:00\nalter pluggable database "PDB$SEED" open READ ONLY instances=('CDB')\nPDB$SEED(2):Autotune of undo retention is turned on.\nPDB$SEED(2):Endian type of dictionary set to little\nPDB$SEED(2):Undo initialization finished serial:0 start:5180917 end:5180917 diff:0 ms (0.0 seconds)\n2021-03-02T04:05:47.367938-05:00\nPDB$SEED(2):Database Characterset for PDB$SEED is AL32UTF8\n2021-03-02T04:05:50.495150-05:00\nPDB$SEED(2):Opening pdb with no Resource Manager plan active\nPluggable database PDB$SEED opened read only\nCompleted: alter pluggable database "PDB$SEED" open READ ONLY instances=('CDB')\n...\n...\n<\/pre>\nRun some dictionary scripts (datapatch -verbose)<\/h3>\n
The final step is to run the datapatch utility against all other PDB’s which were not patched automatically.<\/p>\n
\n[oracle@ocm199 ~]$ sq\n\nSQL*Plus: Release 19.0.0.0.0 - Production on Tue Mar 2 04:10:01 2021\nVersion 19.10.0.0.0\n\nCopyright (c) 1982, 2020, Oracle. All rights reserved.\n\nConnected to:\nOracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\nVersion 19.10.0.0.0\n\nSQL> show pdbs\n\n CON_ID CON_NAME OPEN MODE RESTRICTED\n---------- ------------------------------ ---------- ----------\n 2 PDB$SEED READ ONLY NO\n 3 PDB01 MOUNTED\nSQL>\nSQL> alter pluggable database all open;\n\nWarning: PDB altered with errors.\n\nSQL>\n\n[oracle@ocm199 OPatch]$ .\/datapatch -verbose\nSQL Patching tool version 19.10.0.0.0 Production on Tue Mar 2 04:11:29 2021\nCopyright (c) 2012, 2020, Oracle. All rights reserved.\n\nLog file for this invocation: \/u01\/app\/oracle\/cfgtoollogs\/sqlpatch\/sqlpatch_25085_2021_03_02_04_11_29\/sqlpatch_invocation.log\n\nConnecting to database...OK\nGathering database info...done\n\nNote: Datapatch will only apply or rollback SQL fixes for PDBs\n that are in an open state, no patches will be applied to closed PDBs.\n Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation\n (Doc ID 1585822.1)\n\nBootstrapping registry and package to current versions...done\nDetermining current state...done\n\nCurrent state of interim SQL patches:\n No interim patches found\n\nCurrent state of release update SQL patches:\n Binary registry:\n 19.10.0.0.0 Release_Update 210108185017: Installed\n PDB CDB$ROOT:\n Applied 19.10.0.0.0 Release_Update 210108185017 successfully on 02-MAR-21 04.05.43.096925 AM\n PDB PDB$SEED:\n Applied 19.10.0.0.0 Release_Update 210108185017 successfully on 02-MAR-21 04.05.43.534134 AM\n PDB PDB01:\n Applied 19.9.0.0.0 Release_Update 200930183249 successfully on 27-OCT-20 06.35.34.562450 AM\n\nAdding patches to installation queue and performing prereq checks...done\nInstallation queue:\n For the following PDBs: CDB$ROOT PDB$SEED\n No interim patches need to be rolled back\n No release update patches need to be installed\n No interim patches need to be applied\n For the following PDBs: PDB01\n No interim patches need to be rolled back\n Patch 32218454 (Database Release Update : 19.10.0.0.210119 (32218454)):\n Apply from 19.9.0.0.0 Release_Update 200930183249 to 19.10.0.0.0 Release_Update 210108185017\n No interim patches need to be applied\n\nInstalling patches...\nPatch installation complete. Total patches installed: 1\n\nValidating logfiles...done\nPatch 32218454 apply (pdb PDB01): SUCCESS\n logfile: \/u01\/app\/oracle\/cfgtoollogs\/sqlpatch\/32218454\/24018797\/32218454_apply_CDB_PDB01_2021Mar02_04_11_59.log (no errors)\nSQL Patching tool complete on Tue Mar 2 04:14:09 2021\n[oracle@ocm199 OPatch]$\n\n[oracle@ocm199 OPatch]$ sq\n\nSQL*Plus: Release 19.0.0.0.0 - Production on Tue Mar 2 04:24:06 2021\nVersion 19.10.0.0.0\n\nCopyright (c) 1982, 2020, Oracle. All rights reserved.\n\nConnected to:\nOracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\nVersion 19.10.0.0.0\n\nSQL> show pdbs\n\n CON_ID CON_NAME OPEN MODE RESTRICTED\n---------- ------------------------------ ---------- ----------\n 2 PDB$SEED READ ONLY NO\n 3 PDB01 READ WRITE YES\n\n<\/pre>\nThe upgrade process has finish and everything is up and running again. As a last step, we can check the patchlevel in each home.<\/p>\n
\n\n[oracle@ocm199 ~]$ . GRID\n[oracle@ocm199 ~]$\n[oracle@ocm199 ~]$ opatch lsinv\nOracle Interim Patch Installer version 12.2.0.1.24\nCopyright (c) 2021, Oracle Corporation. All rights reserved.\n\nOracle Home : \/u01\/grid\/19c\nCentral Inventory : \/u01\/app\/oraInventory\n from : \/u01\/grid\/19c\/oraInst.loc\nOPatch version : 12.2.0.1.24\nOUI version : 12.2.0.7.0\nLog file location : \/u01\/grid\/19c\/cfgtoollogs\/opatch\/opatch2021-03-02_09-14-11AM_1.log\n\nLsinventory Output file location : \/u01\/grid\/19c\/cfgtoollogs\/opatch\/lsinv\/lsinventory2021-03-02_09-14-11AM.txt\n--------------------------------------------------------------------------------\nLocal Machine Information::\nHostname: ocm199\nARU platform id: 226\nARU platform description:: Linux x86-64\n\nInstalled Top-level Products (1):\n\nOracle Grid Infrastructure 19c 19.0.0.0.0\nThere are 1 products installed in this Oracle Home.\n\nInterim patches (5) :\n\nPatch 32240590 : applied on Tue Mar 02 03:42:23 EST 2021\nUnique Patch ID: 23955141\nPatch description: "TOMCAT RELEASE UPDATE 19.0.0.0.0 (32240590)"\n Created on 7 Jan 2021, 22:55:01 hrs PST8PDT\n Bugs fixed:\n 30729044, 30009095, 29286300, 31657943, 32107716, 30997459\n\nPatch 32222571 : applied on Tue Mar 02 03:41:20 EST 2021\nUnique Patch ID: 24017129\nPatch description: "OCW Interim patch for 32222571"\n Created on 15 Jan 2021, 01:49:46 hrs PST8PDT\n Bugs fixed:\n 17787434, 25736599, 26305045, 26675491, 26813848, 27092095, 27148384\n 27222128, 27262781, 27505699, 27526265, 27572040, 27604329, 27663388\n 27760043, 27877830, 27935374, 28302439, 28302580, 28319989, 28336118\n 28344129, 28406406, 28441307, 28462255, 28470673, 28554809, 28567875\n 28621543, 28628631, 28642469, 28677941, 28697242, 28697896, 28699321\n 28704073, 28710663, 28723237, 28747089, 28755846, 28762163, 28772816\n 28785321, 28790623, 28800508, 28805158, 28805475, 28808652, 28814106\n 28815557, 28834364, 28834743, 28847541, 28847572, 28847655, 28852065\n 28865162, 28870111, 28870496, 28871040, 28874416, 28874529, 28874678\n 28877252, 28881191, 28881848, 28887675, 28887933, 28888083, 28892095\n...\n...\n\nPatch 32218663 : applied on Tue Mar 02 03:40:02 EST 2021\nUnique Patch ID: 23983106\nPatch description: "ACFS RELEASE UPDATE 19.10.0.0.0 (32218663)"\n Created on 22 Dec 2020, 12:20:04 hrs PST8PDT\n Bugs fixed:\n 27494830, 27917085, 28064731, 28293236, 28321248, 28375150, 28531803\n 28553487, 28611527, 28649123, 28687713, 28701011, 28740425, 28818513\n 28825772, 28837603, 28844788, 28855761, 28860451, 28900212, 28951588\n 28960047, 28961428, 28995524, 29001307, 29020252, 29030106, 29031452\n 29039918, 29115917, 29116692, 29127489, 29127491, 29167352, 29173957\n 29198743, 29229120, 29234059, 29250565, 29264772, 29302070, 29313039\n...\n...\nPatch 32218454 : applied on Tue Mar 02 03:37:10 EST 2021\nUnique Patch ID: 24018797\nPatch description: "Database Release Update : 19.10.0.0.210119 (32218454)"\n Created on 14 Jan 2021, 16:24:38 hrs UTC\n Bugs fixed:\n 31625618, 32321765, 7391838, 8460502, 8476681, 14735102, 16664572\n 17428816, 17468475, 19080742, 19138896, 19697993, 20313356, 20867658\n 21232786, 21374587, 21528318, 21629064, 21639146, 21888352, 21965541\n 22580355, 22729345, 22748979, 23294761, 23296836, 23606241, 23645975\n 23734075, 23763462, 24596874, 24669730, 24687075, 24833686, 24957575\n 24971456, 25030027, 25092651, 25093917, 25404117, 25416731, 25560538\n 25607406, 25756945, 25792962, 25804387, 25806201, 25809128, 25883179\n 25905368, 25986062, 25997810, 26001677, 26127355, 26173091, 26284288\n 26352615, 26440142, 26476244, 26499997, 26611353, 26668264, 26739322\n 26777814, 26819036, 26872233, 27004828, 27036163, 27044169, 27101798\n 27126122, 27126938, 27130348, 27166935, 27195575, 27195935, 27221350\n 27244999, 27254335, 27260704, 27261477, 27359766, 27362994, 27369515\n 27378053, 27392968, 27406105, 27411022, 27423500, 27439716, 27453490\n 27458357, 27489107, 27582210, 27589260, 27622946, 27629928, 27661222\n 27666312, 27684864, 27692173, 27700413, 27710072, 27729678, 27742354\n 27745728, 27801144, 27828892, 27829722, 27846298, 27873364, 27880025\n 27929509, 27934711, 27935464, 27941110, 27957203, 27967484, 27998559\n 28007516, 28064977, 28072567, 28078186, 28092783, 28104176, 28109326\n 28125947, 28127569, 28129791, 28133903, 28138847, 28144569, 28145995\n 28181021, 28187837, 28189466, 28204262, 28205555, 28209985, 28210681\n 28263142, 28271258, 28271693, 28276054, 28279456, 28294563, 28313275\n 28319114, 28322973, 28326928, 28338211, 28350595, 28370061, 28371123\n 28373960, 28375383, 28379065, 28381939, 28386259, 28390273, 28395302\n 28397317, 28402823, 28403019, 28406374, 28410431, 28431445, 28435333\n 28436414, 28442896, 28454215, 28463226, 28475242, 28482048, 28484299\n 28489419, 28492006, 28498976, 28502773, 28504631, 28513333, 28521330\n 28530171, 28534475, 28535127, 28537481, 28538439, 28541606, 28542455\n 28546290, 28547068, 28547926, 28558645, 28561704, 28564479, 28565296\n...\n...\n\nPatch 29340594 : applied on Tue Mar 02 03:35:19 EST 2021\nUnique Patch ID: 24005319\nPatch description: "DBWLM RELEASE UPDATE 19.0.0.0.0 (29340594)"\n Created on 8 Jan 2021, 01:44:40 hrs PST8PDT\n Bugs fixed:\n 31862202, 31554751, 31547458\n\n--------------------------------------------------------------------------------\n\nOPatch succeeded.\n[oracle@ocm199 ~]$\n\n[oracle@ocm199 ~]$ . CDB\n[oracle@ocm199 ~]$ opatch lsinv\nOracle Interim Patch Installer version 12.2.0.1.24\nCopyright (c) 2021, Oracle Corporation. All rights reserved.\n\nOracle Home : \/u01\/app\/oracle\/product\/19c\nCentral Inventory : \/u01\/app\/oraInventory\n from : \/u01\/app\/oracle\/product\/19c\/oraInst.loc\nOPatch version : 12.2.0.1.24\nOUI version : 12.2.0.7.0\nLog file location : \/u01\/app\/oracle\/product\/19c\/cfgtoollogs\/opatch\/opatch2021-03-02_09-14-44AM_1.log\n\nLsinventory Output file location : \/u01\/app\/oracle\/product\/19c\/cfgtoollogs\/opatch\/lsinv\/lsinventory2021-03-02_09-14-44AM.txt\n--------------------------------------------------------------------------------\nLocal Machine Information::\nHostname: ocm199\nARU platform id: 226\nARU platform description:: Linux x86-64\n\nInstalled Top-level Products (1):\n\nOracle Database 19c 19.0.0.0.0\nThere are 1 products installed in this Oracle Home.\n\nInterim patches (2) :\n\nPatch 32222571 : applied on Tue Mar 02 03:58:54 EST 2021\nUnique Patch ID: 24017129\nPatch description: "OCW Interim patch for 32222571"\n Created on 15 Jan 2021, 01:49:46 hrs PST8PDT\n Bugs fixed:\n 17787434, 25736599, 26305045, 26675491, 26813848, 27092095, 27148384\n 27222128, 27262781, 27505699, 27526265, 27572040, 27604329, 27663388\n 27760043, 27877830, 27935374, 28302439, 28302580, 28319989, 28336118\n 28344129, 28406406, 28441307, 28462255, 28470673, 28554809, 28567875\n 28621543, 28628631, 28642469, 28677941, 28697242, 28697896, 28699321\n 28704073, 28710663, 28723237, 28747089, 28755846, 28762163, 28772816\n 28785321, 28790623, 28800508, 28805158, 28805475, 28808652, 28814106\n 28815557, 28834364, 28834743, 28847541, 28847572, 28847655, 28852065\n 28865162, 28870111, 28870496, 28871040, 28874416, 28874529, 28874678\n 28877252, 28881191, 28881848, 28887675, 28887933, 28888083, 28892095\n 28897229, 28911140, 28912188, 28917537, 28925250, 28925460, 28935956\n 28940472, 28942694, 28951332, 28958624, 28961306, 28963036, 28968779\n 28973989, 28979734, 28980448, 28984430, 28987100, 28993689, 28995287\n 29003207, 29003617, 29016294, 29018680, 29024876, 29026154, 29027933\n 29030056, 29040641, 29047127, 29050804, 29051269, 29052850, 29053083\n 29058476, 29062169, 29111631, 29112455, 29112898, 29117337, 29117435\n 29118754, 29123444, 29125708, 29125786, 29129476, 29130169, 29130654\n 29131772, 29132456, 29139727, 29146157, 29147849, 29149170, 29152603\n 29152752, 29154631, 29154636, 29154829, 29159216, 29159661, 29160462\n 29161923, 29169540, 29169739, 29170717, 29173618, 29178563, 29181568\n 29182920, 29183298, 29186091, 29191827, 29201143, 29201695, 29202442\n 29203691, 29209545, 29209972, 29210577, 29210610, 29210624, 29210683\n 29213641, 29214935, 29218185, 29219627, 29224294, 29225861, 29229839\n...\n...\n\nPatch 32218454 : applied on Tue Mar 02 03:56:47 EST 2021\nUnique Patch ID: 24018797\nPatch description: "Database Release Update : 19.10.0.0.210119 (32218454)"\n Created on 14 Jan 2021, 16:24:38 hrs UTC\n Bugs fixed:\n 31625618, 32321765, 7391838, 8460502, 8476681, 14735102, 16664572\n 17428816, 17468475, 19080742, 19138896, 19697993, 20313356, 20867658\n 21232786, 21374587, 21528318, 21629064, 21639146, 21888352, 21965541\n 22580355, 22729345, 22748979, 23294761, 23296836, 23606241, 23645975\n 23734075, 23763462, 24596874, 24669730, 24687075, 24833686, 24957575\n 24971456, 25030027, 25092651, 25093917, 25404117, 25416731, 25560538\n 25607406, 25756945, 25792962, 25804387, 25806201, 25809128, 25883179\n 25905368, 25986062, 25997810, 26001677, 26127355, 26173091, 26284288\n 26352615, 26440142, 26476244, 26499997, 26611353, 26668264, 26739322\n 26777814, 26819036, 26872233, 27004828, 27036163, 27044169, 27101798\n 27126122, 27126938, 27130348, 27166935, 27195575, 27195935, 27221350\n 27244999, 27254335, 27260704, 27261477, 27359766, 27362994, 27369515\n 27378053, 27392968, 27406105, 27411022, 27423500, 27439716, 27453490\n 27458357, 27489107, 27582210, 27589260, 27622946, 27629928, 27661222\n 27666312, 27684864, 27692173, 27700413, 27710072, 27729678, 27742354\n...\n...\n\n--------------------------------------------------------------------------------\n\nOPatch succeeded.\n<\/pre>\nReady. \ud83d\ude42<\/p>\n
Conclusion<\/h3>\n
Upgrading Oracle Restart from 19.9 to 19.10 runs quite smoothly. The most difficult thing might be to organize the downtime. \ud83d\ude42<\/p>\n","protected":false},"excerpt":{"rendered":"
A new RU (Release Update) came out in January 2021, and I wanted to take this opportunity to show you how to upgrade Oracle Restart 19.9 to 19.10 on a CentOS 8.3 VM. The reason for the upgrade for most of the people out there might be the following bug fixes. Grid Infrastructure 19 Release […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ocean_post_layout":"","ocean_both_sidebars_style":"","ocean_both_sidebars_content_width":0,"ocean_both_sidebars_sidebars_width":0,"ocean_sidebar":"","ocean_second_sidebar":"","ocean_disable_margins":"enable","ocean_add_body_class":"","ocean_shortcode_before_top_bar":"","ocean_shortcode_after_top_bar":"","ocean_shortcode_before_header":"","ocean_shortcode_after_header":"","ocean_has_shortcode":"","ocean_shortcode_after_title":"","ocean_shortcode_before_footer_widgets":"","ocean_shortcode_after_footer_widgets":"","ocean_shortcode_before_footer_bottom":"","ocean_shortcode_after_footer_bottom":"","ocean_display_top_bar":"default","ocean_display_header":"default","ocean_header_style":"","ocean_center_header_left_menu":"","ocean_custom_header_template":"","ocean_custom_logo":0,"ocean_custom_retina_logo":0,"ocean_custom_logo_max_width":0,"ocean_custom_logo_tablet_max_width":0,"ocean_custom_logo_mobile_max_width":0,"ocean_custom_logo_max_height":0,"ocean_custom_logo_tablet_max_height":0,"ocean_custom_logo_mobile_max_height":0,"ocean_header_custom_menu":"","ocean_menu_typo_font_family":"","ocean_menu_typo_font_subset":"","ocean_menu_typo_font_size":0,"ocean_menu_typo_font_size_tablet":0,"ocean_menu_typo_font_size_mobile":0,"ocean_menu_typo_font_size_unit":"px","ocean_menu_typo_font_weight":"","ocean_menu_typo_font_weight_tablet":"","ocean_menu_typo_font_weight_mobile":"","ocean_menu_typo_transform":"","ocean_menu_typo_transform_tablet":"","ocean_menu_typo_transform_mobile":"","ocean_menu_typo_line_height":0,"ocean_menu_typo_line_height_tablet":0,"ocean_menu_typo_line_height_mobile":0,"ocean_menu_typo_line_height_unit":"","ocean_menu_typo_spacing":0,"ocean_menu_typo_spacing_tablet":0,"ocean_menu_typo_spacing_mobile":0,"ocean_menu_typo_spacing_unit":"","ocean_menu_link_color":"","ocean_menu_link_color_hover":"","ocean_menu_link_color_active":"","ocean_menu_link_background":"","ocean_menu_link_hover_background":"","ocean_menu_link_active_background":"","ocean_menu_social_links_bg":"","ocean_menu_social_hover_links_bg":"","ocean_menu_social_links_color":"","ocean_menu_social_hover_links_color":"","ocean_disable_title":"default","ocean_disable_heading":"default","ocean_post_title":"","ocean_post_subheading":"","ocean_post_title_style":"","ocean_post_title_background_color":"","ocean_post_title_background":0,"ocean_post_title_bg_image_position":"","ocean_post_title_bg_image_attachment":"","ocean_post_title_bg_image_repeat":"","ocean_post_title_bg_image_size":"","ocean_post_title_height":0,"ocean_post_title_bg_overlay":0.5,"ocean_post_title_bg_overlay_color":"","ocean_disable_breadcrumbs":"default","ocean_breadcrumbs_color":"","ocean_breadcrumbs_separator_color":"","ocean_breadcrumbs_links_color":"","ocean_breadcrumbs_links_hover_color":"","ocean_display_footer_widgets":"default","ocean_display_footer_bottom":"default","ocean_custom_footer_template":"","ocean_post_oembed":"","ocean_post_self_hosted_media":"","ocean_post_video_embed":"","ocean_link_format":"","ocean_link_format_target":"self","ocean_quote_format":"","ocean_quote_format_link":"post","ocean_gallery_link_images":"on","ocean_gallery_id":[],"footnotes":""},"categories":[10,2,4,5],"tags":[18],"class_list":["post-220","post","type-post","status-publish","format-standard","hentry","category-centos-os","category-db","category-oracle","category-os","tag-oracle","entry"],"yoast_head":"\n
Oracle: How To Upgrade Oracle Restart From 19.9.0.0.0 To 19.10.0.0.0 On CentOS 8.3 Including A CDB\/PDB - ptdb - Platinum DB<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/ptdb.ch\/?p=220\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle: How To Upgrade Oracle Restart From 19.9.0.0.0 To 19.10.0.0.0 On CentOS 8.3 Including A CDB\/PDB - ptdb - Platinum DB\" \/>\n<meta property=\"og:description\" content=\"A new RU (Release Update) came out in January 2021, and I wanted to take this opportunity to show you how to upgrade Oracle Restart 19.9 to 19.10 on a CentOS 8.3 VM. The reason for the upgrade for most of the people out there might be the following bug fixes. Grid Infrastructure 19 Release […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ptdb.ch\/?p=220\" \/>\n<meta property=\"og:site_name\" content=\"ptdb - Platinum DB\" \/>\n<meta property=\"article:published_time\" content=\"2021-03-05T08:25:49+00:00\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"34 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ptdb.ch\/?p=220\",\"url\":\"https:\/\/ptdb.ch\/?p=220\",\"name\":\"Oracle: How To Upgrade Oracle Restart From 19.9.0.0.0 To 19.10.0.0.0 On CentOS 8.3 Including A CDB\/PDB - ptdb - Platinum DB\",\"isPartOf\":{\"@id\":\"https:\/\/ptdb.ch\/#website\"},\"datePublished\":\"2021-03-05T08:25:49+00:00\",\"author\":{\"@id\":\"https:\/\/ptdb.ch\/#\/schema\/person\/0b7baf52d23e71d85e1c95442306090b\"},\"breadcrumb\":{\"@id\":\"https:\/\/ptdb.ch\/?p=220#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/ptdb.ch\/?p=220\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/ptdb.ch\/?p=220#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/ptdb.ch\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle: How To Upgrade Oracle Restart From 19.9.0.0.0 To 19.10.0.0.0 On CentOS 8.3 Including A CDB\/PDB\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/ptdb.ch\/#website\",\"url\":\"https:\/\/ptdb.ch\/\",\"name\":\"ptdb - Platinum DB\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/ptdb.ch\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/ptdb.ch\/#\/schema\/person\/0b7baf52d23e71d85e1c95442306090b\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/ptdb.ch\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1a3dffc48c5f6bae0b88a9f0b2a986d48d322673fbc2880c5abbfab96e45da8a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/1a3dffc48c5f6bae0b88a9f0b2a986d48d322673fbc2880c5abbfab96e45da8a?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"sameAs\":[\"https:\/\/ptdb.ch\"],\"url\":\"https:\/\/ptdb.ch\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Oracle: How To Upgrade Oracle Restart From 19.9.0.0.0 To 19.10.0.0.0 On CentOS 8.3 Including A CDB\/PDB - ptdb - Platinum DB","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/ptdb.ch\/?p=220","og_locale":"en_US","og_type":"article","og_title":"Oracle: How To Upgrade Oracle Restart From 19.9.0.0.0 To 19.10.0.0.0 On CentOS 8.3 Including A CDB\/PDB - ptdb - Platinum DB","og_description":"A new RU (Release Update) came out in January 2021, and I wanted to take this opportunity to show you how to upgrade Oracle Restart 19.9 to 19.10 on a CentOS 8.3 VM. The reason for the upgrade for most of the people out there might be the following bug fixes. Grid Infrastructure 19 Release […]","og_url":"https:\/\/ptdb.ch\/?p=220","og_site_name":"ptdb - Platinum DB","article_published_time":"2021-03-05T08:25:49+00:00","author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"34 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/ptdb.ch\/?p=220","url":"https:\/\/ptdb.ch\/?p=220","name":"Oracle: How To Upgrade Oracle Restart From 19.9.0.0.0 To 19.10.0.0.0 On CentOS 8.3 Including A CDB\/PDB - ptdb - Platinum DB","isPartOf":{"@id":"https:\/\/ptdb.ch\/#website"},"datePublished":"2021-03-05T08:25:49+00:00","author":{"@id":"https:\/\/ptdb.ch\/#\/schema\/person\/0b7baf52d23e71d85e1c95442306090b"},"breadcrumb":{"@id":"https:\/\/ptdb.ch\/?p=220#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ptdb.ch\/?p=220"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/ptdb.ch\/?p=220#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/ptdb.ch\/"},{"@type":"ListItem","position":2,"name":"Oracle: How To Upgrade Oracle Restart From 19.9.0.0.0 To 19.10.0.0.0 On CentOS 8.3 Including A CDB\/PDB"}]},{"@type":"WebSite","@id":"https:\/\/ptdb.ch\/#website","url":"https:\/\/ptdb.ch\/","name":"ptdb - Platinum DB","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ptdb.ch\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/ptdb.ch\/#\/schema\/person\/0b7baf52d23e71d85e1c95442306090b","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/ptdb.ch\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/1a3dffc48c5f6bae0b88a9f0b2a986d48d322673fbc2880c5abbfab96e45da8a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1a3dffc48c5f6bae0b88a9f0b2a986d48d322673fbc2880c5abbfab96e45da8a?s=96&d=mm&r=g","caption":"admin"},"sameAs":["https:\/\/ptdb.ch"],"url":"https:\/\/ptdb.ch\/?author=1"}]}},"_links":{"self":[{"href":"https:\/\/ptdb.ch\/index.php?rest_route=\/wp\/v2\/posts\/220","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ptdb.ch\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ptdb.ch\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ptdb.ch\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ptdb.ch\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=220"}],"version-history":[{"count":0,"href":"https:\/\/ptdb.ch\/index.php?rest_route=\/wp\/v2\/posts\/220\/revisions"}],"wp:attachment":[{"href":"https:\/\/ptdb.ch\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=220"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ptdb.ch\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=220"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ptdb.ch\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=220"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}