Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!sjc70.webusenet.com!news.webusenet.com!wn11feed!worldnet.att.net!204.127.198.204!attbi_feed4!attbi.com!sccrnsc02.POSTED!not-for-mail
From: Alex Ivascu <alex@ivascu.comNOSPAM>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.2b) Gecko/20021016
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.server
Subject: Re: Database creation fails
References: <3DF824D5.51D4ACD4@blr.spcnl.co.in>
In-Reply-To: <3DF824D5.51D4ACD4@blr.spcnl.co.in>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Lines: 61
Message-ID: <HmWJ9.323429$QZ.48039@sccrnsc02>
NNTP-Posting-Host: 24.126.137.208
X-Complaints-To: abuse@attbi.com
X-Trace: sccrnsc02 1039675943 24.126.137.208 (Thu, 12 Dec 2002 06:52:23 GMT)
NNTP-Posting-Date: Thu, 12 Dec 2002 06:52:23 GMT
Organization: AT&T Broadband
Date: Thu, 12 Dec 2002 06:52:23 GMT
Xref: newsfeed1.easynews.com comp.databases.oracle.server:169484
X-Received-Date: Wed, 11 Dec 2002 23:51:58 MST (news.easynews.com)

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.