oracle 1g apex030200,APEX_030200

安装完成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 --

标签：help,030200,APEX,ora12c,redo,ORA12CPDB3

来源： https://www.cnblogs.com/hxlasky/p/12522254.html