RAC thread 2?

显示全部楼层 · 2012-1-4 11:49:54

os :linux afvance server2.1
database

racle 9.2.0.1
watchdog softdog GSD服务已启动
oracle software已安装
用OCFS没有用RAW Device
手工创建数据库
数据文件存储在磁盘阵列
instance A 可以mount open 数据库
instance B 可以nomount
在B mount 数据库时抱以下错误：
alter database mount
*
ERROR at line 1:
ORA-01617: cannot mount: 2 is not a valid thread number
从 A 执行以下语句创建redolog也报类似错误
SQL> alter database add logfile thread 2 '/oracle/oradata/ORCL/redo_2_1.log' size 100M;
alter database add logfile thread 2 '/oracle/oradata/ORCL/redo_2_1.log' size 100M
*
ERROR at line 1:
ORA-01611: thread number 2 is invalid - must be between 1 and1
创建数据库时指定以下参数：
CREATE DATABASE
CONTROLFILE REUSE
MAXDATAFILES 1024
MAXINSTANCES 3
MAXLOGHISTORY 100
MAXLOGMEMBERS 5
MAXLOGFILES 64
如何解决？望各位帮忙

千问 · 2012-1-4 11:49:54

你的init参数文件中设置的不对吧，贴处你的第二台机器的init文件看看

千问 · 2012-1-4 11:49:54

[oracle@racnode2 oracle]$ more $ORACLE_HOME/dbs/initORCL2.ora
db_block_size=8192
db_cache_size=52428800
background_dump_dest=/oracle/admin/ORCL/bdump
core_dump_dest=/oracle/admin/ORCL/cdump
user_dump_dest=/oracle/admin/ORCL/udump
timed_statistics=TRUE
control_files=("/oracle/oradata/ORCL/control01.ctl", "/oracle/oradata/ORCL/contr
ol02.ctl&quot

db_name=ORCL
shared_pool_size=52428800
sort_area_size=524288
undo_management=AUTO
cluster_database=true
cluster_database_instances=2
#remote_listener=LISTENERS_RAC
compatible=9.2.0.0
#Instance Specific Parameters for Instance "RAC1":
instance_name=ORCL2
instance_number=2
#local_listener=LISTENER_RAC1
thread=2
undo_tablespace=UNDOTBS2
[oracle@racnode2 oracle]$