{"rsdb":{"rid":"314252","subhead":"","postdate":"0","aid":"227494","fid":"57","uid":"1","topic":"1","content":"
\u95ee\u9898\uff1a<\/strong> <\/p> [oracle@oracle-server001 trace]$ pwd<\/p> \/u01\/app\/oracle\/diag\/rdbms\/chendb\/chendb\/trace<\/p> [oracle@oracle-server001 trace]$ vi alert_chendb.log<\/p> ......<\/p> 2019-01-03T01:28:08.337087+08:00<\/p> Errors in file \/u01\/app\/oracle\/diag\/rdbms\/chendb\/chendb\/trace\/chendb_j000_84302.trc:<\/p> ORA-12012: error on auto execute of job "SYS"."ORA$AT_OS_OPT_SY_2612" <\/p> ORA-20001: Statistics Advisor: Invalid task name for the current user <\/p> ORA-06512: at "SYS.DBMS_STATS", line 49538<\/p> ORA-06512: at "SYS.DBMS_STATS_ADVISOR", line 881<\/p> ORA-06512: at "SYS.DBMS_STATS_INTERNAL", line 21631<\/p> ORA-06512: at "SYS.DBMS_STATS_INTERNAL", line 23763<\/p> ORA-06512: at "SYS.DBMS_STATS", line 49526<\/p> 2019-01-03T01:38:13.791103+08:00<\/p> \u73af\u5883\u8bf4\u660e\uff1a <\/strong><\/p> DB:Oracle 18.3.0.0.0<\/p> \u95ee\u9898\u539f\u56e0\uff1a <\/strong><\/p> Bug 22879263 - BETA 12.2 - ORA-12012 , ORA-20001 AND ORA-06512 FROM ORA$AT_OS_OPT_SY_88 JOB <\/p> \u89e3\u51b3\u65b9\u6848\uff1a<\/strong> <\/p> 1.Bug is fixed in 12.2.0.1.0.<\/p> 2.Use following workaround:<\/p> execute " EXEC dbms_stats.init_package(); "<\/p> ---support.oracle.com \u4e0a \u8be6\u7ec6\u8bf4\u660e\u5982\u4e0b <\/p> Recurring ORA-12012, ORA-20001, ORA-06512 In Container Database ( \u6587\u6863 ID 2420581.1) <\/p> APPLIES TO: <\/p> Oracle Database - Enterprise Edition - Version 12.2.0.1 and later SYMPTOMS<\/p> ORA-12012: error on auto execute of job "SYS"."ORA$AT_OS_OPT_SY_7165" CHANGES <\/p> CAUSE <\/p> This is due to following unpublished bug: <\/p> Bug 22879263 - BETA 12.2 - ORA-12012 , ORA-20001 AND ORA-06512 FROM ORA$AT_OS_OPT_SY_88 JOB <\/p> SOLUTION<\/p> execute "EXEC dbms_stats.init_package();"<\/p>
Information in this document applies to any platform. <\/p>
ORA-20001: Statistics Advisor: Invalid task name for 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 <\/p>
","orderid":"0","title":"Oracle 18.3 ORA-12012 ORA-20001","smalltitle":"","mid":"0","fname":"\u6570\u636e\u5e93\u7f16\u7a0b","special_id":"0","bak_id":"0","info":"0","hits":"170","pages":"1","comments":"0","posttime":"2019-07-10 20:11:25","list":"1562760685","username":"admin","author":"","copyfrom":"","copyfromurl":"","titlecolor":"","fonttype":"0","titleicon":"0","picurl":"https:\/\/www.cppentry.com\/upload_files\/","ispic":"0","yz":"1","yzer":"","yztime":"0","levels":"0","levelstime":"0","keywords":"Oracle<\/A> 18.3<\/A> ORA-12012<\/A> ORA-20001<\/A>","jumpurl":"","iframeurl":"","style":"","template":"a:3:{s:4:\"head\";s:0:\"\";s:4:\"foot\";s:0:\"\";s:8:\"bencandy\";s:0:\"\";}","target":"0","ip":"47.106.78.186","lastfid":"0","money":"0","buyuser":"","passwd":"","allowdown":"","allowview":"","editer":"","edittime":"0","begintime":"0","endtime":"0","description":"Oracle 18.3 ORA-12012 ORA-20001","lastview":"1712971754","digg_num":"0","digg_time":"0","forbidcomment":"0","ifvote":"0","heart":"","htmlname":"","city_id":"0"},"page":"1"}