If you got this error below in a RAC environment that you just finished to create/clone, you maybe forgot to set INSTANCE_NUMBER and THREAD parameter.
With two RAC Instances you should be seeing something like below:
SYS@BWOTMHM1> select inst_id,name,value from gv$parameter where name like '%instance_number%';
INST_ID NAME VALUE
---------- -------------------------------------------------------------------------------- ------------------------------
1 instance_number 1
2 instance_number 2
After everything is ok, double ckeck your threads:
SYS@BWOTMHM1> select thread#,status,enabled,instance from v$thread;
THREAD# STATUS ENABLED INSTANCE
---------- ------ -------- --------------------------------------------------------------------------------
1 OPEN PUBLIC BWOTMHM1
2 OPEN PUBLIC BWOTMHM2
SYS@BWOTMHM1>
Best Regards,
Paulo Portugal
With two RAC Instances you should be seeing something like below:
SYS@BWOTMHM1> select inst_id,name,value from gv$parameter where name like '%instance_number%';
INST_ID NAME VALUE
---------- -------------------------------------------------------------------------------- ------------------------------
1 instance_number 1
2 instance_number 2
After everything is ok, double ckeck your threads:
SYS@BWOTMHM1> select thread#,status,enabled,instance from v$thread;
THREAD# STATUS ENABLED INSTANCE
---------- ------ -------- --------------------------------------------------------------------------------
1 OPEN PUBLIC BWOTMHM1
2 OPEN PUBLIC BWOTMHM2
SYS@BWOTMHM1>
Best Regards,
Paulo Portugal
No comments:
Post a Comment