Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error : simply creating a database in oracle

811119Nov 9 2010 — edited Nov 14 2010
Hello,

I have recently started with oracle and I am trying to create a database using create database sql as below, but receving some errors, can someone please help me for a direction to resolve it.

CREATE DATABASE OXXXXI
USER SYS IDENTIFIED BY password
USER SYSTEM IDENTIFIED BY password
LOGFILE GROUP 1 ('C:\ORACLE\oradata\OXXXXI\redo01.log') SIZE 51200K,
GROUP 2 ('C:\ORACLE\oradata\OXXXXI\redo02.log') SIZE 51200K,
GROUP 3 ('C:\ORACLE\oradata\OXXXXI\redo03.log') SIZE 51200K
MAXLOGFILES 32
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
CHARACTER SET AL32UTF8
NATIONAL CHARACTER SET UTF8
EXTENT MANAGEMENT LOCAL
DATAFILE 'C:\ORACLE\oradata\OXXXXI\SYSTEM01.DBF' SIZE 325M REUSE
SYSAUX DATAFILE 'C:\ORACLE\oradata\OXXXXI\SYSAUX01.DBF' SIZE 325M REUSE
DEFAULT TABLESPACE users
DATAFILE 'C:\ORACLE\oradata\OXXXXI\USERS01.DBF'
SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE 'C:\ORACLE\oradata\OXXXXI\TEMP01.DBF'
SIZE 20M REUSE
UNDO TABLESPACE undotbs
DATAFILE 'C:\ORACLE\oradata\OXXXXI\UNDOTBS01.DBF'
SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;


CREATE DATABASE OXXXXI
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-01501: CREATE DATABASE failed
ORA-01519: error while processing file '%ORACLE_HOME%\RDBMS\ADMIN\dtxnspc.bsq'
near line 5
ORA-00604: error occurred at recursive SQL level 1
ORA-30012: undo tablespace 'UNDOTBS1' does not exist or of wrong type
Process ID: 13960
Session ID: 130 Serial number: 3


SQL>



Thanks!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 12 2010
Added on Nov 9 2010
23 comments
4,509 views