Upgrading to Oracle Database 12c Release 1 (12.0.1.2) using DBUA

Upgrading to Oracle Database 12c Release 1 (12.0.1.2)

This article provides an overview howto upgrade existing databases to Oracle 12c Release 1 .

 

Supported Upgrade Paths

 

The upgrade path for going to Oracle Database 12c (12.1.0.1) is pretty straightforward.

 

The matrix below represents the direct upgrade possibilities:

Source Database	Target Database
10.2.0.5	12.1.x
11.1.0.7	12.1.x
11.2.0.2 or higher	12.1.x

 

The following database versions will require an indirect upgrade path:

Source Database		Intermediate Upgrade Path for Target Database		Target Database
11.2.0.1	---->	11.2.0.2 or higher	---->	12.1.x
11.1.0.6	---->	11.1.0.7 or 11.2.0.2 or higher	---->	12.1.x
10.2.0.4 (or earlier)	---->	10.2.0.5 or later direct upgrade version	---->	12.1.x
10.1.0.5 (or earlier)	---->	10.2.0.5 or later direct upgrade version	---->	12.1.x
9.2.0.8 (or earlier)	---->	9.2.0.8 --> 11.2.0.2 or higher	---->	12.1.x

For example:

• If you are upgrading from 10.2.0.2, 10.2.0.3, 10.2.0.4, or 10.1.0.5, then you must first upgrade to 10.2.0.5 or later.´

Database Upgrade Assistant (DBUA)

Database Upgrade Assistant (DBUA) interactively steps you through the upgrade process and configures the database for the new Oracle Database release. The new 12c DBUA has some new features:

• DBUA Can Be Restarted During the Upgrade Process
• New Pre-Upgrade Information Tool
• Enhanced Pre-Upgrade and Post-Upgrade Summary Report
• Activity log and Alert log can be invoked from DBUA to monitor upgrade progress
• Oracle Grid Infrastructure Upgrade Enhancements
• Pluggable Databases
• Oracle XML Database is Installed When You Upgrade

To use the DBUA we have to go to the Oracle Home Database 12c ( see howto installation oracle database12c) and start it by running dbua

 

#/opt/oracle/12.1.0.2/bin/dbua

Step 1. Select Upgrade and click next.

Step 2. The DBUA will give us all database associated with the Oracle Home and Database version.
    Select the database to upgraded and click next.

Step 3. The DBUA will run preupgrd.sql and give us the result back to GUI. We can fix directly from the GUI.

Step 4.  This is a upgrade option step. At this step we can select that the upgrade can done in paralell. Additionally, we can recompile the invalid object during upgrade, or upgrade timezone, etc.. click next to continue

Step 5. We can create the Enteprise Manager or register the database with EM Cloud Control. Click next.

Step 6.  allows us to move the database files or Fast Recovery Area during upgrading.

Step 7. One or more listeners from the source Oracle home can be migrated to the new upgraded Oracle home

Step 8.  We can create the new backup of the database before upgrading or we can tell DBUA that we have already the own backup.

Step 9 gives us the upgrade summary .

Step 10. This is an upgrade progress. The Activity log and Alert log can be invoked from DBUA to monitor upgrade progress

Step 11. Check the upgrade results, then click the "Close" button to exit the DBUA.

Verify the Upgrade

#sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Mon Sep 1 16:48:02 2014

Copyright (c) 1982, 2014, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
and Real Application Testing options

SYS:TESTDB> select name, open_mode from v$database;

NAME                                               OPEN_MODE
-------------------------------------------------- --------------------
TESTDB                                             READ WRITE

Share :

Tweet

Related Post