一个朋友使用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博客

使用建库语句建库时遇到ORA-01092: ORACLE instance terminated错误

最新文章