Amazon books

Thursday, March 6, 2014

USER (ospid: 12124306): terminating the instance due to error 29760 Thu Mar 06 14:58:42 2014 Instance terminated by USER, pid = 12124306

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


No comments:

Post a Comment