-
ORA-01102: cannot mount in EXCLUSIVE mode
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
-
ORA-01102: cannot mount in EXCLUSIVE mode
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
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
|