首页 > 代码库 > ORA-12012 error on auto execute of job 8887
ORA-12012 error on auto execute of job 8887
*** ACTION NAME:(AUTO_SPACE_ADVISOR_JOB) 2014-10-22 22:49:58.046*** MODULE NAME:(DBMS_SCHEDULER) 2014-10-22 22:49:58.046*** SERVICE NAME:(SYS$USERS) 2014-10-22 22:49:58.046*** SESSION ID:(112.762) 2014-10-22 22:49:58.046*** 2014-10-22 22:49:58.046ORA-12012: error on auto execute of job 8887ORA-44003: invalid SQL name
SQL> Select * from v$version; BANNER----------------------------------------------------------------Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProdPL/SQL Release 10.2.0.1.0 - ProductionCORE 10.2.0.1.0 ProductionTNS for 32-bit Windows: Version 10.2.0.1.0 - ProductionNLSRTL Version 10.2.0.1.0 - Production
网上查看说这个是一个bug,禁用掉该JOB
conn "/as sysdba"
execute dbms_scheduler.disable(‘AUTO_SPACE_ADVISOR_JOB‘);
参考博客：
http://www.xifenfei.com/2305.html
http://blog.itpub.net/9524377/viewspace-660845/
ORA-12012 error on auto execute of job 8887
声明：以上内容来自用户投稿及互联网公开渠道收集整理发布，本网站不拥有所有权，未作人工编辑处理，也不承担相关法律责任，若内容有误或涉及侵权可进行投诉： 投诉/举报 工作人员会在5个工作日内联系你，一经查实，本站将立刻删除涉嫌侵权内容。