Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01092: ORACLE instance terminated. Disconnection forced

457603Sep 30 2005 — edited Sep 30 2005
when doing a 'create database' on linux, in sqlplus, using oracle10
after processing for like 2 minutes, it spits out this error:

ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced

my alert log is

Fri Sep 30 09:22:54 2005
CREATE DATABASE mydb
LOGFILE
GROUP 1 ('/u01/app/oracle/oradata/mydb/redo01.log') SIZE 100M,
GROUP 2 ('/u01/app/oracle/oradata/mydb/redo02.log') SIZE 100M,
GROUP 3 ('/u01/app/oracle/oradata/mydb/redo03.log') SIZE 100M
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
MAXINSTANCES 1
CHARACTER SET "US7ASCII"
DATAFILE '/u01/app/oracle/oradata/mydb/system01.dbf' SIZE 325M
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE '/u01/app/oracle/oradata/mydb/sysaux01.dbf' SIZE 325M
DEFAULT TABLESPACE tbs_1
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE '/u01/app/oracle/oradata/mydb/temp01.dbf'
SIZE 20M
UNDO TABLESPACE UNDOTBS1
DATAFILE '/u01/app/oracle/oradata/mydb/undotbs01.dbf'
SIZE 200M AUTOEXTEND ON MAXSIZE UNLIMITED...
Fri Sep 30 09:23:29 2005
CREATE DATABASE mydb
LOGFILE
GROUP 1 ('/u01/app/oracle/oradata/mydb/redo01.log') SIZE 100M,
GROUP 2 ('/u01/app/oracle/oradata/mydb/redo02.log') SIZE 100M,
GROUP 3 ('/u01/app/oracle/oradata/mydb/redo03.log') SIZE 100M
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
MAXINSTANCES 1
CHARACTER SET "US7ASCII"
DATAFILE '/u01/app/oracle/oradata/mydb/system01.dbf' SIZE 325M
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE '/u01/app/oracle/oradata/mydb/sysaux01.dbf' SIZE 325M
DEFAULT TABLESPACE tbs_1
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE '/u01/app/oracle/oradata/mydb/temp01.dbf'
SIZE 20M
UNDO TABLESPACE UNDOTBS1
DATAFILE '/u01/app/oracle/oradata/mydb/undotbs01.dbf'
SIZE 200M AUTOEXTEND ON MAXSIZE UNLIMITED
Fri Sep 30 09:23:30 2005
Database mounted in Exclusive Mode
Fri Sep 30 09:23:39 2005
Successful mount of redo thread 1, with mount id 2485384465
Assigning activation ID 2485384465 (0x9423f511)
Thread 1 opened at log sequence 1
Current log# 1 seq# 1 mem# 0: /u01/app/oracle/oradata/mydb/redo01.log
Successful open of redo thread 1
Fri Sep 30 09:23:39 2005
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Fri Sep 30 09:23:39 2005
SMON: enabling cache recovery
Fri Sep 30 09:23:39 2005
create tablespace SYSTEM datafile '/u01/app/oracle/oradata/mydb/system01.dbf' SIZE 325M

EXTENT MANAGEMENT LOCAL online
Fri Sep 30 09:23:51 2005
Completed: create tablespace SYSTEM datafile '/u01/app/oracle/oradata/mydb/system01.dbf' SIZE 325M
EXTENT MANAGEMENT LOCAL online
Fri Sep 30 09:23:51 2005
create rollback segment SYSTEM tablespace SYSTEM
storage (initial 50K next 50K)
Completed: create rollback segment SYSTEM tablespace SYSTEM
storage (initial 50K next 50K)
Fri Sep 30 09:23:59 2005
CREATE UNDO TABLESPACE UNDOTBS1 DATAFILE '/u01/app/oracle/oradata/mydb/undotbs01.dbf'
SIZE 200M AUTOEXTEND ON MAXSIZE UNLIMITED
Fri Sep 30 09:24:07 2005
Successfully onlined Undo Tablespace 1.
Completed: CREATE UNDO TABLESPACE UNDOTBS1 DATAFILE '/u01/app/oracle/oradata/mydb/undotbs01.dbf'
SIZE 200M AUTOEXTEND ON MAXSIZE UNLIMITED
Fri Sep 30 09:24:07 2005
create tablespace SYSAUX datafile '/u01/app/oracle/oradata/mydb/sysaux01.dbf' SIZE 325M

EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO online
Fri Sep 30 09:24:18 2005
Completed: create tablespace SYSAUX datafile '/u01/app/oracle/oradata/mydb/sysaux01.dbf' SIZE 325M
EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO online
Fri Sep 30 09:24:19 2005
CREATE TEMPORARY TABLESPACE TEMPTS1 TEMPFILE '/u01/app/oracle/oradata/mydb/temp01.dbf'
SIZE 20M

Completed: CREATE TEMPORARY TABLESPACE TEMPTS1 TEMPFILE '/u01/app/oracle/oradata/mydb/temp01.dbf'
SIZE 20M
Fri Sep 30 09:24:20 2005
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMPTS1
Completed: ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMPTS1
Fri Sep 30 09:24:20 2005
Errors in file /u01/app/oracle/admin/mydb/udump/mydb_ora_3997.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-02236: invalid file name
Fri Sep 30 09:24:20 2005
Errors in file /u01/app/oracle/admin/mydb/udump/mydb_ora_3997.trc:
ORA-01501: CREATE DATABASE failed
ORA-01519: error while processing file '?/rdbms/admin/sql.bsq' near line 6262
ORA-00604: error occurred at recursive SQL level 1
ORA-02236: invalid file name
Error 1519 happened during db open, shutting down database
USER: terminating instance due to error 1519
Instance terminated by USER, pid = 3997
ORA-1092 signalled during: CREATE DATABASE mydb
LOGFILE
GROUP 1 ('/u01/app/oracle/oradata/mydb/redo01.log') SIZE 100M,
GROUP 2 ('/u01/app/oracle/oradata/mydb/redo02.log') SIZE 100M,
GROUP 3 ('/u01/app/oracle/oradata/mydb/redo03.log') SIZE 100M
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
MAXINSTANCES 1
CHARACTER SET "US7ASCII"
DATAFILE '/u01/app/oracle/oradata/mydb/system01.dbf' SIZE 325M
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE '/u01/app/oracle/oradata/mydb/sysaux01.dbf' SIZE 325M
DEFAULT TABLESPACE tbs_1
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE '/u01/app/oracle/oradata/mydb/temp01.dbf'
SIZE 20M
UNDO TABLESPACE UNDOTBS1
DATAFILE '/u01/app/oracle/oradata/mydb/undotbs01.dbf'
SIZE 200M AUTOEXTEND ON MAXSIZE UNLIMITED...
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 28 2005
Added on Sep 30 2005
#general-database-discussions
2 comments
182 views