Steps for Oracle Upgradation

10 steps for Upgrading Oracle from 8.1.7 to

  1. Install 10-G in new ORACLE_HOME path.
  2. Change to 10-G Path as below:

cd $ORACLE_HOME/rdbms/admin

copy utlu101i.sql to new dir

  1. In 8.1.7 database run utlu101i.sql, which gives the output about system requirements, the Parameter should be updated etc.

SQL> spool upgr.lst

SQL>@ utlu101i.sql;

SQL>spool off;

From the upgr.lst, note the changes to be made.

  1. Copy init file from 8.1.7 dbs to <newpath> make changes to init parameters as mentioned in upgr.lst
  2. Startup the database in upgrade mode:

SQL> startup pfile=’<newpath>/inittest.ora’ upgrade;

  1. Create sysaux tablespace

SQL> create tablespace sysaux

Datafile ‘<newpath>/sysaux.dbf’ size 500M

Extent management local

Segment space management auto online;

  1. Run the upgrade script.

SQL> @ ‘$ORACLE_HOME/rdbms/admin/u0801070.sql’;

  1. Shutdown the database.

SQL>shutdown immediate;

  1. Startup the database

SQL> startup;

  1. Recompile the Invalid objects:

SQL> @’$ORACLE_HOME/rdbms/admin/utlrp.sql’

Thanks and Regards

D.Sasi kumar