RAC Database upgrade from 12.1.0.2 to 12.2.0.1

Hi There
He is a migration of 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!
[code language=”sql”]
ora.ecom.db
1 OFFLINE OFFLINE Instance Shutdown,STABLE
2 OFFLINE OFFLINE Instance Shutdown,STABLE
[/code]
 

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
[code language=”sql”]
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
[/code]
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


     

Leave a Reply

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