Oracle Database Upgrade from version 10.2.0.1 to 10.2.0.5 to 11.2.0.3

1. Stop iSQL*Plus on the primary node by issuing the following command:

isqlplusctl stop

2. Shut down all processes in the Oracle home on each node that might be accessing a database; for example,
Oracle Enterprise Manager Database Control:

$ emctl stop dbconsole
$ lsnrctl stop listenername

3. Install 10.2.0.5 on 10.2.0.1 HOME
Note: Do not need to change ORACLE_HOME,ORACLE_SID, password file,parameter file.

10.6.1 Upgrading a Release 10.2 Database using Oracle Database Upgrade Assistant

[root@stnprod2 db_1]# ./root.sh
Running Oracle 10g root.sh script...

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /u01/app/oracle/product/10.2.0/db_1

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]: y
   Copying dbhome to /usr/local/bin ...
The file "oraenv" already exists in /usr/local/bin.  Overwrite it? (y/n)
[n]: y
   Copying oraenv to /usr/local/bin ...
The file "coraenv" already exists in /usr/local/bin.  Overwrite it? (y/n)
[n]: y
   Copying coraenv to /usr/local/bin ...

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.sh script.
Now product-specific root actions will be performed.

[root@stnprod2 db_1]#


$ lsnrctl start listenername

SQL> STARTUP UPGRADE

SPOOL /tmp/upgrade_info.log

@/u01/app/oracle/product/10.2.0/db_1/rdbms/admin/utlu102i.sql

SPOOL /tmp/patch.log
@?/rdbms/admin/catupgrd.sql
SQL> SPOOL OFF
SQL> SHUTDOWN IMMEDIATE
SQL> show parameter compa

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
compatible                           string      10.2.0.1.0
plsql_v2_compatibility               boolean     FALSE
SQL> alter system set compatible=10.2.0.5.0
  2  ;
alter system set compatible=10.2.0.5.0
                            *
ERROR at line 1:
ORA-02017: integer value required


SQL> alter system set compatible=10.2.0.5.0 scope=spfile;
alter system set compatible=10.2.0.5.0 scope=spfile
                            *
ERROR at line 1:
ORA-02017: integer value required


SQL> alter system set compatible='10.2.0.5.0' scope=spfile;
SQL>
SQL> shutdown immediate
ORA-01507: database not mounted


ORACLE instance shut down.
SQL> startup nomount
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.

Total System Global Area 3.7581E+10 bytes
Fixed Size                  2165544 bytes
Variable Size            8489272536 bytes
Database Buffers         2.9075E+10 bytes
Redo Buffers               14610432 bytes
SQL> show parameter compa

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
compatible                           string      10.2.0.5.0
plsql_v2_compatibility               boolean     FALSE
SQL> alter database mount;
SQL> alter database open;
SQL>

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi
PL/SQL Release 10.2.0.5.0 - Production
CORE    10.2.0.5.0      Production
TNS for Linux: Version 10.2.0.5.0 - Production
NLSRTL Version 10.2.0.5.0 - Production

SQL>


##### Now Go From 10.2.0.5.0 to 11.2.0.3.0#####

--Install Oracle 11.2.0.3 binary into new ORACLE_HOME

--After installing binary run dbua and upgrade 10.2.0.5.0 home to 11.2.0.3.0

-- After upgrading Database shutdown and startup phase by phase (no mount,mount then open)

SQL> select status from v$instance;

STATUS
------------
OPEN

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

SQL>