{"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 
 Information in this document applies to any platform. <\/p>

SYMPTOMS<\/p>

 ORA-12012: error on auto execute of job "SYS"."ORA$AT_OS_OPT_SY_7165" 
 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>

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>","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"}