Upgrading 10gR2 Database Instance to 11gR2 Database Instance

Upgrading 10gR2 Database Instance to 11gR2 Database Instance

STEP 1: Install The Software:


First download and install oracle 11g R2. Execute runInstaller to install “SOFTWARE ONLY” option.


NOTE: DO NOT SHUTDOWN DATABASE BEFORE RUNNING DBUA.




STEP 2: Run Pre-Upgrade Information tool


The software was installed under “/ultimus/oracle/product/11.2.0/db_1″ location. Once the software is installed, then go to location $ORACLE_HOME/rdbms/admin and copy  utlu112i.sql script to /tmp directory. Now login to 10g database “/ as sysdba” and startup the 10g database, then:

SQL > spool /tmp/upgrade.spl

SQL > @/tmp/utlu112i.sql

SQL > spool off

The output should look something like this:

Oracle Database 11.2 Pre-Upgrade Information Tool    

.

**********************************************************************

Database:

**********************************************************************

--> name:          ORCL10G

--> version:       10.2.0.3.0

--> compatible:    10.2.0.3.0

--> blocksize:     8192

--> platform:      Linux IA (32-bit)

--> timezone file: V3

.

**********************************************************************

Tablespaces: [make adjustments in the current environment]

**********************************************************************

--> SYSTEM tablespace is adequate for the upgrade.

.... minimum required size: 724 MB

.... AUTOEXTEND additional space required: 244 MB

--> UNDOTBS1 tablespace is adequate for the upgrade.

.... minimum required size: 464 MB

.... AUTOEXTEND additional space required: 439 MB

--> SYSAUX tablespace is adequate for the upgrade.

.... minimum required size: 447 MB

.... AUTOEXTEND additional space required: 207 MB

--> TEMP tablespace is adequate for the upgrade.

.... minimum required size: 61 MB

.... AUTOEXTEND additional space required: 41 MB

.

**********************************************************************

Flashback: OFF

**********************************************************************

**********************************************************************

Update Parameters: [Update Oracle Database 11.2 init.ora or spfile]

**********************************************************************

WARNING: --> “sga_target” needs to be increased to at least 336 MB

WARNING: --> “java_pool_size” needs to be increased to at least 64 MB

WARNING: --> “pga_aggregate_target” needs to be increased to at least 24 MB

.

**********************************************************************

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]

**********************************************************************

--> background_dump_dest         11.1       DEPRECATED   replaced by

“diagnostic_dest”

--> user_dump_dest               11.1       DEPRECATED   replaced by

“diagnostic_dest”

--> core_dump_dest               11.1       DEPRECATED   replaced by

“diagnostic_dest”

.

**********************************************************************

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

--> Data Mining                  [upgrade]  VALID

--> Expression Filter            [upgrade]  VALID

--> Rule Manager                 [upgrade]  VALID

--> Oracle OLAP API              [upgrade]  VALID

.

**********************************************************************

Miscellaneous Warnings

**********************************************************************

WARNING: --> Database is using a timezone file older than version 11.

.... After the release migration, it is recommended that DBMS_DST package

.... be used to upgrade the 10.2.0.3.0 database timezone version

.... to the latest version which comes with the new release.

WARNING: --> Database contains schemas with stale optimizer statistics.

.... Refer to the Upgrade Guide for instructions to update

.... schema statistics prior to upgrading the database.

.... Component Schemas with stale statistics:

....   SYS

....   XDB

WARNING: --> Database contains schemas with objects dependent on network

packages.

.... Refer to the Upgrade Guide for instructions to configure Network ACLs.

WARNING: --> EM Database Control Repository exists in the database.

.... Direct downgrade of EM Database Control is not supported. Refer to the

.... Upgrade Guide for instructions to save the EM data prior to upgrade.

WARNING:--> recycle bin in use.

.... Your recycle bin turned on.

.... It is REQUIRED

.... that the recycle bin is empty prior to upgrading

.... your database.

.... The command:  PURGE DBA_RECYCLEBIN

.... must be executed immediately prior to executing your upgrade.

PL/SQL procedure successfully completed.

SQL> spool off

Adjust the warnings shown by Pre-Upgrade Information tool.




Step 3 : Upgrade using DBUA


Execute the DBUA from 11gR2 software home as

$ cd $ORACLE_HOME/bin

$ ./dbua

1.

Click “Next”

2.  Select the database that you want to upgrade

Click “Next”


3.  Here DBUA will show warnings that were not solved after running Pre-Upgrade Information tool

Click “Yes”


4. Turn OFF archiving while upgrading

Click “Next”


5. Check whether you want to move the datafiles while upgrade, though the “move datafile” check-box was not highlighted when I upgraded

Click “Next”.


6. Specify Flash Recovery Area and Diagnostic Destination

Click “Next”.


7. Check configuration for EM

Click “Next”.


8.  Check “Summary” page

Click “Finish”.

n  Now Upgrade Process is started

n  Check the Results

n  Upgrade process is completed.