Home > Linux, Oracle, Redhat > Upgrading Oracle 11.2.0.2 Database to 11.2.0.3

Upgrading Oracle 11.2.0.2 Database to 11.2.0.3

Environment: Oracle 11.2.0.2 database on RHEL 5.8 x86_64
Objective: Oracle 11.2.0.3 database

First, download 11.2.0.3 software from Oracle into a set directory. You man also download Pre-Ugrade script from support.oracle.com, utlu112i_3.sql.

Next, verify your environment prior to the upgrade, as Oracle user:
$env|grep ORACLE
ORACLE_SID=oraopt
ORACLE_HOME=/u01/app/oracle/product/11.2.0/db1
$cat /etc/oratab | grep -v ^#
oraopt:/u01/app/oracle/product/11.2.0/db1:N

The utlu112i_3.sql script may be run when the database is operational.
$sqlplus ‘/as sysdba’
SQL>spool upgrade_11.2.0.3.log
SQL>@utlu112i_3.sql
Oracle Database 11.2 Pre-Upgrade Information Tool 03-14-2012 16:19:44
Script Version: 11.2.0.3.0 Build: 001
.
**********************************************************************
Database:
**********************************************************************
–> name: ORAOPT
–> version: 11.2.0.2.0
–> compatible: 11.2.0.0.0
–> blocksize: 8192
–> platform: Linux x86 64-bit
–> timezone file: V14
.
**********************************************************************
Tablespaces: [make adjustments in the current environment]
**********************************************************************
–> SYSTEM tablespace is adequate for the upgrade.
…. minimum required size: 709 MB
–> SYSAUX tablespace is adequate for the upgrade.
…. minimum required size: 496 MB
–> UNDOTBS1 tablespace is adequate for the upgrade.
…. minimum required size: 400 MB
–> TEMP tablespace is adequate for the upgrade.
…. minimum required size: 60 MB
.
**********************************************************************
Flashback: OFF
**********************************************************************
**********************************************************************
Update Parameters: [Update Oracle Database 11.2 init.ora or spfile]
Note: Pre-upgrade tool was run on a lower version 64-bit database.
**********************************************************************
–> If Target Oracle is 32-Bit, refer here for Update Parameters:
— No update parameter changes are required.
.

–> If Target Oracle is 64-Bit, refer here for Update Parameters:
— No update parameter changes are required.
.
**********************************************************************
Renamed Parameters: [Update Oracle Database 11.2 init.ora or spfile]
**********************************************************************
— No renamed parameters found. No changes are required.
.
**********************************************************************
Obsolete/Deprecated Parameters: [Update Oracle Database 11.2 init.ora or spfile]
**********************************************************************
— No obsolete parameters found. No changes are required
.

**********************************************************************
Components: [The following database components will be upgraded or installed]
**********************************************************************
–> Oracle Catalog Views [upgrade] VALID
–> Oracle Packages and Types [upgrade] VALID
–> JServer JAVA Virtual Machine [upgrade] VALID
–> Oracle XDK for Java [upgrade] VALID
–> Oracle Workspace Manager [upgrade] VALID
–> OLAP Analytic Workspace [upgrade] VALID
–> OLAP Catalog [upgrade] VALID
–> EM Repository [upgrade] VALID
–> Oracle Text [upgrade] VALID
–> Oracle XML Database [upgrade] VALID
–> Oracle Java Packages [upgrade] VALID
–> Oracle interMedia [upgrade] VALID
–> Spatial [upgrade] VALID
–> Expression Filter [upgrade] VALID
–> Rule Manager [upgrade] VALID
–> Oracle Application Express [upgrade] VALID
… APEX will only be upgraded if the version of APEX in
… the target Oracle home is higher than the current one.
–> Oracle OLAP API [upgrade] VALID
.
**********************************************************************
Miscellaneous Warnings
**********************************************************************
WARNING: –> Your recycle bin is turned on and currently contains no objects.
…. Because it is REQUIRED that the recycle bin be empty prior to upgrading
…. and your recycle bin is turned on, you may need to execute the command:
PURGE DBA_RECYCLEBIN
…. prior to executing your upgrade to confirm the recycle bin is empty.
WARNING: –> Database contains schemas with objects dependent on DBMS_LDAP package.
…. Refer to the 11g Upgrade Guide for instructions to configure Network ACLs.
…. USER APEX_030200 has dependent objects.
.
**********************************************************************
Recommendations
**********************************************************************
Oracle recommends gathering dictionary statistics prior to
upgrading the database.
To gather dictionary statistics execute the following command
while connected as SYSDBA:

EXECUTE dbms_stats.gather_dictionary_stats;

**********************************************************************
Oracle recommends reviewing any defined events prior to upgrading.

To view existing non-default events execute the following commands
while connected AS SYSDBA:
Events:
SELECT (translate(value,chr(13)||chr(10),’ ‘)) FROM sys.v$parameter2
WHERE UPPER(name) =’EVENT’ AND isdefault=’FALSE’

Trace Events:
SELECT (translate(value,chr(13)||chr(10),’ ‘)) from sys.v$parameter2
WHERE UPPER(name) = ‘_TRACE_EVENTS’ AND isdefault=’FALSE’

Changes will need to be made in the init.ora or spfile.

**********************************************************************
SQL> EXECUTE dbms_stats.gather_dictionary_stats;
SQL> exit

Now, begin install new Oracle home, followed by upgrade. You should now be in the location of 11.2.0.3 sofware of database directory.
$./runInstaller &
When dialogue asks, specify “Install Database Software only” and change your location of installation to:
/u01/app/oracle/product/11.2.0/db2

Run through the rest of the installation till completion and run the root.sh at the end.

Now, begin Upgrade portion:
$export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db2
$export PATH=$ORACLE_HOME/bin:$PATH
$which dbua
/u01/app/oracle/product/11.2.0/db2/bin/dbua
./runInstaller

Dialogue will now ask you which db to upgrade. Select your db and click Next. There will be warnings given similar to the Pre-Ugrade script. Take care of those warnings prior to the upgrade. You should back up your db before the upgrade as well, in case there are any problems. There is an opportunity to do so in the GUI. DBUA will shutdown the database server and do what is necessary for the upgrade.

When upgrade is done, click OK, and Upgrade Results will be shown. Review the summary and click Close. The output concludes the upgrade process:
Database upgrade has been completed successfully, and the database is ready to use.
The following document describes important behavioral changes from previous database releases:
/u01/app/oracle/product/11.2.0/db2/assistants/dbua/doc/DefaultBehaviorChanges.html

Note, the db will have been restarted for you. Make sure your “opatch” is of the lastest version as well. Ensure your .bash_profile, .profile is now updated with the new ORACLE_HOME. Verify /etc/oratab also shows your new ORACLE_HOME:
oraopt:/u01/app/oracle/product/11.2.0/db2:N

$ which opatch
/u01/app/oracle/product/11.2.0/db2/OPatch/opatch

SQL> select * from v$version;

BANNER
——————————————————————————–
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
PL/SQL Release 11.2.0.3.0 – Production
CORE 11.2.0.3.0 Production
TNS for Linux: Version 11.2.0.3.0 – Production
NLSRTL Version 11.2.0.3.0 – Production

Categories: Linux, Oracle, Redhat
  1. October 16, 2013 at 5:52 pm

    Perfect one. Thanks for posting.

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: