-
Erorr creating Oracle database
I am following the Oralce documentation in the 10G admin guide on how to manually create a database.
When I issue the following command (create database command) I see the following error show up in my trace file. BTW, the fille was created on disk. Does anybody have an idea on how to rectify this?
CREATE DATABASE pbh10g2
USER SYS IDENTIFIED BY sys
USER SYSTEM IDENTIFIED BY system
LOGFILE GROUP 1 ('/rdbms/oracle_data/10g2/pbh10g2/redo01.log') SIZE 50M,
GROUP 2 ('/rdbms/oracle_data/10g2/pbh10g2/redo02.log') SIZE 50M,
GROUP 3 ('/rdbms/oracle_data/10g2/pbh10g2/redo03.log') SIZE 50M
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
MAXINSTANCES 1
DATAFILE '/rdbms/oracle_data/10g2/pbh10g2/system01.dbf' SIZE 325M REUSE
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE '/rdbms/oracle_data/10g2/pbh10g2/sysaux01.dbf' SIZE 325M REUSE
DEFAULT TABLESPACE tbs_1
DEFAULT TEMPORARY TABLESPACE temp
TEMPFILE '/rdbms/oracle_data/10g2/pbh10g2/temp01.dbf'
SIZE 20M REUSE
UNDO TABLESPACE undotbs
DATAFILE '/rdbms/oracle_data/10g2/pbh10g2/undotbs01.dbf'
SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;
*** 2006-08-14 11:22:20.429
kccsga_update_ckpt: num_1 = 1, num_2 = 0, num_3 = 0, lbn_2 = 0, lbn_3 = 0
Control file created with size 416 blocks
*** 2006-08-14 11:22:47.648
ORA-00604: error occurred at recursive SQL level 1
ORA-30012: undo tablespace 'UNDOTBS1' does not exist or of wrong type
Offending statement at line 5792
CREATE UNDO TABLESPACE UNDOTBS DATAFILE
'/rdbms/oracle_data/10g2/pbh10g2/undotb
s01.dbf'
SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
ORA-01501: CREATE DATABASE failed
ORA-01519: error while processing file '?/rdbms/admin/sql.bsq' near line 5792
ORA-00604: error occurred at recursive SQL level 1
ORA-30012: undo tablespace 'UNDOTBS1' does not exist or of wrong type
-
you're creating UNDOTBS and your init.ora has UNDOTBS1.
there are tools for this, you know?
Jeff Hunter
-
Thanks for your help. I know about the tools. Being a newbie to Oracle I wanted to try it with the manual steps so I can see what is under the covers.
-
Google it.........
Try out!
All the best.
"What is past is PROLOGUE"
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|