search

littlecowk35 / eic-quan-ly-cong-van

Automatically exported from code.google.com/p/eic-quan-ly-cong-van
0 stars 0 forks source link

Caused by: oracle.net.ns.NetException: Listener refused the connection with the following error: ORA-12518, TNS:listener could not hand off client connection #8

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
http://itbloggertips.com/2013/06/fixed-ora-12518-tnslistener-could-not-hand-off-
client-connection/

Original issue reported on code.google.com by ntanh...@gmail.com on 5 Aug 2014 at 10:15

GoogleCodeExporter commented 9 years ago 
SQL> shutdown immediate;

SQL> Startup;

Original comment by ntanh...@gmail.com on 5 Aug 2014 at 10:16

GoogleCodeExporter commented 9 years ago 
http://oracleworld-hands.blogspot.com/2012/01/ora-12518-tnslistener-could-not-ha
nd.html

Original comment by ntanh...@gmail.com on 5 Aug 2014 at 2:36

GoogleCodeExporter commented 9 years ago 
check type or server dedicate or shared?

cat /u01/app/oracle/product/11.2.0/xe/network/admin/tnsnames.ora

# tnsnames.ora Network Configuration File:

XE =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = pcdhserver)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = XE)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

Original comment by ntanh...@gmail.com on 5 Aug 2014 at 2:48

GoogleCodeExporter commented 9 years ago 
Check log of listener.
sudo cat  /u01/app/oracle/diag/tnslsnr/pcdhserver/listener/trace/listener.log 

Found these errors
TNS-12518: TNS:listener could not hand off client connection
 TNS-12540: TNS:internal limit restriction exceeded

Original comment by ntanh...@gmail.com on 5 Aug 2014 at 3:18

GoogleCodeExporter commented 9 years ago 
Try follow this link
http://www.dba-oracle.com/t_ora_12540_tns_internal_limit_restriction_exceeded.ht
m

Original comment by ntanh...@gmail.com on 5 Aug 2014 at 3:40

GoogleCodeExporter commented 9 years ago 
The dedicated server should have only one instance on service. So do NOT 
configure any other dispatchers for server type of dedicated.
alter system set DISPATCHERS = '(protocol=tcp)(dispatchers=0)';

Original comment by ntanh...@gmail.com on 6 Aug 2014 at 11:13

GoogleCodeExporter commented 9 years ago

Original comment by ntanh...@gmail.com on 14 Aug 2014 at 1:27