to 12.1.0 (Oracle 12c) upgrade

Upgrading Oracle Database to 12.1.0 (Oracle 12c)

There are different ways of upgrading to the latest release of Oracle database and
 Oracle provides multiple methods to upgrade. Few are listed below:
  • Database Upgrade Assistant (DBUA)
  • Manual Upgrade
  • Transportable Tablespaces
  • Datapump export/import
  • Oracle Streams
  • Oracle GoldenGate
I chose DBUA to upgrade my test database as it was the simplest and quickest of all. 
Below are the database environment details prior to upgrade:

Oracle Database Version:             Oracle Database 11gR2 ( (64-bit)
Operating System:                         Oracle Enterprise Linux 6.1 (64-bit)

To begin the upgrade process, I copied Oracle 12c software to the database server and
 did the following
  1. Backup Oracle database
  2. Stop the database
  3. Stop listener
  4. Change ORACLE_HOME environment variable in the bash profile of “oracle” user
  5. Launch Oracle 12c Installer (./runInstaller)

You will see the following screen: 

 Well, that's it. My database is now upgraded to Oracle Database 12c.

SQL> select * from v$version;

---------------------------------------------------------------------------- ----------
Oracle Database 12c Enterprise Edition Release - 64bit Production       0
PL/SQL Release - Production       0
CORE Production       0
TNS for Linux: Version - Production       0
NLSRTL Version - Production       0


I am sure you would like to look for alternative and near zero downtime database upgrade approaches to upgrade your production databases. Here are few of the helpful links in this regard:


  1. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.


Note: Only a member of this blog may post a comment.