My Oracle Support Banner

ODA Upgrading a Database from an Existing 11.2.0.4 Home to an Existing 12.1.2.x Home (Doc ID 2315655.1)

Last updated on SEPTEMBER 16, 2021

Applies to:

Oracle Database Appliance X6-2 HA Hardware - Version All Versions to All Versions [Release All Releases]
Oracle Database Appliance X5-2 - Version All Versions to All Versions [Release All Releases]
Oracle Database Appliance Software - Version 2.2.0.0 to 12.1.2.9 [Release 2.2 to 12.1]
Oracle Database Appliance - Version All Versions to All Versions [Release All Releases]
Oracle Database Appliance X3-2 - Version All Versions to All Versions [Release All Releases]
Information in this document applies to any platform.

Goal

The ODA uses oakcli commands* for most administration including
the creation, update, upgrade and deletion of databases.

Using manual database creation scripts, using DBCA or DBUA directly is not recommended.
ODA provided patched Clones should be used for creation and upgrades: See note 888888.1 for more information

This is an example of upgrading the database from one version to a higher version:
  •   from  Version 11.2.0.4.170418 to 12.1.0.2.170418
  •   from  <OLD_DB_HOME_NAME>      to <NEW_DB_HOME_NAME>

* ODA HW versions V1, X3-2, X4-2, X5-2 X6-2 HA
   ODA X6-2S, X6-2M, X6-2L, X7-2S and X7-2M use oda*cli commands versus using oakcli

Pre-requisites

Databases and homes created using oakcli create commands.

Comment

While the target home in this example does show an existing database, having a database in the target home is not required.
However, for debugging purposes it is recommended to pre-create the target home with a sample RAC database to confirm the target binaries and home on both nodes work as expected.
- The RAC database can be removed after confirming the database functions as expected on each node.
The example will also show steps for removing a database


Diagnostics Collection

The example will also include steps for collecting diagnostics to review after a successful or a failed upgrade.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Goal
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.