Upgrade database using DBUA from 10.2.0.1 to 10.2.0.4

This article is intended as a brief guide to upgrade Oracle Database from 10.2.0.1 to 10.2.0.4 on on RedHat Enterprise Linux X86_64.

oracle:oradv1>:/u01/app/oracle/product/10.2.0.1/db_1/bin=>export ORACLE_SID=oradv1
Database Name : oradv1
oracle:oradv1>:/u01/app/oracle/product/10.2.0.1/db_1/bin=>./sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 – Production on Mon Mar 21 18:54:29 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 – 64bit Production
With the Partitioning, OLAP and Data Mining options

 Step1 : backup database before upgrading to 10.2.0.4 version.
You can perform whole database backups with the database mounted or open. To perform a whole database backup from  the RMAN prompt the BACKUP DATABASE command can be used.

oracle:oradv1>:/u01/app/oracle/product/10.2.0.1/db_1/bin=>./rman target /

Recovery Manager: Release 10.2.0.1.0 – Production on Mon Mar 21 18:55:50 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

connected to target database: ORADV1 (DBID=1466539554)

RMAN> backup database format ‘/tmp/oradv1_t%t_s%s_p%p’;

Starting backup at 21-MAR-11
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=150 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=+DATA1/oradv1/datafile/system.274.746390127
input datafile fno=00002 name=+DATA1/oradv1/datafile/undotbs1.275.746390145
input datafile fno=00003 name=+DATA1/oradv1/datafile/sysaux.276.746390157
input datafile fno=00004 name=+DATA1/oradv1/datafile/users.278.746390167
channel ORA_DISK_1: starting piece 1 at 21-MAR-11
channel ORA_DISK_1: finished piece 1 at 21-MAR-11
piece handle=/tmp/oradv1_t746391546_s3_p1 tag=TAG20110321T185906 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:26
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
including current SPFILE in backupset
channel ORA_DISK_1: starting piece 1 at 21-MAR-11
channel ORA_DISK_1: finished piece 1 at 21-MAR-11
piece handle=/tmp/oradv1_t746391572_s4_p1 tag=TAG20110321T185906 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 21-MAR-11

Step2)Shut down all process running on current oracle home.
Step3)Apply oracle 10.2.0.4 patchset.

oracle:oradv1>:/u01/soft/Disk1=>./runInstaller
Starting Oracle Universal Installer…

Checking installer requirements…

Checking operating system version: must be redhat-3, SuSE-9, SuSE-10, redhat-4, redhat-5, UnitedLinux-1.0, asianux-1, asianux-2 or asianux-3
                                      Passed

All installer requirements met.

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2011-03-21_07-03-18PM. Please wait …*oralab*:/u01/soft/Disk1=>Oracle Universal Installer, Version 10.2.0.4.0 Production
Copyright (C) 1999, 2008, Oracle. All rights reserved

:/home/oracle=>sudo /u01/app/oracle/product/10.2.0.1/db_1/root.sh
Running Oracle10 root.sh script…

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /u01/app/oracle/product/10.2.0.1/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)
The file “oraenv” already exists in /usr/local/bin.  Overwrite it? (y/n)
The file “coraenv” already exists in /usr/local/bin.  Overwrite it? (y/n)

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.

oracle:oradv1>:/u01/app/oracle/product/10.2.0.1/db_1/bin=>./dbua &
[1]     14708

oracle:oradv1>:/u01/app/oracle/product/10.2.0.1/db_1/bin=>./sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 – Production on Mon Mar 21 19:50:18 2011

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> show parameter name

NAME                                 TYPE        VALUE
———————————— ———– ——————————
db_file_name_convert                 string
db_name                              string      oradv1
db_unique_name                       string      oradv1

SQL> show parameter compatible;

NAME                                 TYPE        VALUE
———————————— ———– ——————————
compatible                           string      10.2.0.4.0

Identifying Invalid Objects
——————————–
To identify all of the invalid objects , run the following query,

SQL> select owner,object_name,object_type from dba_objects where
  2  status=’INVALID’;

no rows selected