使用建庫語句建庫時遇到ORA-01092: ORACLE instance terminated錯誤

super_sky發表於2013-12-26
Oracle
一個朋友使用create database語句建庫時遇到了ORA-01092: ORACLE instance terminated. Disconnection forced錯誤。錯誤資訊如下：


檢查了其建庫語句，發現其default tablespace tbs_1沒有指定資料檔案。指定資料檔案後，該問題解決。
CREATE DATABASE SCHOLAR
   USER SYS IDENTIFIED BY oracle
   USER SYSTEM IDENTIFIED BY oracle
   LOGFILE GROUP 1 ('/u01/oradata/SCHOLAR/disk1/redo01.log') SIZE 100M,
           GROUP 2 ('/u01/oradata/SCHOLAR/disk1/redo02.log') SIZE 100M,
           GROUP 3 ('/u01/oradata/SCHOLAR/disk1/redo03.log') SIZE 100M
   MAXLOGFILES 5
   MAXLOGMEMBERS 5
   MAXLOGHISTORY 1
   MAXDATAFILES 100
   MAXINSTANCES 1
   CHARACTER SET US7ASCII
   NATIONAL CHARACTER SET AL16UTF16
   DATAFILE '/u01/oradata/SCHOLAR/disk1/system01.dbf' SIZE 325M REUSE
   EXTENT MANAGEMENT LOCAL
   SYSAUX DATAFILE '/u01/oradata/SCHOLAR/disk1/sysaux01.dbf' SIZE 325M REUSE
   DEFAULT TABLESPACE tbs_1
   DEFAULT TEMPORARY TABLESPACE tempts1
      TEMPFILE '/u01/oradata/SCHOLAR/disk1/temp01.dbf' 
      SIZE 20M REUSE
   UNDO TABLESPACE undotbs 
      DATAFILE '/u01/oradata/SCHOLAR/disk1/undotbs01.dbf'
      SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;

在遇到該問題，ORA-01092: ORACLE instance terminated. Disconnection forced時，需要從以下幾個方面入手：
1 從alert log 中確認具體問題
2 如果是建庫階段，需要從建庫語句和引數檔案檢查入手

[oracle@ocm1 ~]$ oerr ora 1092
01092, 00000, "ORACLE instance terminated. Disconnection forced"
// *Cause:  The instance this process was connected to was terminated
//          abnormally, probably via a shutdown abort. This process
//          was forced to disconnect from the instance.
// *Action: Examine the alert log for more details. When the instance has been 
//          restarted, retry action.

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/11590946/viewspace-1064494/，如需轉載，請註明出處，否則將追究法律責任。

相關文章