Oracle Apps DBA Real Time Experience Q &A's
Section 1 — EBS Architecture Understanding the 3-tier structure, AutoConfig, APPL_TOP layout, DBC files, startup sequence, and patching concepts. Foundation knowledge every DBA must know.
Section 2 — Installation & Cloning Rapid Clone steps, common clone failures, database refresh process, post-clone mandatory steps, and R12.2 dual filesystem.
Section 3 — Concurrent Manager Diagnosing stuck/failed requests, restarting CM safely, OPP issues, scheduling problems, worker tuning, and FNDSM.
Section 4 — AutoConfig & Profiles Context file management, profile hierarchy (Site→User), SSL config, port changes, and template customization. Section
5 — Performance Tuning AWR/ASH analysis, FND_STATS vs DBMS_STATS, blocking locks, memory sizing, slow batch programs, and GL/Payroll tuning.
Section 6 — Security & Users Creating users, SOD, function security, data security, password policy, GUEST user, and access auditing.
Section 7 — Database Administration ORA-01555, tab
Section 8 — Patching
adpatch vs adop, patch failures, NLS/merged patches, rollback strategy, and 24x7 patching approach.
Section 9 — WebLogic & OHS
Heap tuning, OHS startup failures, OPMN, WLS connection pool, SSL, Forms server, and mod_wl_ohs.
Section 10 — Backup & Recovery
Crashed datafile recovery, APPL_TOP backup, Data Guard, DR strategy, accidental delete recovery using Flashback.
Section 11 — Troubleshooting
Login failures, ORA-04031, scheduled vs manual program differences, session timeouts, workflow mailer, 404 errors.
Section 12 — Monitoring & Alerting
Daily health checks, automated alerting scripts, log file locations, OAM monitoring, SLA metrics tracking.
Section 13 — Integration & Interfaces
Open interfaces, failed interface troubleshooting, SOA monitoring, XML Gateway, FBDI, and REST APIs.
Section 14 — Advanced Scenarios
ORA-00257 archiver error, adop cutover delays, RAC split-brain, runaway SQL, year-end close prep, dropped table recovery.
Section 15 — Automation & Scripts
Shell/Python monitoring scripts, patch automation, change management best practices, incident response, connection management.