Windows 2003从Oracle 9201 update to 9208(二)
plus /nolog
SQL> CONNECT SYS/SYS_password AS SYSDBA
SQL> STARTUP MIGRATE
SQL> SPOOL catpatch.out
SQL>@ORACLE_BASE\ORACLE_HOME\rdbms\admin\catpatch.sql
SQL> SPOOL OFF
****4. If Oracle Spatial is installed withthe database, perform the following steps:
SQL> alter session set current_schema =mdsys;
SQL>@ORACLE_BASE\ORACLE_HOME\md\admin\prvtmd.plb
SQL>@ORACLE_BASE\ORACLE_HOME\md\admin\prvtmd2.plb
SQL>@ORACLE_BASE\ORACLE_HOME\md\admin\sdopidx.sql
SQL>@ORACLE_BASE\ORACLE_HOME\md\admin\prvtpidx.plb
SQL>@ORACLE_BASE\ORACLE_HOME\md\admin\prvtsidx.plb
SQL>@ORACLE_BASE\ORACLE_HOME\md\admin\sdogeom.sql
SQL>@ORACLE_BASE\ORACLE_HOME\md\admin\prvt3glh.plb
SQL>@ORACLE_BASE\ORACLE_HOME\md\admin\prvtgeom.plb
SQL>@ORACLE_BASE\ORACLE_HOME\md\admin\prvt3gl.plb
SQL> alter session set current_schema =sys;
SQL> SHUTDOWN IMMEDIATE
6.Start the database and recompile theremaining invalid objects:
SQL> STARTUP
SQL>@ORACLE_BASE\ORACLE_HOME\rdbms\admin\utlrp.sql
7.Review catbkout.out and catpatch.out forerrors.
8.Restart the database:
For Single Instance:
SQL> SHUTDOWN
SQL> STARTUP
补充：catpatch.sql script can take a long time if there are statistics for the SYS schema. Delete the statistics on all of the objects in the SYS schema, and then recollect the statistics after normal database open, ifnecessary.
To drop and re-create the statistics, enter the followingcommands in SQL*Plus:
SQL> EXECUTE DBMS_STATS.DELETE_SCHEMA_STATS('SYS');
SQL> EXECUTE DBMS_STATS.GATHER_SCHEMA_STATS('SYS');
注意：如果安装过程中出现带乱码的提示框，一般是oracle实例没有停止,请先按“安装前的准备”做，然后重启电脑，安装。