oracle报00942错误,案例:Oracle报错ORA-00704:bootstrap process failure ORA-00604 ORA-00942

天萃荷净

运维DBA反映，数据库服务器重启后数据库无法启动，ora错误为ORA-00704 ORA-00604 ORA-00942，分析原因为丢失access$表

Oracle 11g数据库因为异常关闭导致access$表丢失,使得数据库不能正常open.为什么这个表会丢失还未找到原因.我这里提供一种在upgrade模式下解决给问题方法.

1.查询Oracle数据库版本

SQL> select * from v$version;

BANNER

--------------------------------------------------------------------------

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production

PL/SQL Release 11.2.0.3.0 - Production

CORE 11.2.0.3.0 Production

TNS for Linux: Version 11.2.0.3.0 - Production

NLSRTL Version 11.2.0.3.0 - Production

SQL> select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') "oracleplus" from dual;

oracleplus

--------------------------------------

2012-06-22 05:28:57

2.数据库open启动报ORA-00704

SQL> startup

ORACLE instance started.

Total System Global Area 523108352 bytes

Fixed Size 1346052 bytes