Oracle 10.2.0.3 Patch°²×°Ö®BUGÏê½â

ORA-00704: bootstrap process failure
ORA-1092 signalled during: alter database open...
½øÐÐÈçϲÙ×÷ºóOK.
SQL>startup upgrade
For Windows
SQL>@d:\oracle\product\10.2.0\db_1/rdbms/admin/catupgrd.sql
For Linux
SQL>@/u01/app/oracle/product/10.2.0/db_1/rdbms/admin/catupgrd.sql
´ýcatupgrd.sql½Å±¾Ö´ÐÐÍê³É£¬shutdown immediate¹Ø±ÕÊý¾Ý¿â£»
startupÆô¶¯Êý¾Ý¿â£¬Ö´Ðнű¾
For Windows
SQL>@D:\oracle\product\10.2.0\db_1\RDBMS\ADMIN\utlrp.sql£»
For Linux
SQL>@/u01/app/oracle/product/10.2.0/db_1/RDBMS/ADMIN/utlrp.sql£»
Ö´ÐÐÍê±ÏºóÖ´ÐвéѯËùÓÐÖØбàÒë´íÎó
SQL> select * from utl_recomp_errors;
δѡ¶¨ÐУ¨ÕâÀï˵Ã÷ûÓдíÎó£©
Ö´Ðмì²é£º
SQL> select name from v$databaseÈ·ÈÏORACLE_SIDÕýÈ·£¬ÎªRAC01
SQL> show userÈ·Èϵ±Ç°Ê¹ÓÃÕßΪSYS
SQL> select tablespace_name, bytes from dba_data_files¶Ôϵͳ±í¿Õ¼ä´óС½øÐÐÈ·ÈÏ¡£
For Windows
SQL>@d:\oracle\product\10.2.0\db_1/rdbms/admin/catupgrd.sql
For Linux
SQL>@/u01/app/oracle/product/10.2.0/db_1/rdbms/admin/catupgrd.sql
SQL>shutdown immediate
SQL>startup
Êý¾Ý¿âÆô¶¯³É¹¦
Ç°Îijö´¦£ºhttp://blog.csdn.net/langcai1981/archive/2010/01/07/5148002.aspx