taraldesai

 Profile Answers by taraldesai 

• Jun 23rd, 2007

 

For difference refer oracle manual.

You want to migrate or upgrade.
1.
ORACLE_HOME/rdbms/admin/utlu102i.sql
2.
Stop all cron
3.
PGA_AGGREGATE_TARGET initialization parameter is set to at least 24 MB.
AQ_TM_PROCESSES=0 for the duration of the upgrade
UNDO_MANAGEMENT=AUTO
CLUSTER_DATABASE=FALSE
oratab entry N
4.
SQL> startup upgrade

SQL> CREATE TABLESPACE sysaux DATAFILE 'sysaux01.dbf'
SIZE 500M REUSE
EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO
ONLINE;

SQL> spool upgrade.log
SQL> @catupgrd.sql

SQL> @utlu102s.sql TEXT
SQL> @utlrp.sql