4 Replies Latest reply: Aug 16, 2013 9:04 AM by Flávio Soares RSS

    Sqlplus is hanging on RAC1 node

    KrishnaAgnihotri

      Hi all,

       

      I have 3 Node RAC DB (11.2.0.3). When i am trying to connect sqlplus to rac 1 , there is no error but i am not getting sqlplus prompt.

       

      RAC 1 : sqlplus "/as sysdba" -- Hangs

      RAC 2 : sqlplus "/as sysdba" -- getting prompt

      RAC 3 : sqlplus "/as sysdba" -- getting prompt

       

       

      from RAC 2 : sqlplus sys/password@rac1 as sysdba -- Hangs

      RAC 3 : sqlplus sys/password@rac1 as sysdba -- Hangs

       

      RAC 2 : sqlplus "/as sysdba" -- getting prompt but when i query any thing from gv$session, then it hangs.

       

      there is no error in alert log and cput utilization on RAC 1 is 5-10% only (Which is normal).

       

      Kindly inform me how i can resolve this issue.

       

      Thanks

      Krishna