December 28 2014

ORA-01092:ORACLE instance terminated. Disconnection forced

SQL> ho oerr ora 01092
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.

是在手动的创建一个数据的时候报的错 创建语句如下

[codesyntax lang=”oracle11″ container=”none”]

SQL> CREATE DATABASE prod
  2     USER SYS IDENTIFIED BY oracle
  3     USER SYSTEM IDENTIFIED BY oracle
  4     LOGFILE GROUP 1 ('/u01/app/oracle/oradata/prod/disk1/redo01.log') SIZE 100M,
  5             GROUP 2 ('/u01/app/oracle/oradata/prod/disk2/redo02.log') SIZE 100M,
  6             GROUP 3 ('/u01/app/oracle/oradata/prod/disk3/redo03.log') SIZE 100M
  7     MAXLOGFILES 5
  8     MAXLOGMEMBERS 5
  9     MAXLOGHISTORY 1
 10     MAXDATAFILES 100
 11     MAXINSTANCES 1
 12     CHARACTER SET AL32UTF8
 13     NATIONAL CHARACTER SET AL16UTF16
 14     DATAFILE '/u01/app/oracle/oradata/prod/disk1/system01.dbf' SIZE 325M REUSE
 15     EXTENT MANAGEMENT LOCAL
 16     SYSAUX DATAFILE '/u01/app/oracle/oradata/prod/disk2/sysaux01.dbf' SIZE 325M REUSE
 17     DEFAULT TABLESPACE tbs_1 DATAFILE '/u01/app/oracle/oradata/prod/disk5/tbs_01.dbf' SIZE 325M REUSE
 18     DEFAULT TEMPORARY TABLESPACE tempts1
 19        TEMPFILE '/u01/app/oracle/oradata/prod/disk3/temp01.dbf'
 20        SIZE 20M REUSE
 21     UNDO TABLESPACE UNTOTBS01
 22        DATAFILE '/u01/app/oracle/oradata/prod/disk4/undotbs01.dbf'
 23        SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;
CREATE DATABASE prod
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced

[/codesyntax]

 

参数文件如下:

[codesyntax lang=”oracle11″ container=”none”]

[oracle@odd1 dbs]$ cat initprod.ora
control_files              = (/u01/app/oracle/oradata/prod/disk1/control01.ctl,/u01/app/oracle/oradata/prod/disk2/control02.ctl,/u01/app/oracle/oradata/prod/disk3/control03.ctl)
db_name                    = prod
log_archive_dest_1         =”LOCATION=/u01/app/oracle/flash_recoverty_area”
log_archive_dest_state_1   = enable
db_block_size              = 8192
processes                  = 1000
sessions                   = 1200
open_cursors               = 1024
undo_management            = AUTO
shared_servers             =3
undo_tablespace            = UNDOTBS01
compatible                 = 10.2.0
sga_target                 = 300M
nls_language               = AMERICAN
nls_territory              = AMERICA
db_recovery_file_dest =/u01/app/oracle/flash_recoverty_area
db_recovery_file_dest_size = 4G

[/codesyntax]

查看alert日志  输出如下:

[codesyntax lang=”oracle11″ container=”none”]

CREATE UNDO TABLESPACE UNTOTBS01 DATAFILE  ‘/u01/app/oracle/oradata/prod/disk4/undotbs01.dbf’
SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
ORA-30012 signalled during: CREATE UNDO TABLESPACE UNTOTBS01 DATAFILE  ‘/u01/app/oracle/oradata/prod/disk4/undotbs01.dbf’
SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED

Fri Dec 19 01:57:39 2014
Errors in file /u01/app/oracle/admin/prod/udump/prod_ora_11112.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-30012: undo tablespace ‘UNDOTBS01’ does not exist or of wrong type
Fri Dec 19 01:57:39 2014
Errors in file /u01/app/oracle/admin/prod/udump/prod_ora_11112.trc:
ORA-01501: CREATE DATABASE failed
ORA-01519: error while processing file ‘?/rdbms/admin/sql.bsq’ near line 5792
ORA-00604: error occurred at recursive SQL level 1
ORA-30012: undo tablespace ‘UNDOTBS01’ does not exist or of wrong type
Error 1519 happened during db open, shutting down database
USER: terminating instance due to error 1519
Instance terminated by USER, pid = 11112
ORA-1092 signalled during: CREATE DATABASE prod
USER SYS IDENTIFIED BY ****USER SYSTEM IDENTIFIED BY ****LOGFILE GROUP 1 (‘/u01/app/oracle/oradata/prod/disk1/redo01.log’) SIZE 100M,

[/codesyntax]

可以发现在sqlplus的错没有很清楚的指出来问题 但是去追踪日志文件,还是可以清楚的输出是参数文件和建表语句里面的undo表空间指定的名字不一样的。 太粗心了。 把名字换成一样的 再次创建 就可以了



Copyright 2019. All rights reserved.

Posted 2014年12月28日 by ucjmh in category "oracle

Leave a Reply

Your email address will not be published. Required fields are marked *