Exadata, Oracle eBS and exachk

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 One or more major Workflow Looping Items found

And when you click details it shows the specific items impacted.

Same for Order Management:

FAIL SQL Check Order lines in workflow error.

Order line details:

Status on EBS:
FAIL => Order lines in workflow error.

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.

Simo

Recent Posts

Helping to troubleshoot with OCI VCN Flow Logs

I'm a huge fan of using tools available to help troubleshoot any issues there are.…

4 days ago

OCI Routing checklist when using 3rd party firewall

This post will be checklist for items you'll need when you have Firewall (or Hub)…

1 year ago

OCI ExaCS Database Upgrade Rollback

Recently I was testing OCI database upgrade from 12c to 19c and ran into an…

1 year ago

Issues with OCI ExaCS PDB cloning

This is mostly just to document if you hit similar issues and how to get…

1 year ago

OCI Tips and Tricks – Managed MySQL Database in OCI (and trying out Heatwave)

Here I'm looking on how to provision MySQL DB on OCI, see how read replicas…

1 year ago

OCI Tips and Tricks: Create 19c Oracle Database (and manage it)

This time I go over on how to create 19c Oracle Database on OCI (hint:…

1 year ago