Home » RDBMS Server » Networking and Gateways » oracle listener problem TNS12518 (oracle 10.2.0.4.0 windows server 2003 sp2 )
icon14.gif  oracle listener problem TNS12518 [message #394659] Sun, 29 March 2009 11:46 Go to next message
oraclevijay
Messages: 10
Registered: November 2008
Junior Member
Dear Oracle Experts,

I am facing a continuous problem in oracle production database.I got the below error messages in listener.log


TNS-12518: TNS:listener could not hand off client connection
TNS-12560: TNS:protocol adapter error
28-MAR-2009 21:18:22 * (CONNECT_DATA=(SERVER=DEDICATED)(SID=acl)(CID=(PROGRAM=)
(HOST=ipmon01.standard.isoft.net)(USER=ipmon))) * (ADDRESS=(PROTOCOL=tcp)
(HOST=170.215.16.22)(PORT=51551)) * establish * acl * 12518
TNS-12518: TNS:listener could not hand off client connection
TNS-12560: TNS:protocol adapter error
......
continuosly coming....like this


my temporary solution is just restarting the listener
and the error again comes within in a couple of hours..


my oracle database configuration is
oracle 10.2.0.4 WINDOWS recently upgraded from 9.2.0.5 without applying any patch


RAM 8 GB
ORACLE USAGE 1.324GB
available free physical memory 6gb
only one database installed in server.

os MICROSOFT WINDOWS SERVER 2003 R2 ENTERPRISE EDITION SERVICE PACK 2

SERVER DEDICATED
DIRECT_HANDOFF_TTC=off
server has intial 3gb and maximun 4gb virutal memory

sga_target='1100M'
pga_aggregate_target='750M'
sessions=335
processes=300
transactions=368
large_pool_size=0

Server is in Automatic Storage Management

when number of sesssion increased to 75 and above
i am getting ths error

In the downtime of database , i have altered sga=1000mb and pga=800mb after a couple of days i am again facing the error

please,anybody can share you are ideas
Thanks in Advance
Vijay.S

[Updated on: Sun, 29 March 2009 11:49]

Report message to a moderator

Re: oracle listener problem TNS12518 [message #394661 is a reply to message #394659] Sun, 29 March 2009 12:01 Go to previous message
BlackSwan
Messages: 23158
Registered: January 2009
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/

The Posting Guidelines clearly state you should SEARCH forum before posting.

http://www.orafaq.com/search
Search words: 12560 Total hits: 251
Search time: 0.089 seconds Run time: 0.100 seconds

Do you claim that none of the 251 posts give you any clue?

[Updated on: Sun, 29 March 2009 12:05]

Report message to a moderator

Previous Topic: ora-12012 &ora-06556 & ora-06512
Next Topic: Listener intermittently drops
Goto Forum:
  


Current Time: Sun Dec 21 13:12:21 CST 2014

Total time taken to generate the page: 0.05774 seconds