Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Database creation fails
Shravana Kumar wrote:
> 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.
>
>
You need to set UNDO_MANAGEMENT = TRUE, in your init.
Received on Thu Dec 12 2002 - 00:52:23 CST