Oracle Database Discussions

Sir ,

My listener was continously getting freezed and users from appln server couldnt connect to db .. i used to get an error of pooling in listner log

TNS-12518: TNS:listener could not hand off client connection
TNS-12564: TNS:connection refused
TNS-12602: TNS: Connection Pooling limit reached
TNS-00524: Current operation is still in progress
Linux Error: 115: Operation now in progress


Then i entered a setting in listener.ora DIRECT_HANDOFF_TTC_LISTENER=OFF and i stopped getting that error in the log

but yet my application users would not get connected intermittenlty without errors in listener log as well as alert log

then i tried restarting apache,resin from application end and also restarted the db ... yet it would fail

then i did the following below changes and it started working properly

1. in the listener.ora file put queue size =400
2. created one file called protocol.ora
and put the line tcp.nodelay = yes
3. created a file sqlnet.ora

and put the below lines
tcp.nodelay = YES

automatic_ipc = ON

USE_DEDICATED_SERVER=OFF

BEQUEATH_DETACH=YES

sqlnet.expire_time = 2

DEFAULT_SDU_SIZE=32768

SQLNET.SEND_BUF_SIZE=32768

SQLNET.RECV_BUF_SIZE=32768

i restarted the listener and its working fine since 24 hours what do u think could be the issue any ideas ?

system details
standalone db server
2gb ram
centos os

Total System Global Area 1073741824 bytes

Fixed Size 1271468 bytes

Variable Size 364906836 bytes

Database Buffers 683671552 bytes

Redo Buffers 23891968 bytes





large_pool_size big integer

52M



RESOURCE_NAME CURRENT_UTILIZATION MAX_UTILIZATION INITIAL_AL LIMIT_VALU

------------------------------ ------------------- --------------- ---------- ----------

processes 49 397 500 500



SQL> show parameter process;



NAME TYPE VALUE

------------------------------------ -------------------------------- ------------------------------

aq_tm_processes integer 0

db_writer_processes integer 4

gcs_server_processes integer 0

job_queue_processes integer 1

log_archive_max_processes integer 2

processes integer 500

Edited by: user8764012 on 02-Sep-2010 00:18