Oracle 9206 Upgrade to 10.2.0.2 brief steps

1. Installation of Oracle 10g R2 software
2. To play Oracle 10g the latest patch, I'm playing a patch to upgrade to 10.2.0.2
3. Run pre-upgrade information Tool. It is used to analyze some of the things you need to do before you upgrade to 10g, such as parameters that require additions or decreases.
Start the DB to be upgraded, and use SYSDBA to run the Utlu102i.sql under 10g oracle_home/rdbms/admin to view the resulting log.
Sql> SPOOL Info.log
sql> @utlu102i. sql
Sql> SPOOL off
Here is my info.log.

Sql> @d:\utlu102i.sql;
Oracle Database 10.2 Upgrade information Utility 01-17-2007 13:22:37
.
**********************************************************************
Database:
**********************************************************************
--> Name:zhangye
--> version:9.2.0.6.0
--> compatible:9.2.0.0.0
--> blocksize:8192
.
**********************************************************************
Logfiles: [Make adjustments in the current environment]
**********************************************************************
--> the existing log files are adequate. No changes are required.
.
**********************************************************************
Tablespaces: [Make adjustments in the current environment]
**********************************************************************
--> SYSTEM tablespace is adequate for the upgrade.
.... Minimum required size:248 MB
--> TEMP tablespace is adequate for the upgrade.
.... Minimum required size:58 MB
.... Autoextend Additional space required:18 MB
.
**********************************************************************
Update Parameters: [Update Oracle Database 10.2 init.ora or SPFile]
**********************************************************************
WARNING:--> "shared_pool_size" needs to is increased to at least 177861837
WARNING:--> "java_pool_size" needs to is increased to at least 67108864
WARNING:--> "Streams_pool_size" is not currently defined and needs a value of
At least 50331648
WARNING:--> "Session_max_open_files" needs to is increased to at least 20
.
**********************************************************************
Renamed Parameters: [Update Oracle Database 10.2 init.ora or SPFile]
**********************************************************************
--No renamed parameters found. No changes are required.
.
**********************************************************************
obsolete/deprecated Parameters: [Update Oracle Database 10.2 init.ora or SPFile]
**********************************************************************
--> "Hash_join_enabled"
--> "Log_archive_start"
.
**********************************************************************
Components: [The following database components'll be upgraded or installed]
**********************************************************************
--> Oracle Catalog views [upgrade] VALID
--> Oracle Packages and Types [upgrade] VALID
.
**********************************************************************
Miscellaneous warnings
**********************************************************************
WARNING:--> deprecated CONNECT role granted to some user/roles.
.... CONNECT role After upgrade has only CREATE session privilege.
WARNING:--> Database contains stale optimizer statistics.
.... Refer to the 10g Upgrade Guide for instructions to update
.... Statistics prior to upgrading the database.
.... Component Schemas with stale statistics:
.... SYS
.
**********************************************************************
Sysaux tablespace:
[Create tablespace in the Oracle Database 10.2 environment]
**********************************************************************
--> New "Sysaux" tablespace
.... minimum required size for database upgrade:500 MB
.

The PL/SQL process has completed successfully.

Sql> spool off;

Copy Oracle 9i pfile (D:\oracle\ora92\database\INITzhangye.ORA) to Oracle 10g Pfile (D:\oracle10g\database\ Initzhangye.ora).
Check Info.log for Oracle 10g pfile modifications.

--oracle 10g modified before Pfile

*.aq_tm_processes=1
*.background_dump_dest= ' D:\oracle\admin\zhangye\bdump '
*.compatible= ' 9.2.0.0.0 '
*.control_files= ' D:\oracle\oradata\zhangye\control01.ctl ', ' D:\oracle\oradata\zhangye\control02.ctl ',
' D:\oracle\oradata\zhangye\control03.ctl '
*.core_dump_dest= ' D:\oracle\admin\zhangye\cdump '
*.db_block_size=8192
*.db_cache_size=25165824
*.db_domain= '
*.db_file_multiblock_read_count=16
*.db_name= ' Zhangye '
*.fast_start_mttr_target=300
*.hash_join_enabled=true
*.instance_name= ' Zhangye '
*.java_pool_size=0
*.job_queue_processes=10
*.large_pool_size=8388608
*.open_cursors=300
*.pga_aggregate_target=25165824
*.processes=150
*.query_rewrite_enabled= ' FALSE '
*.remote_login_passwordfile= ' EXCLUSIVE '
*.shared_pool_size=50331648
*.sort_area_size=524288
*.star_transformation_enabled= ' FALSE '
*.timed_statistics=true
*.undo_management= ' AUTO '
*.undo_retention=10800
*.undo_tablespace= ' UNDOTBS1 '
*.user_dump_dest= ' D:\oracle\admin\zhangye\udump '
*.log_archive_start=true
*.log_archive_format=%s.arc
*.log_archive_dest=d:\oracle\archive