Oracle database upgrade 11.2.0.3 to 12.1.0

Upgrade Path for Oracle Database to Oracle 12c Release 1 (12.1)

Minimum version of the database that can be directly upgraded to Oracle 12c Release 1 (12.1)

Source DatabaseTarget 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 DatabaseIntermediate Upgrade Path for Target DatabaseTarget 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 11.2.0.1 or 11.1.0.6, then you must first upgrade to Oracle Database 11g Release 2 (11.2.0.2).
  •  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.
  •  For release 9.2.0.8, you must first upgrade to an intermediate Oracle Database release, as follows: 9.2.0.8 -> 11.2.0.2 or 11.2.0.3 -> 12.1
Note:
To locate the patch-id of a patch-set refer to:
Note 438049.1 : How To Find RDBMS patchsets on My Oracle Support
Note 753736.1 : Quick Reference to Patchset Patch Numbers

Upgrading Oracle Database 11.2.0.3 to 12.1.0 steps

 

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:

 

 Server details below

OS : OEL 5.4 (64 bit)
Database : 11.2.0.3 (64 bit)

Note:- Before starting the up-gradation process, take the complete backup of database.

1)Take cold backup of 11.2.0.3 database
[oracle@sujeet ~]$ cd $ORACLE_BASE
[oracle@sujeet oracle]$ ls
admin cfgtoollogs checkpoints diag fast_recovery_area oradata product
[oracle@sujeet oracle]$ cd oradata/

[oracle@sujeet oradata]$ ls
PROD
[oracle@sujeet oradata]$ cd PROD/

[oracle@sujeet PROD]$ ls
control01.ctl redo01.log redo03.log system01.dbf undotbs01.dbf
example01.dbf redo02.log sysaux01.dbf temp01.dbf users01.dbf

[oracle@sujeet PROD]$ cd ..
[oracle@sujeet oradata]$ ls
PROD
[oracle@sujeet oradata]$ cp -R PROD/ PROD_backup

2) Stop the Listener
[oracle@sujeet admin]$ lsnrctl stop PROD
LSNRCTL for Linux: Version 11.2.0.3.0 – Production on 04-DEC-2014 11:32:26 Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=sujeet.oracle.com)(PORT=1521)))

The command completed successfully

3) Create directory structure for 12c ORACLE_HOME
[oracle@sujeet product]$ mkdir -p /u01/app/oracle/product/12.1.0

4) export ORACLE_HOME to 12c
[oracle@sujeet 12.1.0]$ export ORACLE_HOME=/u01/app/oracle/product/12.1.0

5) Copy ( winscp or scp ) 12c software to /home/oracle

6) Launch Oracle 12c runinstaller
[oracle@sujeet database]$ pwd
/home/oracle/database

Note: open new terminal & run xhost + command as a root user before running ./runInstaller 

[oracle@sujeet database]$ ./runInstaller


Un-check “I Wish to receive security updates via My oracle support” and click Next



Click Yes
Select “Skip Software Updates” and click Next.


select “Upgrade an existing database” and click Next


select “Upgrade an existing database” and click Next


Select your language and click Next


Select “Enterprise Edition” and click Next


Fill the details for ORACLE_BASE and software location and click Next


Select the OSOPER grouop (Optional) and click Next


If you satisfy with the summary click Next


 Now Oracle Database 12c installation starts



 
Run the scripts as root user
[root@sujeet ~]# /u01/app/oracle/product/12.1.0/root.sh
Performing root user operation for Oracle 12c
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/oracle/product/12.1.0
Enter the full pathname of the local bin directory: [/usr/local/bin]:
The file “dbhome” already exists in /usr/local/bin. Overwrite it? (y/n)
[n]:
The file “oraenv” already exists in /usr/local/bin. Overwrite it? (y/n)
[n]:
The file “coraenv” already exists in /usr/local/bin. Overwrite it? (y/n)
[n]:
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.

Now product-specific root actions will be performed.

Click OK after completion of running that script.

 [root@sujeet ~]# netca


 Click next
Fill the Listener Name and click Next



 Click Next


Select the port number and click Next




Select No and click Next







 click next


 Click Finish



Now start DBUA (Database Upgrade Assistant)

Select “Upgrade Oracle Database” and click Next




Click Next



 click on that “Pre Upgrade Utility Checks” – severiy



You might see this error, safely ignore this error because this is a test machine.







 Choose Ignore from Action menu and click Next



 Check the file locations and click Next




Select “Configure Enterprise Manager (EM) Database Express and click Next

 

 Click Next


Select listener and click Next



Choose ” I have my own backup and restore strategy” and click Next






Click Finish





Oracle Database upgrade in progress,
Pre-Upgrade steps will complete in seconds but Database Upgrades Steps takes at-least 90 min of time based on your machine performance and post upgrade steps will take just 5 mins.




After finishing all up-gradation steps click on “Upgrade Results”




click “close”

 

After successfully completion of upgradation click “close”



 Oracle Database upgradation from 11g to 12c completed successfully.

Check it out the version of the upgraded database
[oracle@sujeet database]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Thu Jul 4 21:07:50 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 – 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> select banner from v$version;
BANNER
——————————————————————————–
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 – 64bit Production
PL/SQL Release 12.1.0.1.0 – Production
CORE 12.1.0.1.0 Production
TNS for Linux: Version 12.1.0.1.0 – Production
NLSRTL Version 12.1.0.1.0 – Production



 ***********************************END*******************************************


No comments:

ORA-01552: cannot use system rollback segment for non-system tablespace 'TEMP'

 ORA-01552: cannot use system rollback segment for non-system tablespace "string" Cause: Used the system rollback segment for non...