Home » RDBMS Server » Server Administration » Oracle Listener problem TNS-12518 (oracle 10.2.0.4.0 windows server 2003 sp2)
Oracle Listener problem TNS-12518 [message #394662] Sun, 29 March 2009 12:26 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.americanstandard.ip-soft.net)(USER=ipmon))) * (ADDRESS=(PROTOCOL=tcp)
(HOST=170.205.13.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_target=800mb and pga_aggregate_target=700mb after a couple of days i am again facing the error

please,anybody can share you are ideas
Thanks in Advance
Vijay.S
Re: Oracle Listener problem TNS-12518 [message #394663 is a reply to message #394662] Sun, 29 March 2009 12:29 Go to previous message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/m/394661/136107/#msg_394659

Follow Posting Guideline & do NOT cross/muli-post!

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

Report message to a moderator

Previous Topic: How to bring up database automatically on Solaris10 when rebooting
Next Topic: IPC Send timeout detected. Receiver ospid 24104
Goto Forum:
  


Current Time: Tue Dec 06 06:07:47 CST 2016

Total time taken to generate the page: 0.08888 seconds