Database Upgrade to 12c Steps Summary [ Definition only]

Upgrading database to 12c steps
=========================
Please read through below metalink documents for upgrading database to 12c:

MOS    #1503653.1 + Upgrade Companion #1462240 + upgrade script 3884522.1
Note 2037154.1 DBMS_STATS.GATHER_DICTIONARY_STATS Fails with "ORA-06502: PL/SQL: numeric or value error: character string buffer too small"
hcheck.sql - Script to Check for Known Problems in Oracle8i, Oracle9i, Oracle10g, Oracle 11g and Oracle 12c (Doc ID 136697.1)       May 2016
Script to Collect DB Upgrade/Migrate Diagnostic Information (dbupgdiag.sql) (Doc ID 556610.1)

In our workplace we are using a single scripts which contains steps below  -- verify into developemnt setup before implementing into working (TEST/QA/PROD)

PreUpgrade Phase:
                1  : Compile invalid objects
                2  : Create script to disable user triggers
                3  : Disable concurrent statistics gathering
                4  : Fix invalid user table data
                5  : Execute Database Health Check script
                6  : Run the new Pre-Upgrade Information Tool
                7  : Check for the integrity of the source database
                8  : Purge the Recyclebin
                9  : Gather dictionary statistics
                10 : Select and save current invalid objects

Upgrade Phase: [ This is based on Dataguard and RAC setup with OEM monitoring in place]
                1  : Create blackout on target
                2  : Disable transport and apply when DG available
                3  : Determine Database Type
                4  : Disable database parameter cluster_database
                5  : Compile invalid objects before upgrade
                6  : Select and save invalid objects before upgrade
                7  : Disable and Stop database with srvctl
                8  : Rotate alert.log before uprade to compare after
                9  : Move database related files to new ORACLE_HOME
                10 : Modify oratab
                11 : Start database in upgrade mode
                12 : Create guaranteed restore point for rollback
                13 : Disable triggers
                14 : Determine and resize fast recovery area if necassary
                15 : Execute catupgrd.sql script to upgrade the database to 12c
                16 : Start database in normal mode again
                17 : Remove deprecated parameters
                18 : Compile invalid objects after upgrade
                19 : Execute post upgrade script utlu121s.sql
                20 : Execute post upgrade script catuppst.sql
                21 : Execute post upgrade diagnostic script dbupgdiag.sql
                22 : Modify CRS database configuration with new ORACLE_HOME
                23 : Modify database parameters after upgrade
                24 : Enable and Start upgraded database from new ORACLE_HOME with srvctl
                25 : Select and save invalid objects after upgrade
                26 : Enable triggers
                27 : Validate APEX installation after upgrade
                28 : Modify EM12c ORACLE_HOME target property
                29 : Stop blackout on target
                30 : Delete blackout on target
                31 : Rotate alert.log after upgrade for comparison
                32 : Create a full backup after the upgrade
                33 : Show database components
                34 : Check invalid objects before and after the upgrade

Then Upgrade Standby:
                1  : Determine Database Type
                2  : Determine standby database open mode
                3  : Remove deprecated parameters
                4  : Disable and Stop database with srvctl
                5  : Move database related files to new ORACLE_HOME
                6  : Modify oratab
                7  : Modify CRS database configuration with new ORACLE_HOME
                8  : Enable and Start upgraded database from new ORACLE_HOME with srvctl
                9  : Stop blackout on target
                10 : Delete blackout on target               

Comments

Popular posts from this blog

Oracle DataGuard – How to resize Redo Log and Standby Redo Log

Exadata - Smart Scan Testing

Exadata Flash Cache - Management