اعزائي مهندسي منتدي اوراكل احتاج منكم المساعده بخصوص الرساله التاليه
[ora-12518 tns listener could not hand off client connection]]
حيث انني احتاج الي عمل ريسترات للسيرفر في الاسبوع مرتين ولم اجد حل للمشكله غير عمل الريستارت

السلام عليكم ورحمه الله وبركاته
اخى العزيز
ادخل على المسار الخاص بملف Listener.ora طبقا لمسار الاوراكل عندك وخد منه باكاب
وعدل فيه باضافه السطر الاتى

DIRECT_HANDOFF_TTC_LISTENER=OFF

و اكتبلنا نتيجه الكويري دى

Show Sga ; 
show parameter large_pool_size;

تحياتى

great thanks to you for fast replay and find the result when run query
SQL> Show Sga ;

Total System Global Area 1216348160 bytes
Fixed Size 1298160 bytes
Variable Size 595591440 bytes
Database Buffers 612368384 bytes
Redo Buffers 7090176 bytes
SQL> show parameter large_pool_size;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
large_pool_size big integer 0
SQL>

SQL> Show Sga ; 

Total System Global Area 1216348160 bytes
Fixed Size                  1298160 bytes
Variable Size             595591440 bytes
Database Buffers          612368384 bytes
Redo Buffers                7090176 bytes
SQL> show parameter large_pool_size;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
large_pool_size                      big integer 0

وايه نتيجه اضافه البارامتر فى ملف Listener.ora وعمل رستارت ل Listener service ؟

dear ahmed
thanks to you for response but no result after i add DIRECT_HANDOFF_TTC_LISTENER=OFF but i find this error database message

TNS-12518 TNS:listener could not hand off client connection
Cause: The process of handing off a client connection to another process failed.
Action: Turn on listener tracing and re-execute the operation. Verify that the
listener and database instance are properly configured for direct handoff. If the
problem persists, contact Oracle Support Services.

Hello engemh


this problem occurs when the value of the parametetr PROCESSES in your database spfile is set to a very minimum value so when the connections increases on the database the listener will not be able to accept new connections and this error arises.

you should increase the PROCESSES parameter and restart your database.

Hope this will help you.