Modern Oracle DBA

When dealing with performance or functional issues in Oracle E-Business Suite (EBS), asking the right questions can help identify the root cause faster. Below are some commonly used questions categorized by the type of issue.   General Questions 1.      Since when is the issue happening? 2.      Are you facing similar issues in any other instances? 3.      Was it working fine earlier?   If the Application is Slow 1.      Which part of the application is slow? (e.g., HTTP pages, Forms, or everything?) 2.      If it's Forms, are they seeded, custom, or third-party integrations? 3.      If it's related to customizations, can you disable them and retest? 4.      Can you provide screenshots or navigation steps to help replicate the issue? 5.      Is the slowness constant or does it occur at specific t...

1. ADOP Validate – Quick Health Check Purpose : To check if the current patching cycle is healthy. Command:  adop -validate What it does: Runs a quick system check Alerts you if there are any configuration or edition issues Often the first step Oracle Support asks you to run Location:  $AD_TOP/bin Use case:  Before starting or during a patching cycle, run this to ensure everything is OK.   2. ADOPSCANLOG – Scan ADOP Log Files Easily Purpose:  To check patching logs quickly from current or past sessions. Why it is important: Saves time by scanning all logs in one go Helps you find errors, warnings, or specific messages You can search older ADOP sessions too Command examples: adopscanlog                --> Scans latest session logs adopscanlog session_id=0   --> Scans ALL past sessions adopscanlog loglevel=error...