Chinaunix首页 | 论坛 | 博客
  • 博客访问: 3218608
  • 博文数量: 710
  • 博客积分: 14546
  • 博客等级: 上将
  • 技术积分: 6738
  • 用 户 组: 普通用户
  • 注册时间: 2007-03-30 10:20
文章分类

全部博文(710)

文章存档

2016年(1)

2014年(7)

2013年(22)

2012年(227)

2011年(322)

2009年(119)

2008年(12)

分类: Oracle

2012-01-02 15:29:16

  1. ORA-12012: error on auto execute of job 8888
  2. ORA-13607: The specified task or object ORA-13607: The specified task or object SYS_AUTO_SPCADV_602230122011 already exists
  3. ORA-06512: at "SYS.PRVT_ADVISOR", line 3902
  4. ORA-06512: at "SYS.DBMS_ADVISOR", line 102
  5. ORA-06512: at "SYS.DBMS_SPACE", line 1328
  6. ORA-06512: at "SYS.DBMS_SPACE", line 1554

  1. Cause
  2. This is caused by Bug 7534067, where the time and date, that is used by the task name generation, are incorrect.
  3. The issue is fixed in 11.2 and 10.2.0.5.
  4. Solution
  5. Depending on the situation, following solutions are available:

  6. 10gR:
  7. o Apply patch set 10.2.0.4 + generic Patch 7534067
  8. o Apply patch set 10.2.0.5 (advised)

  9. 11gR1:
  10. o Apply patch set 11.1.0.7 + generic Patch 7534067

  11. In some cases (10.2.0.1 and 10.2.0.2), Patch 4707226 will also fix this error.
  12. If you cannot apply any of the previous solutions, download and apply patch 4707226 if appropriate.










阅读(3513) | 评论(0) | 转发(1) |
给主人留下些什么吧!~~