Unable To Connect To "idmsprodXDB" Service - ORA-12520: TNS:listener Could Not Find Available Handle (Doc ID 2152756.1)

Last updated on JUNE 22, 2016

Applies to:

Oracle Net Services - Version 12.1.0.1 and later
Information in this document applies to any platform.

Symptoms

================== Issue Clarification ==================

When trying to connect to the XDB service, the connections is failing with the error ORA-12520.  The lsnrctl output shows that the XDB services have registered with the listener.

SYS @ IDMSPROD > conn system/sys@idmsprodXDB <<<<<<<<<<<<<ERROR:
ORA-12520: TNS:listener could not find available handler for requested type of server


SYS @ IDMSPROD > show parameter dispatchers;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
dispatchers string (PROTOCOL=TCP) (SERVICE=idmsprodXDB)


C:\Users\icc>lsnrctl services

LSNRCTL for 64-bit Windows: Version 12.1.0.2.0 - Production on 13-JUN-2016 16:26
:07

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=HOSTNME.us.oracle.com)(PORT=1521)))
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 "idmsprod.us.oracle.com" has 1 instance(s).
 Instance "idmsprod", status READY, has 1 handler(s) for this service...
  Handler(s):
  "DEDICATED" established:88862 refused:0 state:ready
  LOCAL SERVER
Service "idmsprodXDB.us.oracle.com" has 1 instance(s).
 Instance "idmsprod", 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=HOSTNAME.us.oracle.com)(PORT=56033))
The command completed successfully
------------------------------------------------------------------------------------------------
The tnsnames.ora entry shows:

IDMSPRODXDB =
   (DESCRIPTION =
     (ADDRESS = (PROTOCOL = TCP)(HOST = ICCIDMSDB.ilcasco.com)(PORT = 1521))
       (CONNECT_DATA = 
        (SERVER = DEDICATED)
        (SERVICE_NAME = idmsprodxdb.us.oracle.com)
     )
   )

 

Changes

 None.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms