4 Replies Latest reply: Jan 18, 2013 9:18 AM by sb92075 RSS

    TNS-12516: TNS:listener could not find available handler with matching prot

    user9256814
      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.