• 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 --

  • 相关阅读:
    数字加密
    大道至简第四章读后感
    输出类中的对象个数
    大道至简第三章读后感
    02java语法基础问题总结
    从命令行接收多个数字并求和输出
    软件工程个人作业03
    第四周学习进度条
    软件工程概论-课后作业2(单元测试)
    第三周学习进度
  • 原文地址:https://www.cnblogs.com/hxlasky/p/12522254.html
Copyright © 2020-2023  润新知