listener could not hand off client connection [message #526653] |
Wed, 12 October 2011 04:49 |
dba_7722
Messages: 197 Registered: August 2010 Location: Delhi
|
Senior Member |
|
|
HI Expert,
I am getting error "ORA-12518: TNS:listener could not hand off client connection". This is for dedicated server.
I have check process paratere and that is with value 1000. Also i have checked few other dynamics view. Please suggest on further.
Thanks.
SQL> show parameter process
NAME TYPE VALUE
------------------------------------ -------------------------------- ------------------------------
aq_tm_processes integer 1
cell_offload_processing boolean TRUE
db_writer_processes integer 6
gcs_server_processes integer 0
global_txn_processes integer 1
job_queue_processes integer 1000
log_archive_max_processes integer 4
processes integer 1000
SQL> select * from v$resource_limit where resource_name='processes';
RESOURCE_NAME CURRENT_UTILIZATION MAX_UTILIZATION INITIAL_AL LIMIT_VALU
------------------------------ ------------------- --------------- ---------- ----------
processes 160 519 1000 1000
|
|
|
|
|