TNS-12516: TNS:listener could not find available handler with matching prot
Hi Team,
I am getting below error in the listener log, for the set of which is connecting to the database server. But other client server successfully making the connection to the DB server(confirmed by seeing the listener log). processes also not reached max limit. listener is also up and running TNS which we used in client side also not changed for many years. What could be the reason this error. Is there any reason “.WORLD” used in the TNS. Please help me
NS-12516: TNS:listener could not find available handler with matching protocol stack
LIVE:sgh8003:testuser$ cat tnsnames.ora
# tnsnames.ora network configuration file in
# /opt/oracle/product/9.2.0/network/admin
#
# For Oracle client installations, tnsnames.ora
# only needs the PV.WORLD entry.
SV.WORLD =
(DESCRIPTION =
(ENABLE=BROKEN)
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = sgh8004)
(PORT = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = SV.WORLD)
(INSTANCE_NAME = SV)
)
)
LIVE:sgh8003:testuser$ cat sqlnet.ora
# SQLNET.ORA Network Configuration File: /apps/oracle/product/9.2.0/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.
NAMES.DEFAULT_DOMAIN = WORLD
NAMES.DIRECTORY_PATH= (TNSNAMES)
Thanks.