ORA-01092

oracle@linux-l4nt:~> sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Sat Jan 23 10:58:31 2010

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area  285212672 bytes
Fixed Size                  1267044 bytes
Variable Size             130026140 bytes
Database Buffers          146800640 bytes
Redo Buffers                7118848 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced

查看alert_orcl.log文件

Errors in file /opt/oracle/admin/orcl/udump/orcl_ora_8281.trc:
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
Sat Jan 23 10:08:05 2010
Error 704 happened during db open, shutting down database
USER: terminating instance due to error 704
Instance terminated by USER, pid = 8281
ORA-1092 signalled during: ALTER DATABASE OPEN...

查看/opt/oracle/admin/orcl/udump/orcl_ora_8281.trc

KCRA: start recovery claims for 96 data blocks
*** 2010-01-23 10:08:04.520
KCRA: blocks processed = 96/96, claimed = 96, eliminated = 0
*** 2010-01-23 10:08:04.520
Recovery of Online Redo Log: Thread 1 Group 1 Seq 2 Reading mem 0
----- Recovery Hash Table Statistics ---------
Hash table buckets = 32768
Longest hash chain = 1
Average hash chain = 96/96 = 1.0
Max compares per lookup = 1
Avg compares per lookup = 1283/1287 = 1.0
----------------------------------------------
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option

原因：因为今天进行了数据库升级，数据字典的一些基表内容被修改了。

解决方法：执行$ORACLE_HOME/rdbms/admin/catupgrd.sql(如果报错，执行
@$ORACLE_HOME/rdbms/admin/catalog.sql 和@$ORACLE_HOME/rdbms/admin/catproc.sql)

处理过程：

oracle@linux-l4nt:~> sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Sat Jan 23 11:06:22 2010

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Connected to an idle instance.

SQL> startup upgrade
ORACLE instance started.

Total System Global Area  285212672 bytes
Fixed Size                  1267044 bytes
Variable Size             130026140 bytes
Database Buffers          146800640 bytes
Redo Buffers                7118848 bytes
Database mounted.
Database opened.
SQL>@ORACLE_HOME/rdbms/admin/catupgrd.sql
....
没有报错
SQL>shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL>startup
ORACLE instance started.

Total System Global Area  285212672 bytes
Fixed Size                  1267044 bytes
Variable Size             130026140 bytes
Database Buffers          146800640 bytes
Redo Buffers                7118848 bytes
Database mounted.
Database opened.

成功启动数据库。
备份数据。

如果执行过程中有错误，完成后仍然无法正常启动，则这个脚本不可用，换其他两个脚本执行

SQL> startup upgrade
ORACLE instance started.

Total System Global Area  285212672 bytes
Fixed Size                  1267044 bytes
Variable Size             130026140 bytes
Database Buffers          146800640 bytes
Redo Buffers                7118848 bytes
Database mounted.
Database opened.
SQL>@$ORACLE_HOME/rdbms/admin/catalog.sql
.....
SQL>@$ORACLE_HOME/rdbms/admin/catproc.sql
.....
SQL>shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL>startup
ORACLE instance started.

Total System Global Area  285212672 bytes
Fixed Size                  1267044 bytes
Variable Size             130026140 bytes
Database Buffers          146800640 bytes
Redo Buffers                7118848 bytes
Database mounted.
Database opened.

处理完毕！！！！！！

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22779291/viewspace-625825/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22779291/viewspace-625825/