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

in Oracle Database; Hi folks Can anyone point me to the right direction to resolve this very strange error I am facing. I ...
+ Post Reply + Post New Topic
Results 1 to 6 of 6
  1. #1
    ora_student is offline Junior Member
    Points: 290, Level: 5
    Join Date
    02 Nov 2008
    Posts
    9
    Points
    290

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

    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. #2
    tyro's Avatar
    tyro is offline Forum Genius
    Points: 5,680, Level: 48
    Join Date
    20 Aug 2008
    Location
    India
    Posts
    368
    Points
    5,680

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

    i would suggest try restarting the server. did you try that?

  3. #3
    sameer's Avatar
    sameer is offline Forum Advisor
    Points: 2,240, Level: 28
    Join Date
    21 Aug 2008
    Posts
    105
    Points
    2,240

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

    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:
    "This is a known problem with Oracle 10g where a SHUTDOWN IMMEDIATE is followed by a STARTUP MOUNT. Try bouncing the instance and try again
    Learning is a path with no destination...

  4. #4
    ora_student is offline Junior Member
    Points: 290, Level: 5
    Join Date
    02 Nov 2008
    Posts
    9
    Points
    290

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

    Hello thanks for the replies guys. Sameer your solution was close. This is what I read and how i finally resolved the problem:
    Typically (in Oracle 9i and above), when you "shutdown" an Oracle database, that process "unregisters" the databse with the LISTENER. Then when you "startup" the database, it "registers" with the LISTENER.

    If the "unregister" did not complete properly, then when you go to "startup" the next time, since the LISTENER did not unregister the instance, you receive the error, "ORA-12528: TNS:listener: all appropriate instances are blocking new connections" since an "appropriate" instance is already running.
    This is how i checked the status of the listener:
    Code :
    # lsnrctl
    LSNRCTL> status

    Then I bounced the LISTENER as follows:
    Code :
    LSNRCTL> stop
    LSNRCTL> start
    Now finally I restarted the instance with sqlplus with sysdba privileges, making sure all parameters are set.
    Code :
    SQL> startup
    Hopefully this will help someone else facing the same problem.

  5. #5
    Arju is offline Forum Expert
    Points: 2,620, Level: 31
    Join Date
    09 Oct 2008
    Location
    Bangladesh
    Posts
    107
    Points
    2,620

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

    Post the output of
    lsnrctl services

  6. #6
    rbt007 is offline Junior Member
    Points: 10, Level: 1
    Join Date
    11 Dec 2010
    Posts
    1
    Points
    10

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

    same problem, i am also facing.

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

    inp1mo01racle: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

Other Solutions
  1. listener could not find available handler for requested type of server
    By rodnower in forum System Administration & Application DBA
    Replies: 3
    Last Post: 06-24-2010, 04:44 PM
  2. Database instances are up and running ?
    By sidharthmellam in forum Server Administration and Options
    Replies: 0
    Last Post: 11-09-2009, 06:46 AM
  3. Replies: 1
    Last Post: 11-03-2009, 03:28 PM
  4. Selective incremental replication between two instances?
    By kmicic in forum Server Administration and Options
    Replies: 6
    Last Post: 08-06-2009, 02:25 PM
  5. ORA-24778: cannot open connections:URGENT
    By pjsr in forum Server Administration and Options
    Replies: 6
    Last Post: 03-27-2009, 08:28 PM