This discussion is archived
4 Replies Latest reply: Aug 16, 2013 7:04 AM by Flávio Soares RSS

Sqlplus is hanging on RAC1 node

KrishnaAgnihotri Explorer
Currently Being Moderated

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points