DBAHUB: Upgrade CDB_PDB from 12101 to 12102 using OUI

Upgrade the oracle12c Multitenant architecture database from 12101 to 12102. This method here is to upgrade the CDB and PDB in one go during 12102 installation process. This method can be used where it was decided by business / Application owner to take all the attached PDB’s in CDB to the new patchset level not the individual PDB’s.

This method installs the 12102 binaries and at the same time will upgrade the database [CDB and attached PDB’s]. In the middle of installation it will invoke DBUA. At the same time it will verify the environment and will ask for the information for upgrade to new environment.

Test Environment
=============

CDB Databases

	Source Database	Target Database
Name:	CDB12101	CDB12101
Release:	12.1.0.1.0	12.1.0.2.0
Oracle Home:	d:\ora12c\ora_12101	D:\ORA12C\ora_12102

Pluggable Databases

Pluggable Database	Source Version	Target Version
PDB_12101	12.1.0.1.0	12.1.0.2.0

Source Setup 12.1.0.1.0 status
=======================

Before we start the upgrade lets gather some information of the existing environment. Below screenshots tells some information for the existing environment like CDB and PDB Container ID, status and running mode.

4. Invoking OUI

We can invoke the OUI form the database folder created due to the extract operation on downloaded file from oracle e-delivery. It will take you to the Oracle Database 12c Release 1 Installer steps.

5. Configure security Update

Here you need to provide the email address and MOS for security Alerts. You may skip this if you do not want this to be updated by MOS.

6. Select Installation Option

Here you can mention to upgrade the existing environment. Which will install and upgrade the existing environment.

7. Language Selection

8. Database Edition Selection

Here you have a choice to the database edition you want to install depending on the license purchase. At least keep 10gb space for the installation to be on the safer side.

9. Oracle Home user

As this is the Windows environment you have to select the windows admin user to manage the oracle home

10. Prerequisite check

Some Checks will be performed as swap , Disk space before the real installation begins.

11. Installation Summery

The summery of global settings will be provided to make any changes before the installation process begins.

12. Install process…

13. Net CA

A network Configuration assistance will be invoked to make a necessary network selection and configuration.

14. DBUA

This is the point some ware around 88% of installation the DBUA will be invoked to verify and upgrade the existing environment [CDB and PDB].

15. Selecting the CDB

It will give and option to select the CDB we want to upgrade as a part of installation of 12102.

16. PDB Selection

Once the CDB is selected the Upgrade process will look for the PDBs attached to the CDB for upgrade. It will give you an option to select the PDB’s you want to upgrade.

17. Prerequisite Check

So checks will be done by the upgrade utility before actual upgrade starts for CDB and PDB. Like if there are possible errors and warnings in existing setup to be fixed before upgrade.

18. Upgrade options

The Utility will provide the option to select the upgrade and recompile parallelism for upgrade and if any scripts need to be run before or after upgrade.

19. OEM Configuration

Here we can select the OEM or we can register this Multitenant architecture to Oracle Cloud control.

20. Move Files during upgrade

If the file location needs to be moved for the upgraded database which normally a DBA does. Upgraded database files can reside in new home directory rather than the same old place.

21. Listener Selection

Select the listener where the Database need to be registered.

22. Backup the database

We can choose the backup strategy before the upgrade of the Multitenant architecture.

23. Upgrade Summery

The final summery window will give you the global settings for the upgrade and the last option before you want to push the upgrade process

24. Upgrade Progress

25. Upgrade results

After above once the upgrade process is finished for DCB and PDB we can check the upgrade result by clicking the upgrade result tab. Or we can login to the database and run few queries for the verifying if all is done as intended

26. Finish

And finally the Multitenant Architecture database is moved to new patch set i.e. 12102

Upgrade Results

Database upgrade has been completed successfully, and the database is ready to use.

	Source Database	Target Database
Name:	CDB12101	CDB12101
Release:	12.1.0.1.0	12.1.0.2.0
Oracle Home:	d:\ora12c\ora_12101	D:\ORA12C\ora_12102

Pluggable Databases

Pluggable Database	Status	Version
PDB_12101	NORMAL	12.1.0.2.0

Pre-Upgrade Checks

Warnings

Oracle Application Express (APEX) can be manually upgraded prior to database upgrade.

Upgrade Details

The following summary lists the steps performed during the upgrade process. Log files for all the steps, as well as this summary, are available at "D:\ORA12C\cfgtoollogs\dbua\cdb_12101\upgrade1".

Step Name	Log File Name	Status
Pre Upgrade	PreUpgrade.log	Successful
CDB Root RDBMS Upgrade	CDBRootOracle_Server.log	Successful
CDB Root Post Upgrade	CDBRootPostUpgrade.log	Successful
PDBS RDBMS Upgrade	PDBSOracle_Server.log	Successful
PDBS Post Upgrade	PDBSPostUpgrade.log	Successful
Collecting information from database	CloneDataGatheringStep.log	Successful
Modifying and starting Oracle instance	CloneInstanceStep.log	Successful
Copying database files	CloneRmanCopyStep.log	Successful
Switching database files	CloneDatabaseSwitchStep.log	Successful
Generate Summary	generateSummary.log	Successful