On this post we are going to go step-by-step through the process of upgrading a 2 node RAC from 19c to 26ai. We are going to install here: You can download the Grid Home from here. 1:- First we are going to install 26ai preinstall packages and update the system: If you have role separation... » read more
Here I’m going to list all the errors/fixes during the an prechecks/upgrade to 26ai: 1:- Error during “gridSetup.sh -silent -upgrade -executePrereqs” This error is because process tries to ssh to itself and it needs password input, to avoid that, this is the fix: 2:- Error during “gridSetup.sh -silent -upgrade -executePrereqs” FIX (as error already suggest):... » read more
On this activity we are going to migrate a 19c NON-CDB with Encryption/TDE into a 26ai PDB and do the upgrade.Since in 26ai is manadatory to have PDB’s, and YES we could migrade 19c NON-CDB into a 19C CBD reusing the datafiles and do the upgrade inplace, but that would make a rollback more complicated.For... » read more
On this post we are going to go step-by-step through the process of upgrading Oracle Restart from 19c to 26ai. We are going to install here: You can download the Grid Home from here. On Oracle 26ai, ASMFD is not supported, so make sure if you are using it, migrate using this guide. First we... » read more
On this post we are going to upgrade Oracle 12c to 19c on an ACTIVE/PASSIVE setup on Windows Failover Cluster Manager: Server Name DBNAME 12c Oracle Home 19c Oracle Home win-rac1 DBPROD C:\oracle\app\product\12.1.0\dbhome_1 C:\oracle\app\product\19c\dbhome_1 win-rac2 DBPROD C:\oracle\app\product\12.1.0\dbhome_1 C:\oracle\app\product\19c\dbhome_1 This is the current patch level of both 12c and 19c homes (on both nodes!): Its worth... » read more
After client performed a manual upgrade of a DB from 12c to 19c, we noticed we could not update configuration at cluster level and we faced these errors: This is what we did to fix it: