Oracle for Windows 9.2.0.1 Upgrade to Oracle Patch9.2.0.6 Detailed Steps: This article is applied only to stand-alone Oracle, not suitable for Oracle RAC configuration
Download Oracle for WINDOW 32 9.2.0.6 Patch from Metalink running Patch's setup.exe file /disk1/setup.exe - If the above installation execution does not respond, execute disk1 / install / setup.exe file - pay attention to the installation The default option is to create a new Oracle_Home, we should choose the original Oracle_home, otherwise the upgrade may not succeed.
- After the installation is complete, check if NET Manager can open the original NET configuration. If you can't open it, you may have some configuration formats incorrect, and the more special configuration re-extensions can be configured, or all delete, re-establish - This article assumes oracle_home for c: / oracle / ora92, actual situation According to your personal installation directory - The following steps to upgrade the original created database - STARTUP; Set the shared pool and Java pool than 150malter system set shared_pool_size = '150m' scope = spfile; alter system set java_pool_size = '150m' scope = spfile; - Modify the system table space size, guarantee 50M unwanted space - modify the XDB table Space size, guarantees a 20m extra space shutdown immediate; - Restart the database to the upgrade status Startup migrate; spool c: /patch.log; - Start running upgrade script, the memory is enough to run less than 1 hour, suggest Turn off all other relevant runtime during operation, and the other is preferably 200M excess memory space - can monitor whether Oracle is upgraded via the Windows Task Manager when upgrading. @C: /oracle/ora92/rdbms/admin/catpatch.sql; spool off; - Restore shared pool and Java pool size, set alter system set shared_pool_size = '50m' scope = spfile; alter system set java_pool_size = '50m' scope = spfile; shutdown immediate; startup; - The following scripts are recompiled all fail-to-object @c: /oracle/ora92/rDBMS/Admin/utlrp.sql;
- Completed - If you need multiple databases to have multiple databases, you need to upgrade each database, and the steps are repeated
- 正 盛 --2005-02-28
