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
From Oracle database 23ai/26ai, flashback logs can be stored outside the fast recovery area. This allows us to place flashback database logs on different storage, and means they are not competing for space with the rest of the contents of the fast recovery area. First we need a directory to place logs: Set destination and... » read more
On this activity we are going to create a DB in silent mode on a single server with ASM (GRID). That’s it! For a list of 26ai articles, go to HERE
On this activity we are going to install the sample schemas on a 26ai DBFirst we need to download file from here: https://docs.oracle.com/en/database/oracle/oracle-database/26/comsc/installing-sample-schemas.html unzip and go to directory you want to install: Connect to the PDB and run the install (it will ask for HR password): That’s it! For a list of 26ai articles, go... » read more
On this activity we are going to install Oracle 26ai on premises (on a virtualbox server) Create direcories and unzip software We are going to use this response file: Run Install: ROOT SCRIPT: Check logs for errors and done! On every new install, I like to add en “dummy” entry on /etc/oratab for an easy... » read more
List of all the articles I created for Oracle 23ai/26ai.
After a very, very long wait, finally onpremises has been released.As a starting point, we are on a Oracle Linux 8.10 (x86_64) server on kernel 5.15.0-316.196*, with at least 16G of swap. Lets install few bits and reboot: Make sure oinstall has assigned oracle in /etc/group file. This might not give you any issues on... » read more