unable to create database
741981Dec 26 2009 — edited Dec 27 20090racle10g release 2 OS:RHAS4
I have installed oracle, started up the instance, connected as sysdba and then tried creating a databse and this is the error I run into.
SQL> @createdb.sql
CREATE DATABASE mynewdb
*
ERROR at line 1:
ORA-30014: operation only supported in Automatic Undo Management mode
Here is the script.
CREATE DATABASE mynewdb
USER SYS IDENTIFIED BY pz6r58
USER SYSTEM IDENTIFIED BY y1tz5p
LOGFILE GROUP 1 ('/u01/app/oracle/oracle/product/10.2.0/db_1/mynewdb/redo01.log') SIZE 100M,
GROUP 2 ('/u01/app/oracle/oracle/product/10.2.0/db_1/mynewdb/redo02.log') SIZE 100M,
GROUP 3 ('/u01/app/oracle/oracle/product/10.2.0/db_1/mynewdb/redo03.log') SIZE 100M
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
MAXINSTANCES 1
CHARACTER SET US7ASCII
NATIONAL CHARACTER SET AL16UTF16
DATAFILE '/u01/app/oracle/oracle/product/10.2.0/db_1/mynewdb/system01.dbf' SIZE 325M REUSE
EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE tempts1
UNDO TABLESPACE undotbs
DATAFILE '/u01/app/oracle/oracle/product/10.2.0/db_1/mynewdb/undotbs01.dbf'
SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED