11.2.0.3 to 12.1.0 (Oracle 12c) upgrade

http://oracle4ryou.blogspot.com/2013/07/11203-to-1210-oracle-12c-upgrade.html

Upgrading Oracle Database 11.2.0.3 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 (11.2.0.3) (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)

Share: