安装完成12.2.0.1数据库后发现APEX_030200下有很多失效的对象,而且有定时任务job在跑,从错误日志发现如下:
ORA12CPDB3(4):*****************************************************************
ORA12CPDB3(4):An internal routine has requested a dump of selected redo.
ORA12CPDB3(4):This usually happens following a specific internal error, when
ORA12CPDB3(4):analysis of the redo logs will help Oracle Support with the
ORA12CPDB3(4):diagnosis.
ORA12CPDB3(4):It is recommended that you retain all the redo logs generated (by
ORA12CPDB3(4):all the instances) during the past 12 hours, in case additional
ORA12CPDB3(4):redo dumps are required to help with the diagnosis.
ORA12CPDB3(4):*****************************************************************
2020-03-19T09:10:50.782957+08:00
ORA12CPDB2(5):Errors in file /u01/app/oracle/diag/rdbms/ora12c/ora12c/trace/ora12c_j000_29477.trc:
ORA-12012: error on auto execute of job 4002
ORA-04063: package body "APEX_030200.WWV_FLOW_MAIL" has errors
ORA-06508: PL/SQL: could not find program unit being called: "APEX_030200.WWV_FLOW_MAIL"
ORA-06512: at line 1
若是不需要APEX的话 可以将其删除掉
sql>conn /as sysdba
sql>start /u01/app/oracle/product/12.2.0.1/db_1/apex/apxremov.sql
-- The End --