Steps for upgrading Oracle 9i from 9.2.0.1 to 9.2.0.6

I.InstallPreparations

1. InDatabaseLog on to Windows as administrator on the server
2. Stop all Oracle-related services. These service names are usually headers of Oracle
3. Stop the Distributed Transaction Coordinator Service
4. Back up all files related to the Oracle database (including the Oracle database)SoftwareAnd data files), copy these files to a safe place according to the original directory structure, and mark or record them

 

Ii. Installation Process

 

Download Oracle for window 32 9.2.0.6 patch from Metalink

During installation, check whether the tablespace size and listener are normal.

Run the setup. EXE file/disk1/setup.exe of the patch.
-- If the preceding installation does not respond, run the disk1/install/setup.exe file directly.
-- During installation, note that the default option is to create an ORACLE_HOME. We should select the previously installed ORACLE_HOME. Otherwise, the upgrade may fail.

-- After the installation is complete, check whether the net manager can enable the original net configuration. If it cannot be opened, it may be that some configuration formats are incorrect. just re-delete the special configurations, or delete all of them and re-create them.
-- Assume that ORACLE_HOME is C:/Oracle/ora92.
-- Perform the following steps to upgrade the original database
-- Use sys as sysdba to log on to the database
Conn sys/sys as sysdba;
Startup;
-- Set the Shared Pool and Java pool to be greater than 150 m
Alter system set shared_pool_size = '150m' scope = spfile;
Alter system set java_pool_size = '150m' scope = spfile;
-- Modify the system tablespace size to ensure 50 MB of extra space.
-- Modify the XDB tablespace size to ensure 20 mb of extra space
Shutdown immediate;
-- Restart the database to the upgrade status
Startup migrate;
Spool C:/patch. log;
-- Start to run the upgrade script. If the memory is sufficient, the running time is less than 1 hour. We recommend that you close all other related running programs during the running period. In addition, we recommend that you have MB of extra memory space.
-- During the upgrade, you can use the Windows Task Manager to check whether oracle is being upgraded.
@ C:/Oracle/ora92/rdbms/admin/catpatch. SQL;
Spool off;
-- Restore the size of the Shared Pool and Java pool, and set it according to the actual situation.
Alter system set shared_pool_size = '50m' scope = spfile;
Alter system set java_pool_size = '50m' scope = spfile;
Shutdown immediate;
Startup;
-- The following script re-compiles all invalid objects
@ C:/Oracle/ora92/rdbms/admin/utlrp. SQL;

-- Complete
-- If one machine has multiple databases, each database must be upgraded. The operation steps are repeated.