1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

ora-12528: TNS:Listener: All Appropriate instances are blocking new connections

Discussion in 'Server Administration and Options' started by ora_student, Apr 8, 2009.

  1. ora_student

    ora_student Active Member

    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    55
    Hi folks

    Can anyone point me to the right direction to resolve this very strange error I am facing. I say strange because the database runs for a while absolutely fine and suddenly this error comes up:

    ora-12528: TNS:Listener: All Appropriate instances are blocking new connections

    What is the resolution for this?

    Sunil
     
  2. tyro

    tyro Forum Genius

    Messages:
    368
    Likes Received:
    20
    Trophy Points:
    260
    Location:
    India
    i would suggest try restarting the server. did you try that?
     
  3. sameer

    sameer Forum Advisor

    Messages:
    105
    Likes Received:
    6
    Trophy Points:
    240
    Well I googled this for you

    ORA-12528: TNS:listener: all appropriate instances are blocking new connections

    Cause: All instances supporting the service requested by the client reported that they were blocking the new connections. This condition may be temporary, such as at instance startup.

    Action: Attempt the connection again. If error persists, then contact the administrator to check the status of the instances.

    And this is what came up from one another forum:
     
  4. ora_student

    ora_student Active Member

    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    55
    Hello thanks for the replies guys. Sameer your solution was close. This is what I read and how i finally resolved the problem:
    This is how i checked the status of the listener:
    Code (Text):

    # lsnrctl
    LSNRCTL> status
     
    Then I bounced the LISTENER as follows:
    Code (Text):

    LSNRCTL> stop
    LSNRCTL> start
     
    Now finally I restarted the instance with sqlplus with sysdba privileges, making sure all parameters are set.
    Code (Text):

    SQL> startup
     
    Hopefully this will help someone else facing the same problem.
     
  5. Arju

    Arju Forum Expert

    Messages:
    107
    Likes Received:
    5
    Trophy Points:
    240
    Location:
    Bangladesh
    Post the output of
    lsnrctl services
     
  6. rbt007

    rbt007 Guest

    same problem, i am also facing.

    i try to create clone db but unable create listner in nomount stage.

    inp1mo01:eek:racle:CLONE:/app/oracle/home/network/admin>lsnrctl services

    LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 11-DEC-2010 17:47:42

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

    Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
    Services Summary...
    Service "CLONE" has 1 instance(s).
    Instance "CLONE", status BLOCKED, has 1 handler(s) for this service...
    Handler(s):
    "DEDICATED" established:0 refused:0 state:ready
    LOCAL SERVER
    Service "CLONE_XPT" has 1 instance(s).
    Instance "CLONE", status BLOCKED, has 1 handler(s) for this service...
    Handler(s):
    "DEDICATED" established:0 refused:0 state:ready
    LOCAL SERVER
    The command completed successfully
    AND

    Enter user-name: sys/admin@CLONE
    ERROR:
    ORA-12528: TNS:listener: all appropriate instances are blocking new connections