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>
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 = 3000db_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