We can upgrade an oracle database using OEM 12c cloud control also. 

Here I will show how to upgrade database from 12.1.0.1 to 12.1.0.2 . 

Note - Make sure that 12.1.0.2 ORACLE_HOME is installed. 

SOURCE ORACLE_HOME(12.1.0.1) - /oracle/app/oracle/product/12.1.0

TARGET ORACLE_HOME(12.1.0.2)  - /oracle/app/oracle/product/12.1.0.2_CRM/dbhome_1

 

Enable Flashback:

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;

System altered.

SQL> alter system set db_recovery_file_dest=-/archive/oradata/B2BCRMT3/arch/FRA- scope=both;

System altered.

SQL> alter database flashback on;

Database altered

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

3. AUDIT_FILE_DEST=/oracle/app/oracle/admin/B2BCRMD1/adump

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

@$ORACLE_HOME/rdbms/admin/utlrp.sql

 

SEE ALSO:

Upgrade database from 11g to 12c manually

upgrade CLOUDORACLE 12C


Related Topics

EMCLI command - OEM 12C
How to change sysman password for oracle 12c cloud control
Add database as target oracle 12c cloud control
Generate custom report from OEM cloud control
Upgrade database using OEM 12C cloud control
Deinstall Management Agents Oracle 12c cloud control
Apply database patch from OEM Cloud control
Install oracle enterprise manager cloud control 12c
Blackout targets in OEM 12c cloud control
Change dbsnmp password for target db in oem 12c

You May Also Like

ERROR: No checkpoint table specified for ADD REPLICAT
Hive installation with mysql database
Flashback primary database in dataguard environment
ENABLE_PARALLEL_DML hint in oracle 12c
How to setup dataguard broker configuration (DG broker) in 12c
How to change the case (Lower to Upper and Vice Versa) in R
Ansible script to run script on remote server and fetch the output
Shell script for monitoring Alert log
Blackout targets in OEM 12c cloud control
LREG Background Process in oracle

From This Website

How to flashback a Pluggable database ( PDB) in oracle 12.2
How to move spfile from file system to ASM in RAC
How to setup dataguard broker configuration (DG broker) in 12c
Useful TFACTL commands
sec_case_sensitive_logon parameter in oracle
ORA-16855: transport lag has exceeded specified threshold
FLASHBACK parameter in DATAPUMP(EXPDP)
ORA-20101: TABLESPACE is not a ASSM (Automatic Segment Space Management) tablespace
Generate custom report from OEM cloud control
SKIP_CONSTRAINT_ERRORS as DATA_OPTION in impdp