ORA-12519, TNS:no appropriate service handler found !http://www./2009/04/ora-12519_tnsno_appropriate_service_handler_found.html
set heading off spool on select p.SPID from v$session s,v$process p where s.paddr= p.addr and s.machine='woogle'; spool off set serveroutput on ; declare v_sid number; v_serial number; v_sql varchar2(200) ; CURSOR cur_session is select sid, serial# from v$session where machine='woogle'; begin open cur_session ; fetch cur_session into v_sid , v_serial ; while cur_session%found loop dbms_output.put_line(v_sid||' killed!') ; v_sql:= 'alter system kill session '||''''||v_sid||','||v_serial||''''; execute immediate v_sql ; fetch cur_session into v_sid , v_serial ; end loop ; close cur_session ; end ; / Linux 下快速删除不活动进程 #!/bin/bash tmpfile=/tmp/tmp.$$ sqlplus ' / as sysdba' << EOF set heading off spool on spool $tmpfile select p.SPID from v$session s,v$process p where s.paddr= p.addr and s.STATUS='SNIPED'; spool off set serveroutput on ; declare v_sid number; v_serial number; v_sql varchar2(200) ; CURSOR cur_session is select sid, serial# from v$session where STATUS='SNIPED'; begin open cur_session ; fetch cur_session into v_sid , v_serial ; while cur_session%found loop dbms_output.put_line(v_sid||' killed!') ; v_sql:= 'alter system kill session '||''''||v_sid||','||v_serial||''''; execute immediate v_sql ; fetch cur_session into v_sid , v_serial ; end loop ; close cur_session ; end ; / skate with the listener, and are accepting connections. 检查lsnrctl service ,instance已经注册, 状态显示ready时,可以连接。 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: ora-12519 or ora-12516 所以,listener显示的连接数和当前实际的连接数可能不同。 2.select value from v$parameter where name = 'processes'; 取得进程数的上限。 3.如已达到上限,修改initSID.ora中的processes的大小。 4.重新启动数据库到nomount状态下,执行create spfile from pfile; 并startup open。 |
|