Listener

How to Resolve The listener supports no services

Posted on
The Listener Supports Services
The listener supports no services I newly created a database called SMALLDB, but I can’t see any service registered with the new LISTENER2 which is listening to incoming connections from port 1522. The listener showed “The listener supports no services”. In fact, this message tells us that the listener is working fine, but no dynamic […]
Listener

How to Resolve TNS-12518 + TNS-12560 on Windows Server

Posted on
Found repeated Oracle TNS error messages in listener log during peak-hours on Windows Server 2008. … 19-Oct-2010 05:32:10 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ORCL11)(CID=(PROGRAM=C:ap001client.exe)(HOST=WIN3451)(USER=EDCHEN))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.1.2.3)(PORT=49874)) * establish * ORCL11 * 12518 TNS-12518: TNS:listener could not hand off client connection ORA-12560: TNS:protocol adapter error … The error pattern combined with TNS-12518 and TNS-12560, and it repeated itself until some […]