设为首页 加入收藏

TOP

Oracle 18.3 ORA-12012 ORA-20001
2019-07-10 20:11:25 】 浏览:21
Tags:Oracle 18.3 ORA-12012 ORA-20001

问题:   


[oracle@oracle-server001 trace]$ pwd


/u01/app/oracle/diag/rdbms/chendb/chendb/trace


[oracle@oracle-server001 trace]$ vi alert_chendb.log


......


2019-01-03T01:28:08.337087+08:00


Errors in file /u01/app/oracle/diag/rdbms/chendb/chendb/trace/chendb_j000_84302.trc:


 ORA-12012: error on auto execute of job "SYS"."ORA$AT_OS_OPT_SY_2612" 


 ORA-20001: Statistics Advisor: Invalid task name for the current user 


ORA-06512: at "SYS.DBMS_STATS", line 49538


ORA-06512: at "SYS.DBMS_STATS_ADVISOR", line 881


ORA-06512: at "SYS.DBMS_STATS_INTERNAL", line 21631


ORA-06512: at "SYS.DBMS_STATS_INTERNAL", line 23763


ORA-06512: at "SYS.DBMS_STATS", line 49526


2019-01-03T01:38:13.791103+08:00


环境说明:   


DB:Oracle 18.3.0.0.0


问题原因: 


Bug 22879263    - BETA 12.2 - ORA-12012 , ORA-20001 AND ORA-06512 FROM ORA$AT_OS_OPT_SY_88 JOB 


解决方案:   


1.Bug is fixed in 12.2.0.1.0.


2.Use following workaround:


 execute "  EXEC dbms_stats.init_package();  "


---support.oracle.com 上    详细说明如下 


Recurring ORA-12012, ORA-20001, ORA-06512 In Container Database (  文档 ID 2420581.1) 


 APPLIES TO: 


 Oracle Database - Enterprise Edition - Version 12.2.0.1 and later 
 Information in this document applies to any platform. 


SYMPTOMS


 ORA-12012: error on auto execute of job "SYS"."ORA$AT_OS_OPT_SY_7165" 
 ORA-20001: Statistics Advisor: Invalid task name f

or the current user 
 ORA-06512: at "SYS.DBMS_STATS", line 47207 
 ORA-06512: at "SYS.DBMS_STATS_ADVISOR", line 882 
 ORA-06512: at "SYS.DBMS_STATS_INTERNAL", line 20059 
 ORA-06512: at "SYS.DBMS_STATS_INTERNAL", line 22201 
 ORA-06512: at "SYS.DBMS_STATS", line 47197 


CHANGES 


CAUSE 


 This is due to following unpublished bug: 


 Bug 22879263 - BETA 12.2 - ORA-12012 , ORA-20001 AND ORA-06512 FROM ORA$AT_OS_OPT_SY_88 JOB 


SOLUTION


execute "EXEC dbms_stats.init_package();"



编程开发网
】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
上一篇Oracle nvarchar2 错误解决方案 下一篇MySQL下FEDERATED引擎的开启和使用

评论

帐  号: 密码: (新用户注册)
验 证 码:
表  情:
内  容:

array(4) { ["type"]=> int(8) ["message"]=> string(24) "Undefined variable: jobs" ["file"]=> string(32) "/mnt/wp/cppentry/do/bencandy.php" ["line"]=> int(217) }