Infrastructure at your Service

All Posts By

Alain Fuhrer

Alain Fuhrer

Magic Upgrade to 21c with Replay Upgrade Feature

By | Database Administration & Monitoring | No Comments

Last week I did some upgrade tests from 19c to 21c. The plan was to copy a 19c PDB to a CDB 21c using Online Clone and then upgrade it to 21c. I have done this many times for 19c as well and just wanted to verify that it still worked with 21c. Clone PDB to 21c CDB Since it is a LAB, I gave the user SYSTEM in the CDB19c the appropriate duplicate permissions…

Read More
Alain Fuhrer

After startup database with srvctl, sqlplus as sysdba results in ORA-12547: TNS:lost contact

By | Database Administration & Monitoring, Oracle | One Comment

A few days ago a customer called me, that he have a strange issue with a new created database in a oracle restart configuration with 19c. Problem The customer has patches his 19c Databases with the newest RU and afterwards he get some strange issues in the oracle Restart integration. The Tasks that were done are Install new Oracle Home (u01/app/oracle/product /19.0.0/dbhome_1) Patch new Oracle Home with newest RU for 19c stop database modify oracle…

Read More
Alain Fuhrer

Auto Upgrade of non CDB to PDB with autoupgrade.jar in Oracle 21c

By | Database Administration & Monitoring, Database management, Oracle | No Comments

Since Oracle 21c it is possible to convert the non CDB database into a PDB directly during the upgrade using the Oracle Autoupgrade Tool. This is an important enhancement, because with Oracle 21c the non CDB architecture is desupported, which means that with an upgrade to 21c a conversion is mandatory. Let’s test if this new feature really works and what needs to be considered. Work done by autoupgrade utility Check and Prepare Source non…

Read More