最近在配置2003双机(MSCS)后进行切换时发现当从NOD1切换到NOD2时数据库是处于打开状态的,可以进行正常的数据操作,
当NOD2切换到NOD1时数据库却处于MOUNT状态,
查了告警日志发现如下错误:ora-1991 signalled during alter database mount exclusive当本人手工执行如下操作时数据库可以打开;alter database open;下面为告警日志:Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 50331648
large_pool_size = 8388608
java_pool_size = 33554432
control_files = Z:\oracle\orcl\CONTROL01.CTL, Z:\oracle\orcl\CONTROL02.CTL, Z:\oracle\orcl\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 25165824
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = orcl
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = C:\oracle\admin\orcl\bdump
user_dump_dest = C:\oracle\admin\orcl\udump
core_dump_dest = C:\oracle\admin\orcl\cdump
sort_area_size = 524288
db_name = orcl
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
aq_tm_processes = 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Sat Aug 22 09:42:49 2009
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Sat Aug 22 09:42:50 2009
alter database mount exclusive
Sat Aug 22 09:42:55 2009
Successful mount of redo thread 1, with mount id 1223346714.
Sat Aug 22 09:42:55 2009
Database mounted in Exclusive Mode.
ORA-1991 signalled during: alter database mount exclusive...
当NOD2切换到NOD1时数据库却处于MOUNT状态,
查了告警日志发现如下错误:ora-1991 signalled during alter database mount exclusive当本人手工执行如下操作时数据库可以打开;alter database open;下面为告警日志:Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 50331648
large_pool_size = 8388608
java_pool_size = 33554432
control_files = Z:\oracle\orcl\CONTROL01.CTL, Z:\oracle\orcl\CONTROL02.CTL, Z:\oracle\orcl\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 25165824
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = orcl
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = C:\oracle\admin\orcl\bdump
user_dump_dest = C:\oracle\admin\orcl\udump
core_dump_dest = C:\oracle\admin\orcl\cdump
sort_area_size = 524288
db_name = orcl
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
aq_tm_processes = 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Sat Aug 22 09:42:49 2009
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Sat Aug 22 09:42:50 2009
alter database mount exclusive
Sat Aug 22 09:42:55 2009
Successful mount of redo thread 1, with mount id 1223346714.
Sat Aug 22 09:42:55 2009
Database mounted in Exclusive Mode.
ORA-1991 signalled during: alter database mount exclusive...
重建密码文件:orapwd命令