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
While working on an Oracle RAC Grid upgrade from 19c to 26ai, the last steps are failing if you don’t have properly set up DNS and Chrony server.Probably on your real production enviroment you won’t have this problem, but if you are testing stuff on your on lab, here is what I did. On my... » 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 activity we are going to migrate a 19c NON-CDB 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 that... » 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
Since Oracle 26ai does not support Oracle Filter Drive, this is the process of migrating from ASMFD to ASMLIB v3. This is the high level plan we are going to follow: 1. Verify AFD disks 2.Verify compatible parameter (Oracle recommends compatible.rdbms >= 12.2.0.1.0) 3. crsctl stop has 4. acfsload stop 5. asmcmd afd_deconfigure 6. Install... » read more
On a new installation where we have already HAS/GI running and with patch level: We had this error while creating a new DB: Confusing, right? Now let’s check the dbca log: So the fix in this case: After this, we can create DB’s without issues. Post Views: 1,710
Few days ago we ran on RMAN a few deleted of expired archive logs/backups and all was clear under RMAN.However, when we ran a level 0 backup, we kept receiving failures with this: We checked and FRA was almost free. Diskgroup usage also almost free. RMAN did not have anything expired. But digging a bit... » read more
On a Single Instance Standalone Database, If you want to stop/start everything that runs on a ORACLE_HOME, you can run this: But why sometimes it does nothing? Well.. .this is where the magic of N or Y at the end of the line in /etc/oratab. Just change to Y and process will stop/start DB and... » read more