oracle sysman下job EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS();禁用

sysman EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS() 这个任务是和EM 相关的任务，在数据库中频率为1分钟一次，如果碰到异常问题，容易引起性能问题，所以在用不到em的数据库中，可以禁掉

--查看EM使用端口,默认是1158和3938
cd $ORACLE_HOME/install
more portlist.ini 
 
iSQL*Plus HTTP port number =5560
iSQL*Plus HTTP port number =5560
Enterprise Manager Console HTTP Port (testa) = 1158
Enterprise Manager Agent Port (testa) = 3938

--确认em端口没有在用

netstat -tnlp |grep 1158

netstat -tnlp |grep 3938

--查看dbconsole状态,确认em是关闭的状态
emctl status dbconsole
 
TZ set to PRC
perl: warning: Setting locale failed.
perl: warning: Please check that your locale settings:
        LANGUAGE = (unset),
        LC_ALL = (unset),
        LANG = "AMERICAN_AMERICA.ZHS16GBK"
    are supported and installed on your system.
perl: warning: Falling back to the standard locale ("C").
Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0  
Copyright (c) 1996, 2007 Oracle Corporation.  All rights reserved.
http://testa:1158/em/console/aboutApplication
Oracle Enterprise Manager 10g is not running. 
------------------------------------------------------------------

--如果EM开启并可关闭，关闭EM

emctl stop dbconsole

--删除sysman下em收集信息任务,这部操作需要用sysman用户登录。如果不记得sysman用户密码，可以修改。

EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS();

alter user sysman identified by oracle;

 

--logon as sysman

删除 emd_maintenance包
exec sysman.emd_maintenance.remove_em_dbms_jobs;
commit;

 

--查询dba_jobs确认job已删除