{"id":55041,"date":"2023-09-17T20:00:07","date_gmt":"2023-09-17T20:00:07","guid":{"rendered":"https:\/\/dbtut.com\/?p=55041"},"modified":"2023-09-17T20:03:37","modified_gmt":"2023-09-17T20:03:37","slug":"oracle-database-grid-19c-upgrade-19-3-to-19-9","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2023\/09\/17\/oracle-database-grid-19c-upgrade-19-3-to-19-9\/","title":{"rendered":"Oracle Database Grid 19C Upgrade 19.3 To 19.9"},"content":{"rendered":"<p>In today&#8217;s article, I will explain how to upgrade our Oracle Database 19.3 database built on Grid Infrastructure.<\/p>\n<p>The database we will upgrade is running 19.3 and we will update it to 19.9.<\/p>\n<p>Oracle publishes Patch Set Updates every 6 months.<\/p>\n<p>These patches, which we can follow from the link below, are necessary for the security, performance and stable operation of both the Grid environment and the database.<\/p>\n<pre class=\"lang:default decode:true \">\u201d https:\/\/www.oracle.com\/security-alerts\/ \u201d<\/pre>\n<p>First, the grid will be upgraded, then the database will be upgraded.<\/p>\n<p>First of all, we make the following installations via support.<\/p>\n<p><strong>For GI Upgrade:<\/strong> 31750108<br \/>\n<strong>For DB Upgrade:<\/strong> 31771877<\/p>\n<p>Let&#8217;s start ;<\/p>\n<pre class=\"lang:default decode:true \">$ mkdir -p \/u01\/patch \/u01\/patch\/db df \/u01\/patch\/grid \r\n$ chown -R oracle:oinstall \/u01\/patch \r\n$ chmod -R 775 \/u01\/patch<\/pre>\n<p>First of all, we will upgrade the GI, or Grid.<\/p>\n<pre class=\"lang:default decode:true \">$ cd \/u01\/patch\/grid \r\n$ unzip p31750108_190000_Linux-x86-64.zip<\/pre>\n<pre class=\"lang:default decode:true \">$ &lt;ORACLE_HOME&gt;\/OPatch\/opatch version \r\n[oracle@node1 OPatch]$ .\/opatch version \r\nOPatch Version: 12.2.0.1.17 \r\nOPatch succeeded.<\/pre>\n<p>On the readme I used for the patch, it is stated that the Opatch version must be at least 12.2.0.1.19 and later.<\/p>\n<p>I will update Opatch now. Then I download the latest version (Patch 6880880) from support.<\/p>\n<pre class=\"lang:default decode:true \">$ cd \/u01\/app\/19.0.0.0\/grid\r\n $ mv OPatch OPatch_old\r\n $ unzip p6880880_200000_Linux-x86-64.zip\r\n $ chmod -R 775 OPatch\r\n $ chown -R oracle:oinstall OPatch<\/pre>\n<p>Let&#8217;s check the update.<\/p>\n<pre class=\"lang:default decode:true \">[root@node1 OPatch]# .\/opatch version\r\n OPatch Version: 12.2.0.1.23\r\n OPatch succeeded.<\/pre>\n<p>We are checking if there is another patch that affects us.<\/p>\n<p>If there are, we will need to rollback with the specified patch numbers.<\/p>\n<p>I start as follows. The first 5 steps will be on GRID_HOME and the last 2 steps will be on ORACLE_HOME.<\/p>\n<pre class=\"lang:default decode:true \">$ORACLE_HOME\/OPatch\/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir \/u01\/patch\/grid\/31750108\/31771877\r\n Oracle Interim Patch Installer version 12.2.0.1.23\r\n Copyright (c) 2021, Oracle Corporation.  All rights reserved.\r\n PREREQ session\r\n Oracle Home       : \/u01\/app\/19.0.0.0\/grid\r\n Central Inventory : \/u01\/app\/oraInventory\r\n    from           : \/u01\/app\/19.0.0.0\/grid\/oraInst.loc\r\n OPatch version    : 12.2.0.1.23\r\n OUI version       : 12.2.0.7.0\r\n Log file location : \/u01\/app\/19.0.0.0\/grid\/cfgtoollogs\/opatch\/opatch2021-01-03_16-46-17PM_1.log\r\n Invoking prereq \"checkconflictagainstohwithdetail\"\r\n Prereq \"checkConflictAgainstOHWithDetail\" passed.\r\n OPatch succeeded.<\/pre>\n<p>There is no problem, I continue with the others, one by one.<\/p>\n<pre class=\"lang:default decode:true \">$ $ORACLE_HOME\/OPatch\/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir \/u01\/patch\/grid\/31750108\/31772784\r\n\r\n Oracle Interim Patch Installer version 12.2.0.1.23\r\n Copyright (c) 2021, Oracle Corporation.  All rights reserved.\r\n PREREQ session\r\n Oracle Home       : \/u01\/app\/19.0.0.0\/grid\r\n Central Inventory : \/u01\/app\/oraInventory\r\n    from           : \/u01\/app\/19.0.0.0\/grid\/oraInst.loc\r\n OPatch version    : 12.2.0.1.23\r\n OUI version       : 12.2.0.7.0\r\n Log file location : \/u01\/app\/19.0.0.0\/grid\/cfgtoollogs\/opatch\/opatch2021-01-03_16-47-11PM_1.log\r\n Invoking prereq \"checkconflictagainstohwithdetail\"\r\n Prereq \"checkConflictAgainstOHWithDetail\" passed.\r\n OPatch succeeded.<\/pre>\n<pre class=\"lang:default decode:true \">$ $ORACLE_HOME\/OPatch\/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir \/u01\/patch\/grid\/31750108\/31773437\r\n\r\n Oracle Interim Patch Installer version 12.2.0.1.23\r\n Copyright (c) 2021, Oracle Corporation.  All rights reserved.\r\n PREREQ session\r\n Oracle Home       : \/u01\/app\/19.0.0.0\/grid\r\n Central Inventory : \/u01\/app\/oraInventory\r\n    from           : \/u01\/app\/19.0.0.0\/grid\/oraInst.loc\r\n OPatch version    : 12.2.0.1.23\r\n OUI version       : 12.2.0.7.0\r\n Log file location : \/u01\/app\/19.0.0.0\/grid\/cfgtoollogs\/opatch\/opatch2021-01-03_16-47-37PM_1.log\r\n Invoking prereq \"checkconflictagainstohwithdetail\"\r\n Prereq \"checkConflictAgainstOHWithDetail\" passed.\r\n OPatch succeeded.<\/pre>\n<pre class=\"lang:default decode:true \">$ $ORACLE_HOME\/OPatch\/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir \/u01\/patch\/grid\/31750108\/31780966\r\n\r\n Oracle Interim Patch Installer version 12.2.0.1.23\r\n Copyright (c) 2021, Oracle Corporation.  All rights reserved.\r\n PREREQ session\r\n Oracle Home       : \/u01\/app\/19.0.0.0\/grid\r\n Central Inventory : \/u01\/app\/oraInventory\r\n    from           : \/u01\/app\/19.0.0.0\/grid\/oraInst.loc\r\n OPatch version    : 12.2.0.1.23\r\n OUI version       : 12.2.0.7.0\r\n Log file location : \/u01\/app\/19.0.0.0\/grid\/cfgtoollogs\/opatch\/opatch2021-01-03_16-47-58PM_1.log\r\n Invoking prereq \"checkconflictagainstohwithdetail\"\r\n Prereq \"checkConflictAgainstOHWithDetail\" passed.\r\n OPatch succeeded.<\/pre>\n<pre class=\"lang:default decode:true \">$ $ORACLE_HOME\/OPatch\/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir \/u01\/patch\/grid\/31750108\/\r\n\r\n Oracle Interim Patch Installer version 12.2.0.1.23\r\n Copyright (c) 2021, Oracle Corporation.  All rights reserved.\r\n PREREQ session\r\n Oracle Home       : \/u01\/app\/19.0.0.0\/grid\r\n Central Inventory : \/u01\/app\/oraInventory\r\n    from           : \/u01\/app\/19.0.0.0\/grid\/oraInst.loc\r\n OPatch version    : 12.2.0.1.23\r\n OUI version       : 12.2.0.7.0\r\n Log file location : \/u01\/app\/19.0.0.0\/grid\/cfgtoollogs\/opatch\/opatch2021-01-03_16-48-25PM_1.log\r\n This command doesn't support System Patch.\r\n OPatch failed with error code 21<\/pre>\n<p>The last error doesn&#8217;t matter to us, this line is actually extra in the readme.<\/p>\n<p>I run tests via Oracle HOME.<\/p>\n<pre class=\"lang:default decode:true \">$ORACLE_HOME\/OPatch\/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir \/u01\/patch\/grid\/31750108\/31771877\r\n\r\n Oracle Interim Patch Installer version 12.2.0.1.17\r\n Copyright (c) 2021, Oracle Corporation.  All rights reserved.\r\n PREREQ session\r\n Oracle Home       : \/u01\/app\/oracle\/product\/19.0.0.0\/dbhome_1\r\n Central Inventory : \/u01\/app\/oraInventory\r\n    from           : \/u01\/app\/oracle\/product\/19.0.0.0\/dbhome_1\/oraInst.loc\r\n OPatch version    : 12.2.0.1.17\r\n OUI version       : 12.2.0.7.0\r\n Log file location : \/u01\/app\/oracle\/product\/19.0.0.0\/dbhome_1\/cfgtoollogs\/opatch\/opatch2021-01-03_16-50-10PM_1.log\r\n Invoking prereq \"checkconflictagainstohwithdetail\"\r\n Prereq \"checkConflictAgainstOHWithDetail\" passed.\r\n OPatch succeeded.<\/pre>\n<pre class=\"lang:default decode:true \">$ORACLE_HOME\/OPatch\/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir \/u01\/patch\/grid\/31750108\/31772784\r\n\r\n Oracle Interim Patch Installer version 12.2.0.1.17\r\n Copyright (c) 2021, Oracle Corporation.  All rights reserved.\r\n PREREQ session\r\n Oracle Home       : \/u01\/app\/oracle\/product\/19.0.0.0\/dbhome_1\r\n Central Inventory : \/u01\/app\/oraInventory\r\n    from           : \/u01\/app\/oracle\/product\/19.0.0.0\/dbhome_1\/oraInst.loc\r\n OPatch version    : 12.2.0.1.17\r\n OUI version       : 12.2.0.7.0\r\n Log file location : \/u01\/app\/oracle\/product\/19.0.0.0\/dbhome_1\/cfgtoollogs\/opatch\/opatch2021-01-03_16-50-54PM_1.log\r\n Invoking prereq \"checkconflictagainstohwithdetail\"\r\n Prereq \"checkConflictAgainstOHWithDetail\" passed.\r\n OPatch succeeded.<\/pre>\n<p>We are coming to the final stages. We open a file named \u201cpatch_list_gihome.txt\u201d in tmp and add the following lines.<\/p>\n<pre class=\"lang:default decode:true \">$ nano \/tmp\/patch_list_gihome.txt\r\n\r\n \/u01\/patch\/grid\/31750108\/31771877\r\n \/u01\/patch\/grid\/31750108\/31772784\r\n \/u01\/patch\/grid\/31750108\/31773437\r\n \/u01\/patch\/grid\/31750108\/31780966<\/pre>\n<p>We make final checks after the addition process.<\/p>\n<pre class=\"lang:default decode:true \">$ORACLE_HOME\/OPatch\/opatch prereq CheckSystemSpace -phBaseFile \/tmp\/patch_list_gihome.txt\r\n<\/pre>\n<pre class=\"lang:default decode:true \">[oracle@node1 ~]$ $ORACLE_HOME\/OPatch\/opatch prereq CheckSystemSpace -phBaseFile \/tmp\/patch_list_gihome.txt\r\n\r\n Oracle Interim Patch Installer version 12.2.0.1.23\r\n Copyright (c) 2021, Oracle Corporation.  All rights reserved.\r\n PREREQ session\r\n Oracle Home       : \/u01\/app\/19.0.0.0\/grid\r\n Central Inventory : \/u01\/app\/oraInventory\r\n    from           : \/u01\/app\/19.0.0.0\/grid\/oraInst.loc\r\n OPatch version    : 12.2.0.1.23\r\n OUI version       : 12.2.0.7.0\r\n Log file location : \/u01\/app\/19.0.0.0\/grid\/cfgtoollogs\/opatch\/opatch2021-01-03_17-03-36PM_1.log\r\n Invoking prereq \"checksystemspace\"\r\n Prereq \"checkSystemSpace\" pass\r\n OPatch succeeded.<\/pre>\n<p>We will upgrade for GI with &#8220;opatchauto&#8221;.<\/p>\n<p>In this way, all operations such as closing and opening CRS will be done automatically.<\/p>\n<pre class=\"lang:default decode:true \"># export PATH=$PATH:$ORACLE_HOME\/OPatch \r\n# opatchauto apply \/u01\/patch\/grid\/\/31750108 -oh \/u01\/app\/19.0.0.0\/grid<\/pre>\n<p>Opatch process for GI started<\/p>\n<pre class=\"lang:default decode:true \">[root@node1 OPatch]# opatchauto apply \/u01\/patch\/grid\/\/31750108 -oh \/u01\/app\/19.0.0.0\/grid\r\n OPatchauto session is initiated at Sun Jan  3 17:29:48 2021\r\n System initialization log file is \/u01\/app\/19.0.0.0\/grid\/cfgtoollogs\/opatchautodb\/systemconfig2021-01-03_05-29-52PM.log.\r\n Session log file is \/u01\/app\/19.0.0.0\/grid\/cfgtoollogs\/opatchauto\/opatchauto2021-01-03_05-29-57PM.log\r\n The id for this session is P3IG\r\n Executing OPatch prereq operations to verify patch applicability on home \/u01\/app\/19.0.0.0\/grid\r\n Patch applicability verified successfully on home \/u01\/app\/19.0.0.0\/grid\r\n Executing patch validation checks on home \/u01\/app\/19.0.0.0\/grid\r\n Patch validation checks successfully completed on home \/u01\/app\/19.0.0.0\/grid\r\n Bringing down CRS service on home \/u01\/app\/19.0.0.0\/grid\r\n Prepatch operation log file location: \/u01\/app\/oracle\/crsdata\/node1\/crsconfig\/hapatch_2021-01-03_05-30-31PM.log\r\n CRS service brought down successfully on home \/u01\/app\/19.0.0.0\/grid\r\n Start applying binary patch on home \/u01\/app\/19.0.0.0\/grid\r\n .\r\n .\r\n .\r\n .<\/pre>\n<p>If you want, you can follow the situation via log file location.<\/p>\n<pre class=\"lang:default decode:true \">tail -100f \/u01\/app\/oracle\/crsdata\/node1\/crsconfig\/hapatch_2021-01-03_05-30-31PM.log\r\n .\r\n .\r\n .\r\n .\r\n .\r\n   End Command output\r\n   2021-01-03 17:30:57: Configured CRS Home: \/u01\/app\/19.0.0.0\/grid\r\n   2021-01-03 17:30:57: Executing cmd: \/u01\/app\/19.0.0.0\/grid\/bin\/crsctl check has\r\n   2021-01-03 17:30:57: Command output:\r\n    CRS-4639: Could not contact Oracle High Availability Services\r\n   End Command output\r\n   2021-01-03 17:30:57: The GI home to unlock: \/u01\/app\/19.0.0.0\/grid\r\n   2021-01-03 17:30:57: Unlocking the GI home: \/u01\/app\/19.0.0.0\/grid\r\n   2021-01-03 17:30:57: Processing directory permissions\r\n   2021-01-03 17:30:57: set the permissions on the \/u01\/app\/19.0.0.0\/grid\/jdk directory\r\n   2021-01-03 17:30:57: set the permissions on the \/u01\/app\/19.0.0.0\/grid\/perl directory\r\n   2021-01-03 17:30:57: set the permissions on the \/u01\/app\/19.0.0.0\/grid\/bin directory\r\n   2021-01-03 17:30:57: skip setting perms for exclude file \/u01\/app\/19.0.0.0\/grid\/bin\/asmcmdcore\r\n   2021-01-03 17:30:57: skip setting perms for exclude file \/u01\/app\/19.0.0.0\/grid\/bin\/asmcmdcore\r\n   2021-01-03 17:30:57: skip setting perms for exclude file \/u01\/app\/19.0.0.0\/grid\/bin\/extjob\r\n   2021-01-03 17:30:57: skip setting perms for exclude file \/u01\/app\/19.0.0.0\/grid\/bin\/cluvfyrac.sh\r\n   2021-01-03 17:30:57: skip setting perms for exclude file \/u01\/app\/19.0.0.0\/grid\/bin\/dbstart\r\n   2021-01-03 17:30:57: skip setting perms for exclude file \/u01\/app\/19.0.0.0\/grid\/bin\/extjobo\r\n   2021-01-03 17:30:57: skip setting perms for exclude file \/u01\/app\/19.0.0.0\/grid\/bin\/extjobo\r\n   2021-01-03 17:30:57: skip setting perms for exclude file \/u01\/app\/19.0.0.0\/grid\/bin\/extproc\r\n   2021-01-03 17:30:57: skip setting perms for exclude file \/u01\/app\/19.0.0.0\/grid\/bin\/oracle\r\n   2021-01-03 17:30:57: skip setting perms for exclude file \/u01\/app\/19.0.0.0\/grid\/bin\/oradism\r\n   2021-01-03 17:30:57: skip setting perms for exclude file \/u01\/app\/19.0.0.0\/grid\/bin\/relink\r\n   2021-01-03 17:30:57: skip setting perms for exclude file \/u01\/app\/19.0.0.0\/grid\/bin\/oklist0\r\n   2021-01-03 17:30:57: skip setting perms for exclude file \/u01\/app\/19.0.0.0\/grid\/bin\/xmlwf\r\n   2021-01-03 17:30:57: skip setting perms for exclude file \/u01\/app\/19.0.0.0\/grid\/bin\/asmcmd\r\n   2021-01-03 17:30:57: skip setting perms for exclude file \/u01\/app\/19.0.0.0\/grid\/bin\/jssu\r\n   2021-01-03 17:30:57: skip setting perms for exclude file \/u01\/app\/19.0.0.0\/grid\/bin\/onsctl\r\n   2021-01-03 17:30:57: skip setting perms for exclude file \/u01\/app\/19.0.0.0\/grid\/bin\/okinit0\r\n   2021-01-03 17:30:57: skip setting perms for exclude file \/u01\/app\/19.0.0.0\/grid\/bin\/okdstry0\r\n   2021-01-03 17:30:57: set the permissions on the \/u01\/app\/19.0.0.0\/grid\/lib directory\r\n   2021-01-03 17:30:57: Executing cmd: \/u01\/app\/19.0.0.0\/grid\/bin\/clsecho -p has -f clsrsc -m 347 '\/u01\/app\/19.0.0.0\/grid'\r\n   2021-01-03 17:30:57: Executing cmd: \/u01\/app\/19.0.0.0\/grid\/bin\/clsecho -p has -f clsrsc -m 347 '\/u01\/app\/19.0.0.0\/grid'\r\n   2021-01-03 17:30:57: Command output:\r\n    CLSRSC-347: Successfully unlock \/u01\/app\/19.0.0.0\/grid\r\n   End Command output\r\n   2021-01-03 17:30:57: CLSRSC-347: Successfully unlock \/u01\/app\/19.0.0.0\/grid\r\n   2021-01-03 17:30:57: Executing cmd: \/u01\/app\/19.0.0.0\/grid\/bin\/clsecho -p has -f clsrsc -m 671\r\n   2021-01-03 17:30:57: Executing cmd: \/u01\/app\/19.0.0.0\/grid\/bin\/clsecho -p has -f clsrsc -m 671<\/pre>\n<p>GI Patch process is over and we have completed the process successfully.<\/p>\n<pre class=\"lang:default decode:true \">Host:node1\r\n SIHA Home:\/u01\/app\/19.0.0.0\/grid\r\n Version:19.0.0.0.0\r\n Summary:\r\n ==Following patches were SUCCESSFULLY applied:\r\n Patch: \/u01\/patch\/grid\/31750108\/31771877\r\n Log: \/u01\/app\/19.0.0.0\/grid\/cfgtoollogs\/opatchauto\/core\/opatch\/opatch2021-01-03_17-31-00PM_1.log\r\n Patch: \/u01\/patch\/grid\/31750108\/31772784\r\n Log: \/u01\/app\/19.0.0.0\/grid\/cfgtoollogs\/opatchauto\/core\/opatch\/opatch2021-01-03_17-31-00PM_1.log\r\n Patch: \/u01\/patch\/grid\/31750108\/31773437\r\n Log: \/u01\/app\/19.0.0.0\/grid\/cfgtoollogs\/opatchauto\/core\/opatch\/opatch2021-01-03_17-31-00PM_1.log\r\n Patch: \/u01\/patch\/grid\/31750108\/31780966\r\n Log: \/u01\/app\/19.0.0.0\/grid\/cfgtoollogs\/opatchauto\/core\/opatch\/opatch2021-01-03_17-31-00PM_1.log\r\n OPatchauto session completed at Sun Jan  3 17:38:50 2021\r\n Time taken to complete the session 9 minutes, 2 seconds<\/pre>\n<p>Now we will continue for the database.<\/p>\n<p>I quickly update Opatch from scratch. I am transferring the latest version of Opatch that I downloaded here.<\/p>\n<pre class=\"lang:default decode:true \">$ cd \/u01\/app\/oracle\/product\/19.0.0.0\/dbhome_1\r\n $ mv OPatch OPatch_old\r\n $ cp -r \/u01\/app\/19.0.0.0\/grid\/OPatch \/u01\/app\/oracle\/product\/19.0.0.0\/dbhome_1\/<\/pre>\n<p>Let&#8217;s start with database updates.<\/p>\n<pre class=\"lang:default decode:true \">$ cd \/u01\/patch\/db\r\n $ unzip p31771877_190000_Linux-x86-64.zip\r\n $ $ORALCE_HOME\/opatch version\r\n OPatch Version: 12.2.0.1.23\r\n OPatch succeeded.<\/pre>\n<p>I&#8217;m doing the checks.<\/p>\n<pre class=\"lang:default decode:true \">$ export PATH=$PATH:\/usr\/ccs\/bin\r\n<\/pre>\n<pre class=\"lang:default decode:true \">$ cd \/u01\/patch\/db\/31771877\r\n $ $ORACLE_HOME\/OPatch\/opatch prereq CheckConflictAgainstOHWithDetail -ph .\/\r\n\r\n Oracle Interim Patch Installer version 12.2.0.1.23\r\n Copyright (c) 2021, Oracle Corporation.  All rights reserved.\r\n PREREQ session\r\n Oracle Home       : \/u01\/app\/oracle\/product\/19.0.0.0\/dbhome_1\r\n Central Inventory : \/u01\/app\/oraInventory\r\n    from           : \/u01\/app\/oracle\/product\/19.0.0.0\/dbhome_1\/oraInst.loc\r\n OPatch version    : 12.2.0.1.23\r\n OUI version       : 12.2.0.7.0\r\n Log file location : \/u01\/app\/oracle\/product\/19.0.0.0\/dbhome_1\/cfgtoollogs\/opatch\/opatch2021-01-03_17-47-55PM_1.log\r\n Invoking prereq \"checkconflictagainstohwithdetail\"\r\n Prereq \"checkConflictAgainstOHWithDetail\" passed.\r\n OPatch succeeded.<\/pre>\n<p>The problem does not appear. Now we close the Listener and the database.<\/p>\n<pre class=\"lang:default decode:true \">$ lsnrctl stop\r\n LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 03-JAN-2021 17:49:39\r\n Copyright (c) 1991, 2019, Oracle.  All rights reserved.\r\n Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))\r\n The command completed successfully<\/pre>\n<pre class=\"lang:default decode:true \">$ sqlplus \/ as sysdba\r\n SQL*Plus: Release 19.0.0.0.0 - Production on Sun Jan 3 17:49:44 2021\r\n Version 19.3.0.0.0\r\n Copyright (c) 1982, 2019, Oracle.  All rights reserved.\r\n Connected to:\r\n Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\r\n Version 19.3.0.0.0\r\n SQL&gt; shu immediate;\r\n Database closed.\r\n Database dismounted.\r\n ORACLE instance shut down.\r\n SQL&gt;<\/pre>\n<p>And let the Patch begin.<\/p>\n<pre class=\"lang:default decode:true \">$ $ORACLE_HOME\/OPatch\/opatch apply\r\n\r\n\r\n Oracle Interim Patch Installer version 12.2.0.1.23\r\n Copyright (c) 2021, Oracle Corporation.  All rights reserved.\r\n Oracle Home       : \/u01\/app\/oracle\/product\/19.0.0.0\/dbhome_1\r\n Central Inventory : \/u01\/app\/oraInventory\r\n    from           : \/u01\/app\/oracle\/product\/19.0.0.0\/dbhome_1\/oraInst.loc\r\n OPatch version    : 12.2.0.1.23\r\n OUI version       : 12.2.0.7.0\r\n Log file location : \/u01\/app\/oracle\/product\/19.0.0.0\/dbhome_1\/cfgtoollogs\/opatch\/opatch2021-01-03_17-50-59PM_1.log\r\n Verifying environment and performing prerequisite checks\u2026\r\n OPatch continues with these patches:   31771877\r\n Do you want to proceed? [y|n]\r\n y\r\n User Responded with: Y\r\n All checks passed.\r\n Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.\r\n (Oracle Home = '\/u01\/app\/oracle\/product\/19.0.0.0\/dbhome_1')\r\n Is the local system ready for patching? [y|n]\r\n y\r\n User Responded with: Y\r\n Backing up files\u2026\r\n Applying interim patch '31771877' to OH '\/u01\/app\/oracle\/product\/19.0.0.0\/dbhome_1'\r\n ApplySession: Optional component(s) [ oracle.network.gsm, 19.0.0.0.0 ] , [ oracle.rdbms.ic, 19.0.0.0.0 ] , [ oracle.rdbms.tg4db2, 19.0.0.0.0 ] , [ oracle.tfa, 19.0.0.0.0 ] , [ oracle.options.olap.awm, 19.0.0.0.0 ] , [ oracle.net.cman, 19.0.0.0.0 ] , [ oracle.xdk.companion, 19.0.0.0.0 ] , [ oracle.oraolap.mgmt, 19.0.0.0.0 ] , [ oracle.network.cman, 19.0.0.0.0 ] , [ oracle.options.olap, 19.0.0.0.0 ] , [ oracle.assistants.usm, 19.0.0.0.0 ] , [ oracle.assistants.asm, 19.0.0.0.0 ] , [ oracle.sqlj, 19.0.0.0.0 ] , [ oracle.jdk, 1.8.0.191.0 ]  not present in the Oracle Home or a higher version is found.<\/pre>\n<p>Database patching process has been completed.<\/p>\n<pre class=\"lang:default decode:true \">Patching component oracle.xdk.rsf, 19.0.0.0.0\u2026\r\n Patching component oracle.xdk.parser.java, 19.0.0.0.0\u2026\r\n Patching component oracle.rdbms.rsf.ic, 19.0.0.0.0\u2026\r\n Patching component oracle.precomp.common, 19.0.0.0.0\u2026\r\n Patching component oracle.precomp.lang, 19.0.0.0.0\u2026\r\n Patching component oracle.jdk, 1.8.0.201.0\u2026\r\n Patch 31771877 successfully applied.\r\n Sub-set patch [29517242] has become inactive due to the application of a super-set patch [31771877].\r\n Please refer to Doc ID 2161861.1 for any possible further required actions.\r\n Log file location: \/u01\/app\/oracle\/product\/19.0.0.0\/dbhome_1\/cfgtoollogs\/opatch\/opatch2021-01-03_17-50-59PM_1.log\r\n OPatch succeeded.<\/pre>\n<p>From now on, it&#8217;s comfortable. Let&#8217;s see what happened.<\/p>\n<pre class=\"lang:default decode:true \">$ sqlplus \/ as sysdba\r\n\r\n SQL*Plus: Release 19.0.0.0.0 - Production on Sun Jan 3 17:55:20 2021\r\n Version 19.9.0.0.0\r\n Copyright (c) 1982, 2020, Oracle.  All rights reserved.\r\n\r\n SQL&gt;<\/pre>\n<p>It looks like it&#8217;s loaded now.<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_55041\" class=\"pvc_stats all  \" data-element-id=\"55041\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>In today&#8217;s article, I will explain how to upgrade our Oracle Database 19.3 database built on Grid Infrastructure. The database we will upgrade is running 19.3 and we will update it to 19.9. Oracle publishes Patch Set Updates every 6 months. These patches, which we can follow from the link below, are necessary for the &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_55041\" class=\"pvc_stats all  \" data-element-id=\"55041\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":574,"featured_media":55042,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[4],"tags":[],"class_list":["post-55041","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":179,"today_views":0},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Oracle Database Grid 19C Upgrade 19.3 To 19.9 - Database Tutorials<\/title>\n<meta name=\"description\" content=\"In today&#039;s article, I will explain how to upgrade our Oracle Database 19.3 database built on Grid Infrastructure.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2023\/09\/17\/oracle-database-grid-19c-upgrade-19-3-to-19-9\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle Database Grid 19C Upgrade 19.3 To 19.9 - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"In today&#039;s article, I will explain how to upgrade our Oracle Database 19.3 database built on Grid Infrastructure.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2023\/09\/17\/oracle-database-grid-19c-upgrade-19-3-to-19-9\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-09-17T20:00:07+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-09-17T20:03:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/09\/Ekran-goruntusu-2023-09-17-225729.png\" \/>\n\t<meta property=\"og:image:width\" content=\"681\" \/>\n\t<meta property=\"og:image:height\" content=\"273\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Bu\u011fra PARLAYAN\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Bu\u011fra PARLAYAN\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/09\/17\/oracle-database-grid-19c-upgrade-19-3-to-19-9\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/09\/17\/oracle-database-grid-19c-upgrade-19-3-to-19-9\/\"},\"author\":{\"name\":\"Bu\u011fra PARLAYAN\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/f07abb2de370d35d6c93e90d8eb2b9f2\"},\"headline\":\"Oracle Database Grid 19C Upgrade 19.3 To 19.9\",\"datePublished\":\"2023-09-17T20:00:07+00:00\",\"dateModified\":\"2023-09-17T20:03:37+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/09\/17\/oracle-database-grid-19c-upgrade-19-3-to-19-9\/\"},\"wordCount\":382,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/09\/17\/oracle-database-grid-19c-upgrade-19-3-to-19-9\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/09\/Ekran-goruntusu-2023-09-17-225729.png\",\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2023\/09\/17\/oracle-database-grid-19c-upgrade-19-3-to-19-9\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/09\/17\/oracle-database-grid-19c-upgrade-19-3-to-19-9\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2023\/09\/17\/oracle-database-grid-19c-upgrade-19-3-to-19-9\/\",\"name\":\"Oracle Database Grid 19C Upgrade 19.3 To 19.9 - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/09\/17\/oracle-database-grid-19c-upgrade-19-3-to-19-9\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/09\/17\/oracle-database-grid-19c-upgrade-19-3-to-19-9\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/09\/Ekran-goruntusu-2023-09-17-225729.png\",\"datePublished\":\"2023-09-17T20:00:07+00:00\",\"dateModified\":\"2023-09-17T20:03:37+00:00\",\"description\":\"In today's article, I will explain how to upgrade our Oracle Database 19.3 database built on Grid Infrastructure.\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/09\/17\/oracle-database-grid-19c-upgrade-19-3-to-19-9\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2023\/09\/17\/oracle-database-grid-19c-upgrade-19-3-to-19-9\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/09\/17\/oracle-database-grid-19c-upgrade-19-3-to-19-9\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/09\/Ekran-goruntusu-2023-09-17-225729.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/09\/Ekran-goruntusu-2023-09-17-225729.png\",\"width\":681,\"height\":273},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/09\/17\/oracle-database-grid-19c-upgrade-19-3-to-19-9\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle Database Grid 19C Upgrade 19.3 To 19.9\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/f07abb2de370d35d6c93e90d8eb2b9f2\",\"name\":\"Bu\u011fra PARLAYAN\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8fe63334d745f00f79f9f47b870aa143dd0f7615580c741a3b078aa4d09fa071?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8fe63334d745f00f79f9f47b870aa143dd0f7615580c741a3b078aa4d09fa071?s=96&d=mm&r=g\",\"caption\":\"Bu\u011fra PARLAYAN\"},\"description\":\"Burgra Parlayan is an experienced Database and Weblogic Administrator. After completing his technical \/ relevant training he has got involved with a serious amount of projects. He successfully managed database upgrade, database migration, database performance tuning projects for various public institutions.Currently he has been employed by one of the leading financial institutions called Turkiye Hayat &amp; Emeklilik as responsible administrator for Oracle Database and Oracle Middleware. He has been sharing his experience and knowledge by face to face training, personal blog and various social networking accounts to support the Oracle ecosystem continuously since 2010.\",\"sameAs\":[\"http:\/\/www.bugraparlayan.com.tr\/\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/bugraparlayan\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Oracle Database Grid 19C Upgrade 19.3 To 19.9 - Database Tutorials","description":"In today's article, I will explain how to upgrade our Oracle Database 19.3 database built on Grid Infrastructure.","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:\/\/dbtut.com\/index.php\/2023\/09\/17\/oracle-database-grid-19c-upgrade-19-3-to-19-9\/","og_locale":"en_US","og_type":"article","og_title":"Oracle Database Grid 19C Upgrade 19.3 To 19.9 - Database Tutorials","og_description":"In today's article, I will explain how to upgrade our Oracle Database 19.3 database built on Grid Infrastructure.","og_url":"https:\/\/dbtut.com\/index.php\/2023\/09\/17\/oracle-database-grid-19c-upgrade-19-3-to-19-9\/","og_site_name":"Database Tutorials","article_published_time":"2023-09-17T20:00:07+00:00","article_modified_time":"2023-09-17T20:03:37+00:00","og_image":[{"width":681,"height":273,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/09\/Ekran-goruntusu-2023-09-17-225729.png","type":"image\/png"}],"author":"Bu\u011fra PARLAYAN","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Bu\u011fra PARLAYAN","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2023\/09\/17\/oracle-database-grid-19c-upgrade-19-3-to-19-9\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/09\/17\/oracle-database-grid-19c-upgrade-19-3-to-19-9\/"},"author":{"name":"Bu\u011fra PARLAYAN","@id":"https:\/\/dbtut.com\/#\/schema\/person\/f07abb2de370d35d6c93e90d8eb2b9f2"},"headline":"Oracle Database Grid 19C Upgrade 19.3 To 19.9","datePublished":"2023-09-17T20:00:07+00:00","dateModified":"2023-09-17T20:03:37+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/09\/17\/oracle-database-grid-19c-upgrade-19-3-to-19-9\/"},"wordCount":382,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/09\/17\/oracle-database-grid-19c-upgrade-19-3-to-19-9\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/09\/Ekran-goruntusu-2023-09-17-225729.png","articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2023\/09\/17\/oracle-database-grid-19c-upgrade-19-3-to-19-9\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2023\/09\/17\/oracle-database-grid-19c-upgrade-19-3-to-19-9\/","url":"https:\/\/dbtut.com\/index.php\/2023\/09\/17\/oracle-database-grid-19c-upgrade-19-3-to-19-9\/","name":"Oracle Database Grid 19C Upgrade 19.3 To 19.9 - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/09\/17\/oracle-database-grid-19c-upgrade-19-3-to-19-9\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/09\/17\/oracle-database-grid-19c-upgrade-19-3-to-19-9\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/09\/Ekran-goruntusu-2023-09-17-225729.png","datePublished":"2023-09-17T20:00:07+00:00","dateModified":"2023-09-17T20:03:37+00:00","description":"In today's article, I will explain how to upgrade our Oracle Database 19.3 database built on Grid Infrastructure.","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/09\/17\/oracle-database-grid-19c-upgrade-19-3-to-19-9\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2023\/09\/17\/oracle-database-grid-19c-upgrade-19-3-to-19-9\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2023\/09\/17\/oracle-database-grid-19c-upgrade-19-3-to-19-9\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/09\/Ekran-goruntusu-2023-09-17-225729.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/09\/Ekran-goruntusu-2023-09-17-225729.png","width":681,"height":273},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2023\/09\/17\/oracle-database-grid-19c-upgrade-19-3-to-19-9\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Oracle Database Grid 19C Upgrade 19.3 To 19.9"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/f07abb2de370d35d6c93e90d8eb2b9f2","name":"Bu\u011fra PARLAYAN","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8fe63334d745f00f79f9f47b870aa143dd0f7615580c741a3b078aa4d09fa071?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8fe63334d745f00f79f9f47b870aa143dd0f7615580c741a3b078aa4d09fa071?s=96&d=mm&r=g","caption":"Bu\u011fra PARLAYAN"},"description":"Burgra Parlayan is an experienced Database and Weblogic Administrator. After completing his technical \/ relevant training he has got involved with a serious amount of projects. He successfully managed database upgrade, database migration, database performance tuning projects for various public institutions.Currently he has been employed by one of the leading financial institutions called Turkiye Hayat &amp; Emeklilik as responsible administrator for Oracle Database and Oracle Middleware. He has been sharing his experience and knowledge by face to face training, personal blog and various social networking accounts to support the Oracle ecosystem continuously since 2010.","sameAs":["http:\/\/www.bugraparlayan.com.tr\/"],"url":"https:\/\/dbtut.com\/index.php\/author\/bugraparlayan\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/55041","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/574"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=55041"}],"version-history":[{"count":3,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/55041\/revisions"}],"predecessor-version":[{"id":55045,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/55041\/revisions\/55045"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/55042"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=55041"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=55041"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=55041"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}