Davis Apps DBA

In this post we'll see about EXAchk utility, command-line options and how to run it on an EXADATA Server.      1.  What is EXAchk?        ·          Automates risk identification and proactive notification before your                        business is  impacted.  ·          Runs health checks based on critical and reoccurring problems ·          Presents high-level reports about your system health risks and vulnerabilities to   known issues ·          Enables you to drill-down specific problems and understand their resolutions ·          Enables you to schedule recurring health checks at regular intervals ·        ...

In my environment we are using R12.2.5. Recently after a fresh clone of the application tier, before releasing the instance, performed the post clone activity and sanity works. As a part of this tasks, ran the concurrent program ' Purge Debug Log and System Alerts ' to remove the log files. After submission, the program has completed with error. From the log file observed the below error: "Cause: FDPSTP failed due to ORA-06550: line 1, column 20: PLS-00302: component 'PURGE_BUSINESS_EXCEPTIONS' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored" "Purge Debug Log and System Alerts" is the name of the old purge program that was used in Oracle Application Release 11i, "Purge Logs and Closed System Alerts" is name of new one introduced in Release 12. Both of them do basically same thing, that is purge logs and alerts. "Purge Diagnostic and Log Messages" is no longer used in R12.  If someo...