Printable View
I keep getting this error when opening the database.
ORA-01102: cannot mount database in EXCLUSIVE mode
I have tried every different option:
STARTUP NOMOUNT, FORCE
STARTUP FORCE pfile
ALTER DATABASE MOUNT, OPEN
Nothing seems to work to get the database to mount and open.
Any suggestions!!!
whats in the alert log
also none of the commands you have posted there will work
the alert file
Starting up ORACLE RDBMS Version: 9.2.0.7.0.
System parameters with non-default values:
_trace_files_public = TRUE
processes = 500
sessions = 555
timed_statistics = TRUE
shared_pool_size = 553648128
sga_max_size = 1588565800
shared_pool_reserved_size= 100000000
large_pool_size = 201326592
java_pool_size = 201326592
enqueue_resources = 8000
nls_date_format = DD-MON-RRRR
control_files = /oradata1/control/comp_ctrl1.ctl, /arc_logs/control/comp/comp_ctrl2.ctl, /apps/oracle/admin/comp/comp_c
trl3.ctl
db_block_size = 2048
db_writer_processes = 2
db_cache_size = 419430400
db_cache_advice = on
compatible = 9.2.0.0.0
log_archive_start = TRUE
log_archive_dest = /arc_logs/comp
log_archive_format = %s.log
log_buffer = 10485760
log_checkpoint_interval = 75000000
db_files = 150
db_file_multiblock_read_count= 32
dml_locks = 50000
max_enabled_roles = 100
O7_DICTIONARY_ACCESSIBILITY= TRUE
db_domain = world
global_names = FALSE
cursor_space_for_time = TRUE
utl_file_dir = *
job_queue_processes = 10
shadow_core_dump = partial
background_core_dump = partial
background_dump_dest = /apps/oracle/admin/comp/bdump
user_dump_dest = /apps/oracle/admin/comp/udump
max_dump_file_size = 102400
core_dump_dest = /apps/oracle/admin/comp/cdump
open_links = 10
audit_trail = TRUE
db_name = comp
open_cursors = 1000
ifile = /apps/oracle/product/9.2-cams/dbs/ifilecams20.ora
optimizer_mode = CHOOSE
pga_aggregate_target = 524288000
PMON started with pid=2
DBW0 started with pid=3
DBW1 started with pid=4
LGWR started with pid=5
CKPT started with pid=6
SMON started with pid=7
RECO started with pid=8
CJQ0 started with pid=9
Mon Mar 6 10:31:21 2006
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=10
ARC0: Archival started
ARC1 started with pid=11
Mon Mar 6 10:31:21 2006
ARCH: STARTING ARCH PROCESSES COMPLETE
Mon Mar 6 10:31:21 2006
ARC1: Archival started
Mon Mar 6 10:31:21 2006
ARC0: Becoming the 'no FAL' ARCH
ARC0: Becoming the 'no FAL' ARCHARC0: Thread not mounted
Mon Mar 6 10:31:21 2006
ARC1: Becoming the heartbeat ARCH
ARC1: Becoming the heartbeat ARCHARC1: Thread not mounted
Mon Mar 6 10:31:21 2006
ALTER DATABASE MOUNT
Mon Mar 6 10:31:21 2006
scumnt: failed to lock /apps/oracle/product/9.2-cams/dbs/lkCOMP exclusive
Mon Mar 6 10:31:21 2006
ORA-09968: scumnt: unable to lock file
Compaq Tru64 UNIX Error: 13: Permission denied
Additional information: 1246156
Mon Mar 6 10:31:21 2006
ORA-1102 signalled during: ALTER DATABASE MOUNT...
Mon Mar 6 10:32:21 2006
ARC1: Thread not mounted
Mon Mar 6 10:33:21 2006
ARC1: Thread not mounted
Mon Mar 6 10:34:21 2006
ARC1: Thread not mounted
Mon Mar 6 10:35:21 2006
ARC1: Thread not mounted
Mon Mar 6 10:36:21 2006
ARC0: Thread not mounted
Mon Mar 6 10:36:21 2006
ARC1: Thread not mounted
Mon Mar 6 10:37:21 2006
ARC1: Thread not mounted
Mon Mar 6 10:38:21 2006
ARC1: Thread not mounted
Mon Mar 6 10:38:58 2006
Hi
Shutdown the database and then move or delete the ollowing file
scumnt: failed to lock /apps/oracle/product/9.2-cams/dbs/lkCOMP exclusive
Mon Mar 6 10:31:21 2006
ORA-09968: scumnt: unable to lock file
Compaq Tru64 UNIX Error: 13: Permission denied
There is a permission issue on that file.I think oracle will create the file during next start up.
regards
Hrishy