to pak ubaid, ini coba saya nyontek dr metalink, moga2 masalahnya sama n solusinya bs dpake.. Applies to: Oracle Net Services - Version: 9.2.0.1.0 to 11.1.0.6.0 This problem can occur on any platform. Checked for relevance on 15-FEB-2007. Symptoms Client connections may fail intermittently with any of the following errors:
TNS-12516 TNS: listener could not find instance with matching protocol stack ORA-12516 TNS: listener could not find instance with matching protocol stack TNS-12519 TNS: no appropriate service handler found ORA-12519 TNS: no appropriate service handler found Any or all of these errors might appear in the listener.log and may accompany an ORA-12520: ORA-12520 TNS:listener could not find available handler for requested type of server The output of the lsnrctl services command may show that the service handler is in a "blocked" state. e.g. '"DEDICATED" established:1 refused:0 state:blocked' Changes It is likely a significant increase in load has occurred. Cause By way of instance registration, PMON is responsible for updating the listener with information about a particular instance such as load and dispatcher information. Maximum load for dedicated connections is determined by the PROCESSES parameter. The frequency at which PMON provides SERVICE_UPDATE information varies according to the workload of the instance. The maximum interval between these service updates is 10 minutes. The listener counts the number of connections it has established to the instance but does not immediately get information about connections that have terminated. Only when PMON updates the listener via SERVICE_UPDATE is the listener informed of current load. Since this can take as long as 10 minutes, there can be a difference between the current instance load according to the listener and the actual instance load. When the listener believes the current number of connections has reached maximum load, it may set the state of the service handler for an instance to "blocked" and begin refusing incoming client connections with either of the following errors: TNS-12516 TNS:listener could not find instance with matching protocol stack TNS-12519 TNS:no appropriate service handler found Additionally, an ORA-12520 error may appear in the listener log. The output of the LSNRCTL services command will likely show that the service handler is "blocked". e.g. '"DEDICATED" established:1 refused:0 state:blocked' solution Increase the pfile or spfile setting for PROCESSES. CMIIW, [L] --- On Tue, 5/12/09, ubaid vh <[email protected]> wrote: From: ubaid vh <[email protected]> Subject: [indo-oracle] [ASK] TNS-12516: TNS:listener could not find available handler with matching protocol stack To: [email protected] Date: Tuesday, May 12, 2009, 3:58 PM Salam Buat Para MASTER-MASTER Help me Please.....! !! Ni mau curhat dikit. Saya pakek database Oracle 10g disini untuk aplikasi client saya menggunakan Delphi, awalnya beberapa Bulan sih Ok2 aj tapi sekarang sering Putus-Nyambung- Putus-Nyambung. Untuk pesen errornya seperti di bawah ini : TNS-12516: TNS:listener could not find available handler with matching protocol stack Mohon bantuan dari para MASTER2 ORACLE ya...!!!, ini permasalahannya dari mana dan gimana cara penyelesaiinnya. ..????? Thanks's ini potongan dari listner.log 12-MAY-2009 09:33:47 * (CONNECT_DATA= (CID=(PROGRAM= )(HOST=__ jdbc__)(USER= ))(SERVICE_ NAME=siak) ) * (ADDRESS=(PROTOCOL= tcp)(HOST= 127.0.0.2) (PORT=34465) ) * establish * siak * 12516 TNS-12516: TNS:listener could not find available handler with matching protocol stack [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
