1 2 Previous Next 17 Replies Latest reply: Jun 12, 2013 7:56 AM by Paul M. RSS

    all appropriate instances are blocking new connections

    947771
      hi,

      i am getting while connecting from sql devloper.
      -----------------
      An error was encountered performing the requested operation:

      Listener refused the connection with the following error:
      ORA-12528, TNS:listener: all appropriate instances are blocking new connections


      Vendor code 12528

      -------------------------

      LSNRCTL> status
      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
      STATUS of the LISTENER
      ------------------------
      Alias LISTENER
      Version TNSLSNR for 32-bit Windows: Version 11.2.0.2.0 - Produ
      ction
      Start Date 12-MAY-2013 18:57:17
      Uptime 0 days 0 hr. 4 min. 58 sec
      Trace Level off
      Security ON: Local OS Authentication
      SNMP OFF
      Default Service XE
      Listener Parameter File C:\oraclexe\app\oracle\product\11.2.0\server\network\a
      dmin\listener.ora
      Listener Log File C:\oraclexe\app\oracle\diag\tnslsnr\gg\listener\al
      ert\log.xml
      Listening Endpoints Summary...
      (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=gg.g1.COM)(PORT=1521)))

      Services Summary...
      Service "PLSExtProc" has 1 instance(s).
      Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
      Service "XE" has 2 instance(s).
      Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
      Instance "xe", status BLOCKED, has 1 handler(s) for this service...
      The command completed successfully
      LSNRCTL>
      --------------------

      after stop and start when i checked status

      the blocked message was not there but others part of the message was same . and when i tried to connect still it was not connecting and giveing same message written on top.

      then i tried to use
      sql> startup

      insuficent previlage.

      -----------------------

      i have also added. GLOBAL_DBNAME as follows.

      ----------------------------
      SID_LIST_LISTENER:

      (SID_DESC =
      (GLOBAL_DBNAME =%DBNAME%)
      (ORACLE_HOME = %Oracle_Home%)
      (SID_NAME = %SID%)
      )

      but nothing happend

      yours sincerely

      Edited by: 944768 on May 13, 2013 12:29 AM
        1 2 Previous Next