Nice feature which I wasn’t aware earlier is that when you run exachk for your Exadata it has eBS specific section as well. So not all content is related to Exadata or databases.
There are million posts about exachk so I won’t go into details on it but exachk is as per Oracle:
Oracle ORAchk and EXAchk provide a lightweight and non-intrusive health check framework for Oracle hardware, operating system, Oracle database, middleware, application layers and engineered systems. ORAchk and EXAchk enable automated risk identification and proactive problem notification so that you can address issues before they affect your business.
And there is MOS note which has details:
Oracle Exadata Database Machine exachk or HealthCheck (Doc ID 1070954.1)
After running exachk and opening the html output you can review eBS specific section. The areas they examine are:
Workflow
Sales and Marketing
Service and Contracts
Fixed Assets
Payables
Projects
Receivables
Human Resources Management System
Process Manufacturing
Procurement
Order Management
Discrete Manufacturing
Price Management
So lot of different modules are included and depending on your eBS they may or may not be relevant for you. For us the most interesting parts have been Workflow and Order Management.
You can also run eBS specific analyzers (for example Workflow analyzer) on your system but I think its nice feature they added it in exachk as well.
One pick from Workflow section:
FAIL | SQL Check |
And when you click details it shows the specific items impacted.
Same for Order Management:
FAIL | SQL Check |
Order line details:
Status on EBS: |
DATA FOR EBS FOR R12_OE_WF_ACTIVITY_ERROR YOUR_LINE1 4 YOUR_LINE2 1 |
Even though your eBS functional people would review their modules periodically it’s good idea to include these in exachk as well. Specially when you update exachk frequently compared to eBS healthchecks which might not be updated so frequently?
If you manage your eBS & Exadata remember to highlight these forward and not just ignore them!
Perhaps one area what they could have included is something about concurrent managers. I think that would have been directly related to your eBS performance and would give sort of standardized hints when running eBS on Exadata and concurrent manager setup.
I recently came across requirement to get OCI Oracle Autonomous Database audit logs to OCI…
Last time I showed how to provision Autonomous Database Serverless (ADB-S) on Google Cloud. This…
I bet few years back folks didn't expect that by 2024 we would be able…
This will NOT be a technical walkthrough on Oracle Database@Azure but rather my opinions and…