Here I would be discussing how to upgrade Oracle 11gR2 (11.2.0.4) database to Oracle 12cR2 (12.2.0.1) on the same server. This upgrade process was done on Linux 6 (x86_64). I used DBUA (Database Upgrade Assistant) to perform this upgrade. DBUA is also a recommended way to perform the upgrade as it would automate almost everything for you. You should be able to use same method to upgrade 11.2.0.4 database on other OS platforms.

Direct upgrades to 12cr2 are possible from existing databases with versions 10.2.0.5+, 11.1.0.7+, or release 11.2.0.2+. Upgrades from other versions are supported only via intermediate upgrades to a supported upgrade version.

As 12c has introduced multitenant architecture in which you can either have a non-container (non-CDB) database or a container database. Every 12c upgraded database becomes a non-CDB (same as pre-12c) after the upgrade and then either you can keep using this existing non-CDB database, and plug into a container database (on the same server or a separate server).

Make sure the database is started and run the database upgrade assistant with 12cR2 home.

[oracle@oracle122 ~]$ export ORACLE_HOME=$ORACLE_BASE/product/12.2.0.1/db_1
[oracle@oracle122 ~]$ export PATH=$ORACLE_HOME/bin:$PATH
[oracle@oracle122 ~]$ dbua

Initiate DBUA, click Next Initiate DBUA

My 11g database “orcl” is already selected,

Enter SYS username :SYS

Password: ***

click Next

During Prerequisite Checks there are some warning as shown below

Select the warning the from the wizard and click on more details

Perform the steps provide by installer, to get rid of from the warnings.

In 12c, we need to remove OLAP catalog.

Perform the below step to remove OLAP component.

Click on Check Again , still we have purge the RecycleBin.

Below are the information for Post Upgrade Recommendations. We can make it a note on that and click Next

Check the operation performs during upgrade.

If upgrade failure happened then we must have Rman backup or Flashback Point.

Select the running Listener, If you want to upgrade listener configuration.

To setup OEM in 12cr2, in my case I am not using OEM cloud

Click Finish to start the upgrade process

Monitor the progress

Once done, you can click on “Show Results” to see detailed output of the upgrade process.

Now we are going to perform Post Upgrade Steps.

Now connect with upgrade database through sqlplus

[oracle@oracle122 ~]$ export ORACLE_HOME=$ORACLE_BASE/product/12.2.0.1/db_1
[oracle@oracle122 ~]$ export PATH=$ORACLE_HOME/bin:$PATH
[oracle@oracle122 ~]$ sqlplus / as sysdba

For More Info: Click here

Comments

    1. Skant Gupta Article Author

      Check the image number 3, Select the warning the from the wizard and click on more details.

      DBUA, shows you warning and action required same as given by preupgrade tool

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.