Loading....

Upgrading from 12c Release 2 to 19c using latest AutoUpgrade utility

This note describes the process of upgrading an Oracle 12c Release 2 Non-Container Database to Oracle 19c and also converting the Non-CDB database to a Pluggable Database (PDB). The entire upgrade process is automated using the latest Oracle autoupgrade utility – autoupgrade.jar which is part of the new Oracle 12c database software release as well […]

Oracle 21c AutoUpgrade (Part 2)

This note describes the steps used to upgrade an Oracle 19c Pluggable Database (PDB) to Oracle 21c using the unplug/plug method via the new Autoupgrade utility. Source Container Database: ORCLCDB (19c ) Target Container Database: DB21C (21c ) ################################################################################################### 19c Pluggable Database ORCLPDB1 is hosted in 19c Container Database ORCLCDB ################################################################################################### [oracle@db21c ~]$ . oraenv […]

Oracle 21c AutoUpgrade (Part 1)

This note describes the steps used to upgrade an Oracle 19c database to Oracle 21c as well as convert the 19c Non-CDB database to a Pluggable Database (PDB) hosted in an Oracle 21c Container Database. Source Database: ORCL (19c Non-CDB ) Target Database: DB21C (21c CDB) ########################################################################### Create Auto Upgrade configuration file ########################################################################### [oracle@db21c ~]$ […]

Minimizing downtime for Container and Pluggable Database (CDB and PDB) Upgrades

Oracle 12c Release 2 introduced a number of new features which would help reduce outages required for database upgrades. Multitenancy feature was introduced in Oracle 12.1 and these features introduced in Oracle 12.2 would help significantly in not only reducing the overall duration required for a database upgrade, but also in managing and having more […]

How to perform an Oracle 18c Container and Pluggable Database upgrade using dbupgrade

Shutdown the 12c Release 2 CDB and PDBs   [oracle@host02 bin]$ sqlplus sys as sysdba Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 – 64bit Production SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ———- —————————— ———- ———- 2 PDB$SEED READ ONLY NO 3 PDB1 READ WRITE NO 4 PDB2 READ WRITE NO SQL> […]

Upgrading from Oracle 11gR2 to Oracle 12c using Full Transportable Export and Import

The Transportable Tablespace (TTS) feature was introduced in Oracle 8i and the Cross-Platform Transportable Tablespace (XTTS) feature was introduced in Oracle 10g. Since it only involved the copy of the data files of the tablespace at the OS level and the copy (and maybe conversion) of the data files over the network, it was potentially […]

Social media & sharing icons powered by UltimatelySocial
Back To Top

Add A Knowledge Base Question !

You will receive an email when your question will be answered.

+ = Verify Human or Spambot ?