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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center