Saturday, December 18, 2010

Database Upgrade to 10.2.0.4

Database Upgrade 10G to 10.2.0.4 - DB Upgrade to 10.2.0.4::

Please fine the below steps which will outline 10.2.0.4 DB upgrade action plan.


0)Check the status of all the components before the upgrade:

SQL> SELECT COMP_NAME, VERSION, STATUS FROM SYS.DBA_REGISTRY;
SQL>select count(*) from dba_objects where status='INVALID';

1)Download and unzip patch p6810189_10204_Linux-x86-64.zip in /stage directory.

2)Shutdown database and listener

Set the following env variables:

export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/bin/OPatch:$PATH:
ORACLE_HOME=Oracle_home
ORACLE_SID=sid
export ORACLE_HOME ORACLE_SID

3)Install the 10.2.0.4 patch set

From VNC launch the runinstaller.

cd /stage/Disk1
./runInstaller
On the Welcome screen, click Next.....

4)Upgrading the databse to 10.2.0.4

a)Run the Pre-Upgrade Information Tool

Start the database in the UPGRADE mode:

sqlplus '/as sysdba'
SQL> STARTUP UPGRADE

SQL> SPOOL upgrade_info.log

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

SQL> SPOOL OFF
Check the output of the Pre-Upgrade Information Tool in the upgrade_info.log file,Make sure all are fine.

b)Upgrade the Database

SQL> STARTUP UPGRADE
SQL> SPOOL patch.log
SQL> @?/rdbms/admin/catupgrd.sql
SQL> SPOOL OFF

c)Restart the database:& Compile Invalids.

SQL> SHUTDOWN IMMEDIATE
SQL> STARTUP
SQL>@?/rdbms/admin/utlrp.sql


5)Check the status of all the components after the upgrade:

SQL> SELECT COMP_NAME, VERSION, STATUS FROM SYS.DBA_REGISTRY;
SQL>select count(*) from dba_objects where status='INVALID';


1 comment:

  1. I like the way you are making things easier to do. As a real novice in blogging, getting this type of help is wonderful.Thanks for showing us new ways to do things!
    chemical color toner

    ReplyDelete