We can upgrade an oracle database using OEM 12c cloud control also.
Here I will show how to upgrade database from 188.8.131.52 to 184.108.40.206 .
Note - Make sure that 220.127.116.11 ORACLE_HOME is installed.
SOURCE ORACLE_HOME(18.104.22.168) - /oracle/app/oracle/product/12.1.0
TARGET ORACLE_HOME(22.214.171.124) - /oracle/app/oracle/product/126.96.36.199_CRM/dbhome_1
Before starting the upgrade, Enable flashback in the database, so that we can create a restore point during the upgrade, And if upgrade fails, we will be able to restore the database to before upgrade stage.
SQL> alter system set db_recovery_file_dest_size=10G scope=both;
SQL> alter system set db_recovery_file_dest=-/archive/oradata/B2BCRMT3/arch/FRA- scope=both;
SQL> alter database flashback on;
Go to the HOMEPAGE of the database, which need to be upgraded.
ORACLE DATABASE -> PROVISIONING - > UPGRADE DATABASE
Provide sys password and select the NEW ORACLE_HOME:
This step will do the precheck . Please take necessary action for the Validation results and retry the precheck.
As precheck is cleared, lets proceed with upgrade settings
1. DEGREE OF UPGRADE PARALLELISM - 4
2. DIAGNOSTIC DESTINATION - /oracle/app/oraclec
4. In Backup Restore section, select Use of guarantee restore point
5. De-select compilation of invalid object , as we will run utlrp.sql, once upgrade is completed.
We can start the upgrade Immediately or schedule it for Later.
Submit the upgrade job
Monitor the upgrade job :
Upgrade has been completed succcessfully.
Now run utlrp.sql script to compile all the object
Upgrade database from 11g to 12c manually
upgrade CLOUDORACLE 12C