Example of upgrading Oracle 11.2.0.1 to 11.2.0.3

Upgrade a single Oracle 11.2.0.1 instance to 11.2.0.3. Oracle upgrades are similar. Upgrade Oracle software and then Oracle instance.

The patchset No of Oracle 11.2.0.2 is 10098816. For details about this Patchset, refer to the following link:

Oracle 11.2.0.2 Patch description

The Patchset no of Oracle11.2.0.3 is: 10404530 ,:

Oracle 11.2.0.3 Patchset

Patchset has seven files. For details about the functions of these seven files, refer:

Roles of different Oracle 11gR2 Patchset files

We only need the first and second files to upgrade the database. Decompress the two files and copy the content of the second file to the corresponding directory of the first file. Merge two files into one file.

 

1. View DB-related information

 

We installed a 64-bit DB.

 

[Oracle @ dave ~] $ Sqlplus/as sysdba;

 

SQL * Plus: Release 11.2.0.1.0 Production onWed Sep 28 10:23:51 2011

 

Copyright (c) 1982,200 9, Oracle. All rights reserved.

 

 

Connected:

Oracle Database 11g Enterprise EditionRelease 11.2.0.1.0-64bit Production

With the Partitioning, OLAP, Data Miningand Real Application Testing options

 

SQL> select name from v $ database;

 

NAME

---------

ANQING

Check whether Oracle is 32-bit or 64-bit

Ii. Upgrade instructions

2.1 description of Patchset

This part of content is copied from the readme document of patchset.

Oracle Databasepatch set, release 11.2.0.3 (11.2.0.2) is a full installation of the Oracle Database software. this meansthat you do not need to install Oracle Database 11g Release 2 (11.2.0.1) before installing Oracle Database 11g Release 2 (11.2.0.3/11.2.0.2 ).

The patchset of Oracle 11.2.0.2 and 11.2.0.3 are both complete installation packages. Therefore, it can be directly used for installation.

Note the following changes with the newpatch set packaging:

(1) Newinstallations consist of installing the most recent patch set, rather thaninstalling a base release and then upgrading to a patch release.

(2) Directupgrades from previous releases to the most recent patch set are supported.

(3) Out-of-placepatch set upgrades recommended, in which you install the patch set into a new, separate Oracle home. In-place upgrades are supported, but not recommended.

2.1.1 In-Place Upgrade

This feature enablesyou to upgrade an existing installation of Oracle database to Oracle Database11g Release 2 (11.2.0.3) into the same Oracle home directory by replacingthe existing database files. the patch set application requires more downtimeand is not recommended. this upgrade type requires less disk space.

Install the upgrade file to the original Oracle home Directory, which saves disk space, but requires more downtime. This is not recommended.

 

2.1.2 Out-of-Place Upgrade

This featureenables you want to install Oracle Database 11g Release 2 (11.2.0.3) in a new, separate Oracle home directory. after the installation is complete, the datafrom the database in the old Oracle home directory is migrated to the databasein the new Oracle home directory.

The new OracleHome directory installed on the Oracle Database can be migrated to the new Oracle homedirectory after the installation is complete.

Out-of-placeupgrade process is similar to Oracle database upgrade from one version toanother and is the recommended type. the benefits of this upgrade type is thatthe patch set application requires much less downtime, and is safer when thepatch set application must be aborted. this upgrade type requires more diskspace to accommodate two Oracle home directories simultaneously.

This method is recommended by oracle, which can reduce the downtime and be safer. However, this method requires two times of space, but this space is nothing compared with the current hard drive for cabbage. 

2.2 upgrade steps

Oracle 10g Readme has detailed upgrade steps, but 11g Readme does not have detailed upgrade instructions, need to refer to the official documentation.

See Oracle 10g upgrade from10.2.0.1 to 10.2.0.4

(1) back up the database

(2) Run patchset and Upgrade oracle software

(3) prepare a new ORACLE_HOME

(4) Run dbua or script to upgrade the instance

(5) Check the updated version information and invalid objects.

Official website address:

Upgrading to theNew Release

Http://download.oracle.com/docs/cd/E11882_01/server.112/e23633/upgrade.htm#i1011372

I am also upgrading a single instance here, which is relatively simple. If it is a RAC upgrade, it is estimated that it will be a little harder. The 11gR2RAC upgrade will continue testing later.

Iii. Specific upgrade operations

3.1 back up the database

I am in a test environment and will not back up the data. If it is in a production environment, remember to back up the data first and then operate it.

For In-Place Upgrade, back up the entire ORACLE_HOME directory. If there is a problem with the upgrade, you can restore it back.

The focus is on the following directories:

ORACLE_HOME/dbs

ORACLE_HOME/network/admin

ORACLE_HOME/hostname_dbname

ORACLE_HOME/Solaris/j2ee/OC4J_DBConsole_hostname_dbname

3.2 Upgrade Oracle database software

Run the runInstaller of the Patchset.

 

Note: here we select the third option, skip software update, because our patchset has been downloaded. If we select the second option, the following error will occur,

1 2 3 4 5 Next Page