Database Upgrade From 11202 to 12101 Using DBUA

Written By askMLabs on Tuesday, February 25, 2014 | 10:10 AM

In this article, i am going to explain the single standalone database upgrade from 11202 version to latest 12c (12101) version using DBUA.

When we use DBUA to upgrade your database, most of the upgrade tasks are automated.
The outlined action plan to upgrade database is given below, but all steps mentioned below are explained in detail in the video.

1. Verify all the components status

set pagesize500
set linesize 100
select substr(comp_name,1,40) comp_name, status, substr(version,1,10) version from dba_registry order by comp_name;

2. Run dbupgdiag.sql : Note 556610.1
3. Disable the custom triggers that would fire before/after DDL and enable them after the upgrade is complete.
4. Take database backup.
5. Install database 12c software only installation in a new oracle home.
6. Copy preupgrd.sql file from new 12c home created in step 5 to any temporary location and run this script. This script creates two fixup scripts. Review those fixup scripts ( This step is optional ) - DBUA runs this step.
7. Check invalid objects and run utlrp.sql script if you have any invalids
8. Verify the time zone. Oracle database 12c brings time zone file 18. So you have the option, either you can upgrade time zone after completing database upgrade or during the database upgrade. Note 1522719.1
9. Gather optimizer statistics
10. Disable database vault Note 453902.1
11. Truncate audit records ( to avoid hanging issues while upgrading)

SQL> truncate table sys.aud$;
SQL> truncate table sys.fga_log$;

12. Remove oem database control if you have configured in your environment.

sql> connect / as sysdba
sql> spool emremoval.log
sql>@emremove.sql
sql> spool off

13. Unset ORACLE_HOME and invoke DBUA from the 12c binaries installed in step5.
14. Complete the upgrade database.
15. Verify for any invalid objects and run the utlrp.sql
16. Check if you have any special instructions specific to your environment and complete all the steps.
17. Post upgrade verification steps :

set pagesize500
set linesize 100
select substr(comp_name,1,40) comp_name, status, substr(version,1,10) version from dba_registry order by comp_name;
select substr(object_name,1,40) object_name,substr(owner,1,15) owner,object_type from dba_objects where status='INVALID' order by owner,object_type;
select owner,object_type,count(*) from dba_objects where status='INVALID' group by owner,object_type order by owner,object_type ;
select name,user,created,CDB,CON_ID,CON_DBID from v$database;
select instance_name,status from v$instance;
SELECT version FROM v$timezone_file;
SELECT dbms_xdb_config.gethttpsport FROM dual;
https://<database-ip>:5500/em

Logfile for upgrade are located : $ORACLE_BASE/cfgtoollogs/$ORACLE_SID

Please watch the video for more details on database upgrade from 11202 to 12101 using DBUA.

NOTE : This video is created with audio. Due to some technical issues, the audio is not recorded properly. Reference : 1516557.1

Hope this helps

SRI

Share this article :

askMLabs