Upgrading Oracle 10.2.0.1.0 to Oracle 11.2.0.1.0:

Upgrading Oracle 10.2.0.1.0 to Oracle 11.2.0.1.0:

•  10g Oracle Home is:/u01/app/oracle/product/10.2.0
•      New home path set and then install 11g s/w

11g Oracle Home is:/uo1/app/oracle/oracle/product/11.2.0

$ ./runInstaller –invPtrLoc  /u01/app/oracle/oracle/product/11.2.0/oraInst

Screen 1 – Select Product Install à select “Oracle database 11g” à click “next”

Screen 2 – Select Installation Method à choose “Advanced Installation” à click “next”

Screen 3 – Specify Inventory Directory and credentials

Screen 4 – Select Installation type à Choose “Enterprise Edition” à click “next”

Screen 5 – Installation location  à “11g ORACLE HOME Location” à click “next”

Screen 6 – Product Specific pre-requisite checks à  click “next”

Screen 7 – Upgrade on existing database à choose “No” à click “next”

Screen 8 – Select Configuration Option à choose “Install s/w only” à click “next”

Screen 9 – Privileged system groups à  click “next”

Screen 10 – Summary à Click on “Install” à click “next”

# ./root.sh

     

       Run root.sh as a root user and once done, press ok button. This will complete the s/w installation for oracle database 11g.

$ cd /u01/app/oracle/oracle/product/product/11.2.0/db_1/rdbms/admin

$ cp utlu112i.sql  /tmp

$ sqlplus / as sysdba

SQL> @/tmp/utlu112i.sql

**********************************************************************************Database:

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

-> name:ORCL

-> version:10.2.0.1.0

-> compatible: 10.2.0.1.0

-> blocksize:8192

->platform:Linux IA (32-bit)

-> timezone file: v2

**********************************************************************************Tablespaces:[make adjustments in the current environment]

**********************************************************************************-> SYSTEM tablespace is adequate for the upgrade.

SQL> EXEC DBMS_STATS.GATHER_DICTIONARY_STATS;

SQL> EXEC DBMS_STATS.GATHER_SCHEMA_STATS(‘SYS’);                  

SQL> EXEC DBMS_STATS.GATHER_SCHEMA_STATS(‘SYSMAN’);

(3 scripts execute same place)

SQL> SHUT IMMEDIATE;

$export ORACLE_HOME=/u01/app/oracle/oracle/product/product/11.2.0/db_1

$export PATH=$ORACLE_HOME/bin:$PATH

$export ORACLE_SID=orcl

$export TNS_ADMIN=$ORACLE_HOME/network/admin

$sqlplus “ / as sysdba”

$ startup upgrade

$ SPOOL upgrade.log

SQL> @?/rdbms/admin/catupgrd.sql

SQL> spool off;

SQL> shutdown immediate;

SQL> STARTUP

SQL> @?/rdbms/admin/utlu112s.sql

Oracle  Database 11.2 Post-Upgrade Status Tool 23-02-2011 05:22:40

Component                                    Status                             Version                           HH:MM:SS

Oracle Server                                  Valid                               11.2.0.1.0                       00:19:02

Jserver Java Virtual Machine         Valid                               11.2.0.1.0                       00:02:55

Oracle Workspace Manager           Valid                               11.2.0.1.0                       00:00:54

Total Upgrade Time: 00:55:57

SQL> @?/rdbms/admin/catuppst.sql

SQL> select count(*) from dba_objects where status=’INVALID’;

   COUNT(*)

    1576

SQL> @?/rdbms/admin/utlrp.sql

SQL> select count(*) from dba_objects where status=’INVALID’;

   COUNT(*)

    0