The ORA-01092: ORACLE instance terminated disconnection forced

binghai03

　　今天启动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 aSHUTDOWN 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 日志。
         版权声明：本文为博主原创文章，未经博主允许不得转载。