Database creation fails

From: Shravana Kumar <kumar.shravana_at_blr.spcnl.co.in>
Date: Thu, 12 Dec 2002 11:25:34 +0530
Message-ID: <3DF824D5.51D4ACD4@blr.spcnl.co.in>

Hello All,

I am a newbie to the database administartion.

we are using oracle 9.0.1 on solaris 2.8. I am trying to create a database and ended up with the following error message. Any help is appreciated.

SQL> @/export/home/oracle/1.sql
Connected to an idle instance.
ORACLE instance started.

Total System Global Area 42533080 bytes

Fixed Size                   434392 bytes
Variable Size              37748736 bytes
Database Buffers            4194304 bytes
Redo Buffers                 155648 bytes

CREATE DATABASE "SAMPLE"
*
ERROR at line 1:
ORA-30014: operation only supported in Automatic Undo Management mode

My 1.sql file contains the following lines.

connect SYS/change_on_install as sysdba
spool $ORACLE_BASE/sample.log
startup force
pfile='/export/home/oracle/products/9.0.1/dbs/initsample.ora' nomount; CREATE DATABASE "SAMPLE"
CONTROLFILE REUSE
DATAFILE '/export/home/oracle/sample/SAMPLE.system' SIZE 10M REUSE UNDO TABLESPACE tbs_rollback1
DATAFILE '/export/home/oracle/sample/SAMPLE.tbs_rollback1' SIZE 10M REUSE
DEFAULT TEMPORARY TABLESPACE tbs_temp
TEMPFILE '/export/home/oracle/sample/SAMPLE.tbs_temp' SIZE 10M REUSE LOGFILE
GROUP 1 ('/export/home/oracle/sample/SAMPLE.redo111') SIZE 10M REUSE
,GROUP 2 ('/export/home/oracle/sample/SAMPLE.redo121') SIZE 10M REUSE
,GROUP 3 ('/export/home/oracle/sample/SAMPLE.redo131') SIZE 10M REUSE
,GROUP 4 ('/export/home/oracle/sample/SAMPLE.redo141') SIZE 10M REUSE
,GROUP 5 ('/export/home/oracle/sample/SAMPLE.redo151') SIZE 10M REUSE
,GROUP 6 ('/export/home/oracle/sample/SAMPLE.redo161') SIZE 10M REUSE
,GROUP 7 ('/export/home/oracle/sample/SAMPLE.redo171') SIZE 10M REUSE
,GROUP 8 ('/export/home/oracle/sample/SAMPLE.redo181') SIZE 10M REUSE
CHARACTER SET WE8ISO8859P1
MAXDATAFILES 255
MAXLOGFILES 32
NOARCHIVELOG
MAXINSTANCES 4; Best Regards,
ShravanaKumar. Received on Wed Dec 11 2002 - 23:55:34 CST