This article is to provide you all on-job used scripts and commands for Application DBA (AD) module based on my 20 years of experience. I will be keep appending this document for new learning:


EBS-AD: Patching Tool (adop)

adop phase=prepare

adop phase=apply

adop phase=finalize

adop phase=cutover

adop phase=cleanup

adop phase=cleanup cleanup_mode=quick

adop phase=fs_clone

adop phase=fs_clone force=yes

adop -status

adop -status -detail

adopscanlog -latest=yes


Apply patch in TEST mode: 

adop phase=apply patches=<patch_number> apply=no apply_mode=hotpatch

Apply patch in Hotpatch mode: 

adop phase=apply patches=<patch_number> hotpatch=yes

adop phase=apply patches=<patch_number> apply_mode=downtime


Apply Specific Driver:

adop phase=apply patches=18228399_ESA:u18228399.drv


Apply merged patches:

adop  phase=apply patches=18288881,19445058 hotpatch=yes merge=yes patchtop=/stage/EBS_patches


Restart Failed Patch:

adop phase=apply patches=18228399_ESA:u18228399.drv restart=yes flags=autoskip






About Me

I have 20 years of thorough experience in the Information Technology industry, specializing in Oracle Database, Fusion Middleware, OBIEE, Oracle E-Business Applications, Hyperion, UPK, Oracle Cloud & Virtualization Administration using Oracle Development / Administration / Management / Training tools on different platforms across industry, including C&IP (Manufacturing, Supply Chain Planning), HCM, Financials, and TMT, with knowledge in Project Management, Application Strategy, Software Development Lifecycle (SDLC), and Application Testing (Unit, System, Integration, UAT, and Performance). I worked on number of projects, implementing custom and ERP/CRM Oracle applications and used AIM/ Macro-scope methodology Project Documentation and version control. I used IT Service Management (ITSM) guidelines and ITIL framework on projects to manage Oracle Infrastructure.


Feedback, Comments, Questions?

Please provide your valuable feedback/comments and let me know if any questions? Feel free to contact me for any ORACLE technology assistance.

Contact: +91-9930920689 | Amit.Garg@redcircle.in | Linkedin