Knowledge Base

You reached the PROCESSES limit

ORA-12516: TNS:listener could not find available handler with matching protocol stack

None of the known and available service handlers for the given SERVICE_NAME support the client’s protocol stack: protocol, presentation, and session.

Check that the service handlers (e.g. dispatchers) for given SERVICE_NAME are registered with the listener, and that they are properly configured to support the desired protocols and presentations, and are accepting connections.

You might also want to check if the number of connections reaches the database’s PROCESSES parameter using following Unix command:

ps -ef | grep oracleSID | grep -v grep | wc -l
or 
ps aux | grep oracleSID | grep -v grep | wc -l

If the value found is close to the value of the PROCESSES database parameter value, you might want to augment this value using following command:

alter system set processes=new value [scope=spfile];

A database bounce is required to let the new value become active.

  • Omkar

    I just installed the oracle 11 g -win x 64 bit software in win 7 home premium operating system.
    1)with the following details
    global database name: “orcl”
    admin password: “Oracle11g”
    oracle system identifier(SID): “orcl”
    user: “system”
    after installation complete then it displayed
    The db control URL is : “https://localhost:1158/em”.

    2)This is my tnsnames.ora..
    # tnsnames.ora Network Configuration File: C:appammaproduct11.2.0dbhome_1networkadmintnsnames.ora
    # Generated by Oracle configuration tools.

    ORACLR_CONNECTION_DATA =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
    (CONNECT_DATA =
    (SID = CLRExtProc)
    (PRESENTATION = RO)
    )
    )

    ORCL =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = orcl)
    )
    )

    3)and i checked this..
    C:>lsnrctl services

    LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 – Production on 13-OCT-2012 13:06
    :55

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

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
    Services Summary…
    Service “CLRExtProc” has 1 instance(s).
    Instance “CLRExtProc”, status UNKNOWN, has 1 handler(s) for this service…
    Handler(s):
    “DEDICATED” established:0 refused:0
    LOCAL SERVER
    Service “orcl” has 1 instance(s).
    Instance “orcl”, status READY, has 1 handler(s) for this service…
    Handler(s):
    “DEDICATED” established:80 refused:0 state:ready
    LOCAL SERVER
    Service “orclXDB” has 1 instance(s).
    Instance “orcl”, status READY, has 1 handler(s) for this service…
    Handler(s):
    “D000″ established:0 refused:0 current:0 max:1022 state:ready
    DISPATCHER
    (ADDRESS=(PROTOCOL=tcp)(HOST=amma-VAIO)(PORT=49173))
    The command completed successfully
    when i use this..

    Class.forName(“oracle.jdbc.OracleDriver”);
    DriverManager.getConnection(“jdbc:oracle:thin:@//localhost:1158/em”,”system”,”Oracle11g”);
    // and i tried with 1521/em also

    But i get this exception at runtime! can anyone help me out please!

    java.sql.SQLException: The Network Adapter could not establish the connection at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:412) at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:531) at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:221) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:503) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at DbOperations_Oracle_Type4.(DbOperations_Oracle_Type4.java:26) at DbOperations_Oracle_Type4.main(DbOperations_Oracle_Type4.java:141)Caused by: oracle.net.ns.NetException: The Network Adapter could not establish the connection at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:359) at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:422) at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:672) at oracle.net.ns.NSProtocol.connect(NSProtocol.java:353) at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1042) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:301) … 8 moreCaused by: java.net.ConnectException: Connection refused: connect at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.PlainSocketImpl.doConnect(Unknown Source) at java.net.PlainSocketImpl.connectToAddress(Unknown Source) at java.net.PlainSocketImpl.connect(Unknown Source) at java.net.SocksSocketImpl.connect(Unknown Source) at java.net.Socket.connect(Unknown Source) at oracle.net.nt.TcpNTAdapter.connect(TcpNTAdapter.java:141) at oracle.net.nt.ConnOption.connect(ConnOption.java:123) at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:337) … 13 moreSelect ur choise!1.Creating table2.Drop table3.inserting data4.view data5.exitException in thread “main” java.lang.NullPointerException at DbOperations_Oracle_Type4.go(DbOperations_Oracle_Type4.java:155) at DbOperations_Oracle_Type4.main(DbOperations_Oracle_Type4.java:141)

Oracle Gold Partner DbMotive is an Oracle Gold Partner