Copy /ORACLE_HOME/rdbms/admin/utlu102i.sql from 10.2 environment to a temp area
Connect with sysdba privileges
SQL> Spool info.log
SQL> @utlu102i.sql
SQL> Spool off
If 9 database
CREATE TABLESPACE “SYSAUX” LOGGING datafile ‘/oradata/10.2.0/<databasename>/ SYSAUX01.dbf’ size 500M EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ;
Move pfile link from dbs (if pfile not help in the dbs directory)
Move passwordfile (orapwd file=xxx password=xxx)
SHUTDOWN IMMEDIATE the database
Change Linux environment to 10.2
Cd $ORACLE_HOME/rdbms/admin
Connect with sysdba privileges
SQL> Startup upgrade
SQL> Spool upgrade.log
SQL> @catupgrd.sql
SQL> Spool off;
SQL> @utlu102s.sql
SQL> Shutdown Immediate
SQL> Startup
SQL> @utlrp.sql
SQL> Exit
UPGRADE COMPLETE !!!!!!! ?
PFILE parameters
##########################################
# 10.2.0 Upgrade Parameters #
##########################################
compatible = 10.2.0.3.0
shared_pool_size=185110733
java_pool_size=67108864
large_pool_size = 8388608
pga_aggregate_target = 25165824
streams_pool_size=50000000
session_max_open_files=20
Redundant parameters
hash_join_enabled
undo_suppress_errors
max_enabled_roles
To rename datafiles use the following :-
ls -1 | awk ‘{print “mv “$1” ren”$1}’ | sed s/renOLDNAME/NEWNAME/ > ren
. ren