Database Administration (MOSC)

MOSC Banner

Error CREATE DATABASE - ORA-30014

edited Feb 9, 2011 6:17PM in Database Administration (MOSC) 6 commentsAnswered
Dear members,

I've tried to create a database but there's something wrong I can't fix so I appreciate any help.

Here's the error message :

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

I've already checked that my initTECHFR01.ora contains the undo_management=AUTO, so the problem is elsewhere. Here it is :

undo_management=AUTO
undo_tablespace=UNDO_TBS
db_name=TECHFR01
db_block_size=8192
sga_max_size=1073741824 #one gig
sga_target=1073741824 #one gig
control_files=(/produits/app/oracle/10.2.0.4/oradata/TECHFR01/control.001.dbf, /produits/app/oracle/10.2.0.4/oradata/TECHFR01/control.002.dbf, /produits/app/
oracle/10.2.0.4/oradata/TECHFR01/control.003.dbf)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center