RAC Database upgrade from 12.1.0.2 to 12.2.0.1

Hi There

He is the first attempt to migrate a RAC 12.1.0.2 database to 12.2.0.1 using dbua!

Upgrade of the grid infra to 12.2.0.1 can be seen here

I am choosing ECOM database.

Please keep in mind that the database should run from the node you are initiating the upgrade on.

You can fix and check or execute manually the pre step scripts provided.

Note: All objects in there recycle bin were at PDB level so the purge DDBA_recyclebin has to be execute at the PDB level.

During the upgrade, of course the database goes down!

ora.ecom.db
      1        OFFLINE OFFLINE              Instance Shutdown,STABLE
      2        OFFLINE OFFLINE              Instance Shutdown,STABLE

 

Note: The ECOM database is a simple container database with one PDB create after the installation of the cluster 12.1.0.2 with dbca!

But it takes a lot of time!

Successful but very long time to complete such small database!

Have to figure out why…

Database registration after the upgrade

ora.ecom.db
      1        ONLINE  ONLINE       node1   Open,HOME=/u01/app/oracle/product/12.2.0.1/rdbms,STABLE
      2        ONLINE  ONLINE       node5   Open,HOME=/u01/app/oracle/product/12.2.0.1/rdbms,STABLE

Now I have 12.2.0.1 grid infrastructure with two rdbms homes

  • 12.1.0.2    4 database
  • 12.2.0.1    1 database

Cheers

jko

The following two tabs change content below.

Jacques

I am Oracle Certified Master 11g & 12c database architect with significant experience in heterogeneous environments, and strong ability to lead complex and critical projects requiring multiple technical implementations. at Trivadis SA

Leave a Reply

Your email address will not be published. Required fields are marked *