Oracle for WINDOWS 9.2.0.1 upgrade to Oracle patch 9.2.0.6 detailed Steps (original)

oracle|window| Original
Oracle for WINDOWS 9.2.0.1 upgrade to Oracle patch9.2.0.6 Detailed steps NOTE: This article applies only to stand-alone Oracle and is not suitable for Oracle RAC configuration

Download Oracle for window 9.2.0.6 patch run patch SETUP.EXE file from Metalink \disk1 etup.exe--If the above installation does not respond, execute directly disk1\install Etup.exe file--When installing the default option is to create a new oracle_home, we should choose the original installed Oracle_home, otherwise the upgrade may not be successful.

--After the installation is complete, check if Net Manager can open the original net configuration, if it is not open it may be some configuration format is not correct, the more specific configuration to remove the configuration can be, or all deleted, rebuild--This article assumes oracle_home as C:\ Oracle\ora92, the actual situation is based on your personal installation directory--The following steps are to upgrade the original database created--log on to the database with the SYS as SYSDBA conn Sys/sys as sysdba;startup;-- Set up shared pools and Java pools larger than 150MALTER SYSTEM set shared_pool_size= ' 150M ' scope=spfile; Alter system SET java_pool_size= ' 150M ' scope=spfile;--modifies the size of the table space to ensure 50M excess space-modifies the xdb table space to ensure 20M of excess space shutdown immediate;--Restart the database to the upgrade state startup MIGRATE; SPOOL c:\patch.log;--starts running the upgrade script and has enough memory to run for less than 1 hours, and it is recommended that all other relevant running programs be closed during run time. It's also best to have 200M of extra memory space--You can monitor Oracle upgrades through Windows Task Manager. @c:\oracle\ora92\rdbms\admin\catpatch.sql; SPOOL off;--Restore the shared pool and Java pool size, and set alter SYSTEM set shared_pool_size= ' 50M ' scope=spfile according to the actual situation; ALTER SYSTEM SET java_pool_size= ' 50M ' scope=spfile;shutdown immediate; startup;--the following script to recompile all failed objects @c:\oracle\ora92\rdbms\admin\utlrp.sql;

--Complete--if a machine has more than one database that needs to be upgraded for each database, the procedure repeats

--Ye Zhengxing--2005-02-28