The ORA-01092: ORACLE instance terminated disconnection forced

 今天启动database 的时候，先到mounted ,后来就force terminated, 数据库shutdown 了，后来查了alert log, 发现是bdump 里的trc 不能打开，原因是数据库以外关闭的。

 

下面看一下oracle 的提供的信息：

The Oracle docs note details on the ORA-1092 error:

ORA-01092: ORACLE instance terminated. Disconnection forced

Cause: The instance connected to was terminated abnormally, probably due to a SHUTDOWN ABORT. The current process was forced to disconnect from the instance.

Action: Examine the alert log for more details. Contact the database administrator to determine when the instance is restarted. Attempt to reconnect after the instance is running again.

The ORA-01092: ORACLE instance terminated Disconnection forced. is a generic error when Oracle detects a serious problem at database start time.

The ORA-01092: ORACLE instance terminated error can be caused by many factors :

• A shutdown abort
• Bad permissions of BDUMP, CDUMP or UDUMP directories
• Missing datafiles
• Renaming files when Oracle is down
• and many other OS-related causes

Check your alert log for a more descriptive report of the exact startup problem.

Check …./bdump/*.log

ORA-30012: undo tablespace ‘UNDO_TBS’ does not exist or of wrong type

SQL> startup mount

SQL> select name from v$datafile;

SQL> show parameter undo;

SQL> select name from v$tablespace;

SQL> alter system set undo_tablespace=’undotbs1′ scope=spfile;

SQL> shutdown immediate;

SQL> startup;

http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/undo.htm

 

可以先启动database 到mounted 状态， show parameter dump

看到bdump 下alert 日志。