Upgrading 11i EBS 9205 DB to 10g R2 as a part of upgrade to R12

1. sql > startup

2. sql > CREATE TABLESPACE sysaux DATAFILE '/dbf/dbf/sysaux01.dbf'

SIZE 500M REUSE

EXTENT MANAGEMENT LOCAL

SEGMENT SPACE MANAGEMENT AUTO

ONLINE;

 

3. sql > shutdown

 

4. sql > startup upgrade

 

5. sql > spool upgrade.log

 

6. sql > @catupgrd.sql

 

7. sql > @utlu102s.sql

 

SQL> SHUTDOWN IMMEDIATE

SQL> STARTUP