Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Manual CREATE DATABASE for 10g on RedHat Linux ES 3

Manual CREATE DATABASE for 10g on RedHat Linux ES 3

From: Morten <usenet_at_kikobu.com>
Date: 19 Nov 2004 03:16:09 -0800
Message-ID: <75db36f2.0411190316.2323a97@posting.google.com>


Hi. The DB assistant failed during installation, so I'll be creating a database manually. Following the instructions from [1], I managed to start up sqlplus, have it read my initrem01.ora, and perform a "startup nomount".

But when I try to create the database as follows:

CREATE DATABASE rem01
CHARACTER SET WE8ISO8859P1
DATAFILE '/opt/oracle-10g/oradata/rem01/datafile_01.dbf' SIZE 200m SYSAUX DATAFILE '/opt/oracle-10g/oradata/rem01/sysaux_01.dbf' SIZE 50m DEFAULT TEMPORARY TABLESPACE temp_tbs tempfile
'/opt/oracle-10g/oradata/rem01/temp_01.dbf' SIZE 50m
UNDO TABLESPACE undo_tbs DATAFILE
'/opt/oracle-10g/oradata/rem01/undo_01.dbf' SIZE 50m;

I get:

ERROR at line 1:
ORA-30014: operation only supported in Automatic Undo Management mode

Uh, what to do?

Br,

Morten

[1]: http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10739/create.htm#i1008760 Received on Fri Nov 19 2004 - 05:16:09 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US