5 Replies Latest reply: Apr 7, 2013 3:00 AM by 911223 RSS

    Failover not happening the Oracle RAC 10g

    911223
      Hi All,

      I am new to RAC.

      I have installed Oracle RAC 10g on Redhat Linux 4.0. Till yesterday failover was happening that is when i stopped one instance on node01 the vip of node01 was transferred to node02.This was shown using ifconfig -a but now that is now happening.Don't know as what has happened.Can you please help me out


      Below information is given:



      [oracle@node01 ~]$ crs_stat -t
      Name Type Target State Host
      ------------------------------------------------------------
      ora.hitesh.db application ONLINE ONLINE node02
      ora....h1.inst application ONLINE ONLINE node01
      ora....h2.inst application OFFLINE OFFLINE
      ora....SM1.asm application ONLINE ONLINE node01
      ora....01.lsnr application ONLINE ONLINE node01
      ora.node01.gsd application ONLINE ONLINE node01
      ora.node01.ons application ONLINE ONLINE node01
      ora.node01.vip application ONLINE ONLINE node01
      ora....SM2.asm application ONLINE ONLINE node02
      ora....02.lsnr application ONLINE ONLINE node02
      ora.node02.gsd application ONLINE ONLINE node02
      ora.node02.ons application ONLINE ONLINE node02
      ora.node02.vip application ONLINE ONLINE node02


      Listner status on node01 is given:

      [oracle@node01 ~]$ lsnrctl status

      LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 06-APR-2013 12:59:29

      Copyright (c) 1991, 2005, Oracle. All rights reserved.

      Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
      STATUS of the LISTENER
      ------------------------
      Alias LISTENER_NODE01
      Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
      Start Date 06-APR-2013 11:59:03
      Uptime 0 days 1 hr. 0 min. 25 sec
      Trace Level off
      Security ON: Local OS Authentication
      SNMP OFF
      Listener Parameter File /home/oracle/oracle/product/10.2.0/db_1/network/admin/listener.ora
      Listener Log File /home/oracle/oracle/product/10.2.0/db_1/network/log/listener_node01.log
      Listening Endpoints Summary...
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.131)(PORT=1521)))
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
      Services Summary...
      Service "+ASM" has 1 instance(s).
      Instance "+ASM1", status BLOCKED, has 1 handler(s) for this service...
      Service "+ASM_XPT" has 1 instance(s).
      Instance "+ASM1", status BLOCKED, has 1 handler(s) for this service...
      Service "PLSExtProc" has 1 instance(s).
      Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
      Service "hitesh" has 2 instance(s).
      Instance "hitesh1", status READY, has 2 handler(s) for this service...
      Instance "hitesh2", status READY, has 1 handler(s) for this service...
      Service "hiteshXDB" has 2 instance(s).
      Instance "hitesh1", status READY, has 1 handler(s) for this service...
      Instance "hitesh2", status READY, has 1 handler(s) for this service...
      Service "hitesh_XPT" has 2 instance(s).
      Instance "hitesh1", status READY, has 2 handler(s) for this service...
      Instance "hitesh2", status READY, has 1 handler(s) for this service...
      The command completed successfully


      [root@node01 oracle]# crsctl check crs
      CSS appears healthy
      CRS appears healthy
      EVM appears healthy


      [root@node01 oracle]# ps -ef | grep lmon

      oracle 5741 1 0 12:07 ? 00:00:03 ora_lmon_hitesh1
      root 22582 20805 0 13:01 pts/2 00:00:00 grep lmon
      oracle 23643 1 0 11:58 ? 00:00:01 asm_lmon_+ASM1

      Please let me know what information else is required

      Edited by: user12924280 on Apr 6, 2013 12:36 AM