Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

TNS-518 with Linux Error: 104: Connection reset by peer

446673Mar 14 2008 — edited Apr 11 2008

I have this problem with one of my databases. Every so often 2 - 3 months of uptime my
Listener will stop handing off connection to the db. No error messages in the alert log so it appears that it is probably a Linux resource causing the listener to stop working but I can not figure it out. This is a fairly busy test database

OS Redhat 4
Oracle Version 10.2.0.4 patch

Some Stats from the database .

current processes=34 max=500
Current Login=94 Cumulative=167,326 High Water=134
Dispatchers (6) Established=380 Refused=486 Current=100 Max=6132
Max Sessions=1500
Processes 500

Error From listener.log

14-MAR-2008 12:06:11 * (CONNECT_DATA=(SID=testdev)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=x.x.x.x)(PORT=33564)) * establish * testdev * 12518
TNS-12518: TNS:listener could not hand off client connection
TNS-12547: TNS:lost contact
TNS-12560: TNS:protocol adapter error
TNS-00517: Lost contact
Linux Error: 104: Connection reset by peer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 9 2008

Added on Mar 14 2008

#general-database-discussions

2 comments

1,673 views