1.查询出正在执行的job,
select * from dba_jobs_running;
2.停止该job
declare
beginDBMS_JOB.BROKEN(27,true);
end;
3.根据sid查询出session信息
select SID,SERIAL# from V$Session where SID='9';
4.kill session
alter system kill session '9,43767';
ora-00031:标记要终止的会话
select spid, osuser, s.program from v$process p, v$session s where p.addr=s.paddr and s.sid = 9;
命令行 orakill ORCL 9208; (ORCL:实例名 9208:刚查到的线程号)
远程通过命令行开启局域网计算机的远程桌面服务(Description = RPC 服务器不可用 可能原因135 445端口未开启)
Wmic /node:"[200.200.200.207]" /USER:"Administrator" PAT
win32_terminalservicesetting WHERE (__Class!="") CALL SetAllowTSConnections 1