My inittestdb.ora file is
control_files = (/home/oracle/oradata/testdb/control01.ctl,
/home/oracle/oradata/testdb/control02.ctl,
/home/oracle/oradata/testdb/control03.ctl)
db_name = testdb
undo_tablespace = 'UNDOTBS'
undo_management = 'AUTO'
compatible = 10.2.0.1.0
CREATE DATABASE testdb
USER SYS IDENTIFIED BY cyb123
USER SYSTEM IDENTIFIED BY cyb123
LOGFILE GROUP 1 ('/home/oracle/oradata/testdb/redo01.log') SIZE 100M,
GROUP 2 ('/home/oracle/oradata/testdb/redo02.log') SIZE 100M,
GROUP 3 ('/home/oracle/oradata/testdb/redo03.log') SIZE 100M
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
MAXINSTANCES 1
CHARACTER SET US7ASCII
NATIONAL CHARACTER SET AL16UTF16
DATAFILE '/home/oracle/oradata/testdb/system01.dbf' SIZE 125M REUSE
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE '/home/oracle/oradata/testdb/sysaux01.dbf' SIZE 125M REUSE
DEFAULT TABLESPACE tbs_1
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE '/home/oracle/oradata/testdb/temp01.dbf'
SIZE 20M REUSE
UNDO TABLESPACE undotbs
DATAFILE '/home/oracle/oradata/testdb/undotbs.dbf'
SIZE 100M REUSE;Connected to an idle instance.
CREATE DATABASE testdb
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
Alert.log file.
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMPTS1
Completed: ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMPTS1
Mon Aug 11 14:47:37 2008
Errors in file /home/oracle/product/admin/ora01/udump/ora01_ora_17020.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-02236: invalid file name
Mon Aug 11 14:47:37 2008
Errors in file /home/oracle/product/admin/ora01/udump/ora01_ora_17020.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 = 17020
ORA-1092 signalled during: CREATE DATABASE testdb
USER SYS IDENTIFIED BY ****USER SYSTEM IDENTIFIED BY ****LOGFILE GROUP 1 ('/home/oracle/oradata/testdb/redo01.log') SIZE 100M,
GROUP 2 ('/home/oracle/oradata/testdb/redo02.log') SIZE 100M,
GROUP 3 ('/home/oracle/oradata/testdb/redo03.log') SIZE 100M
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
MAXINSTANCES 1
CHARACTER SET US7ASCII
NATIONAL CHARACTER SET AL16UTF16
DATAFILE '/home/oracle/oradata/testdb/system01.dbf' SIZE 125M REUSE
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE '/home/oracle/oradata/testdb/sysaux01.dbf' SIZE 125M REUSE
DEFAULT TABLESPACE tbs_1
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE '/home/oracle/oradata/testdb/temp01.dbf'
SIZE 20M REUSE
UNDO TABLESPACE undotbs
DATAFILE '/home/oracle/oradata/testdb/undotbs.dbf'
SIZE 100M REUSE...
Please tell What could be the reason to cause the problem of ORA-01092: ORACLE instance terminated. Disconnection forced?
Thanks,
[Updated on: Mon, 11 August 2008 07:55]
Report message to a moderator