Can't create a new database via SQL

[605]

Hello,

i am new to Oracle and trying to familiarize a little bit with 9.2i, using my Solaris machine. I don't have problems to create a new database with the graphical DCA. However, when i try with SQL plus, it always fails with this error:

SQL> @$ORACLE_HOME/scripts/create_db_xxx.sql
CREATE DATABASE xxx
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced


SQL>


I don't think the message tells the truth because the server works for about 10 minutes before the problem occurs. Files are created etc. If there is a problem in line 1 already, i expect it to fail immediately. Or do i simply miss something? Here is the script:

CREATE DATABASE xxx
USER SYS IDENTIFIED BY system
USER SYSTEM IDENTIFIED BY manager
CONTROLFILE REUSE
LOGFILE
GROUP 1 ('/usr/oracle/oracle92/oradata/xxx/redo01.log') SIZE 10M,
GROUP 2 ('/usr/oracle/oracle92/oradata/xxx/redo02.log') SIZE 10M,
GROUP 3 ('/usr/oracle/oracle92/oradata/xxx/redo03.log') SIZE 10M
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
MAXINSTANCES 1
CHARACTER SET US7ASCII
NATIONAL CHARACTER SET AL16UTF16
DATAFILE
'/usr/oracle/oracle92/oradata/xxx/system01.dbf' SIZE 50M REUSE
EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE temp
TEMPFILE
'/usr/oracle/oracle92/oradata/xxx/temp01.dbf' SIZE 20M REUSE
UNDO TABLESPACE undotbs
DATAFILE
'/usr/oracle/oracle92/oradata/xxx/undotbs01.dbf' SIZE 10M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
;


Any idea - please help.

 

[eagertotry]

Check the alert_<SID>.log in background_dump_dest. There must be listed the error that caused the database to crash.

It could be either a space issue on file systems where Oracle software is or an internal error due to very high SGA (such as memory issue).

 

[dbtoo2001]

did you create an init file, set your oracle_sid and start instance?

 

[LKBrwnDBA]

Also check if ORACLE_SID variable is set.

I believe the system tablespace cannot be defined as EXTENT MANAGEMENT LOCAL.




----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb