Upgrade 10.2.0.1 to 10.2.0.5 (version upgrade):

Upgrade 10.2.0.1 to 10.2.0.5 (version upgrade):

•  First  10.2.0.1 DB full backup

Take the full backup of the PROD db using RMAN or physical backup

•   In os level presented listener,tnsnames.ora,sqlnet.ora file to be backup.

                Backup the oracle files from[/var/opt/oracle]

$ cp  –p $TNS_ADMIN/oratab oratab_BJ

$ cp  –p $TNS_ADMIN/listener.ora  listener.ora_BJ

$ cp  –p $TNS_ADMIN/oraInst.loc  oraInst.loc_BJ

$export ORACLE_SID=PROD

$ sqlplus / as sysdba

SQL> shut immediate;

SQL>exit;

$ lsnrctl stop prod_list

$ tar –cvf /backup/10.2.0.1.tar  /dboracle/orabase/product/10.2.0  10.2.0.1 binary, presented in which home path  that home path u take backup.

Install the oracle s/w 10.2.0.5.0-patch set 8202632

$ cd /software

$ p8202632_10205_HP64.zip metalink file zip format to unzip that one

$ unzip p8202632_10205_HP64.zip

$ cd Disk1

$export ORACLE_BASE=/dboracle/

$export ORACLE_SID=PROD

$export ORACLE_HOME=/dboracle/orabase/product/10.2.0

$export path=$ORACLE_HOME/bin:$PATH

$export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib

$ ./runInstaller

  èPlease specify the existing ORACLE_HOME[when the screen ask]

  èRun the script $ORACLE_HOME/root.sh – root access is required for implementer.

$ ./root.sh

$ sqlplus / as sysdba

SQL> STARTUP UPGRADE

SQL> spool upgrade_info.log

SQL>@rdbms/admin/utlu102i.sql change 10.2.0.1 to 10.2.0.5 what r the changes needed to be list out,u must b change that one

SQL> spool off;

SQL> shutdown immediate;

$ sqlplus /nolog

SQL> connect / as sysdba

SQL> startup upgrade

SQL> spool 10g_5_patch.log

SQL> @/rdbms/admin/catupgrd.sql

SQL> spool off

SQL> shutdown immediate

SQL> startup

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

SQL> select comp_name,status,version from SYS.dba_registry;

SQL> shutdown immediate

SQL> startup