9 Replies Latest reply: Mar 6, 2008 6:51 AM by 548866 RSS

    Instance status "BLOCKED" and ora-12528

    463181
      Oralce 10.2.0.1 -- SUN SPARC 10 64bit

      instance is in nomount state, can connect using "sys/passwd@string as sysdba" on node 1 but unable to connect from 2nd node. following error received.

      Node:2
      connect sys/passwd@string as sysdba;
      ERROR:
      ORA-12528: TNS:listener: all appropriate instances are blocking new connections

      Listener state on node 1 is following:

      Service "PLSExtProc" has 1 instance(s).
      Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
      Service "string" has 1 instance(s).
      Instance "string", status BLOCKED, has 1 handler(s) for this service...
      Service "string" has 1 instance(s).
      Instance "string", status UNKNOWN, has 1 handler(s) for this service...
      Service "string_XPT" has 1 instance(s).
      Instance "string", status BLOCKED, has 1 handler(s) for this service...

      Message was edited by:
      jees