Database creation error: HELP!!!!

From: Vijaykumar Natarajan <vnataraj_at_gamera.syr.edu>
Date: 10 Jul 1994 01:14:01 GMT
Message-ID: <2vni0p$7dt_at_newstand.syr.edu>


I am using Oracle (sequential version) and I get the following error when I try to create a database. The actual script of the statement follows. Can anybody help. PLEASE!!

ERROR:

ORA-01501: CREATE DATABASE failed
ORA-01519: error while processing file '?/dbs/sql.bsq' near line 1007
ORA-00604: error occurred at recursive SQL level 1
ORA-00054: resource busy and acquire with NOWAIT specified

STATEMENT:

        CREATE DATABASE TEST CONTROLFILE REUSE
               LOGFILE
                  '/home/test/LOG_FILES/log1' SIZE 10 M REUSE,
                  '/home/test/LOG_FILES/log2' SIZE 10 M REUSE 
               DATAFILE

'/home/test/DB_FILES/dbf1' SIZE 60 M REUSE,
'/home/test/DB_FILES/dbf2' SIZE 60 M REUSE;

INITFILE:  control_files = /home/test/CTL_FILES/tpcdctl1.f

 db_name                         =  TEST
 db_domain                       =  syr.edu
 db_block_size                   =  4096
 db_block_buffers                =  3000 
 db_file_multiblock_read_count = 16

 rollback_segments = 4

 log_checkpoint_interval         =  5000
 log_buffer                      =  4096

 processes                       =    30
 sessions                        =    60
 sort_area_size                  = 10000
 max_dump_file_size              =  1000
 user_dump_dest                  = /home/test/DUMP

 sql_trace                       = true 
 timed_statistics                = true

 I've checked permissions, disk space, tried repeating the whole procedure from scratch, everything that I could think of. I would greatly appreciate any help.

 Vijay


VIJAYKUMAR NATARAJAN				Ph#: (315) 423 0791 (Res)
111 Roney Lane,Apt#32			e_mail:vnataraj_at_mailbox.syr.edu
Syracuse,NY 13210				vijay_at_cat.syr.edu
						vijay_at_npac.syr.edu
- BRAIN-	The Apparatus with which we think we think!!!
-------------------------------------------------------------------------------
Received on Sun Jul 10 1994 - 03:14:01 CEST

Original text of this message