How to Enable/Disable Maintenance Mode without using ADADMIN

Syed Saad December 1, 2017 APPS DBA, Installations/Configurations-Applications Leave a comment 639 Views

Enable/Disable Maintenance Mode without using ADADMIN

We can Enable or Disable Maintenance mode without using ADADMIN through following given procedure:

Enable Maintenance Mode:

$sqlplus apps/appspassword
SQL>$AD_TOP/patch/115/sql/adsetmmd.sql ENABLE

Disable Maintenance Mode:

$sqlplus apps/appspassword 
 
SQL>$AD_TOP/patch/115/sql/adsetmmd.sql DISABLE

 

 

About Syed Saad

With 13 years of experience as a certified and skilled Oracle Database Administrator, I possess the expertise to handle various levels of database maintenance tasks and proficiently perform Oracle updates. Throughout my career, I have honed my analytical abilities, enabling me to swiftly diagnose and resolve issues as they arise. I excel in planning and executing special projects within time-sensitive environments, showcasing exceptional organizational and time management skills. My extensive knowledge encompasses directing, coordinating, and exercising authoritative control over all aspects of planning, organization, and successful project completions. Additionally, I have a strong aptitude for resolving customer relations matters by prioritizing understanding and effective communication. I am adept at interacting with customers, vendors, and management, ensuring seamless communication and fostering positive relationships.

Check Also

ebs-12214_upgrade

Step By Step Upgrading Oracle EBS to R12.2.14

Step By Step Upgrading Oracle EBS to R12.2.14 This post will offer comprehensive guidance on …

Leave a Reply

Powered by OracleSolutions | Designed by
© Copyright 2025, https://oraclesolutions.pk All Rights Reserved