Forgot your password?    
+ Reply to Thread
Results 1 to 1 of 1

Thread: Maintenance Mode

  1. #1
    Expert Oracle Administrator
    Join Date
    Oct 2011
    New Delhi, India

    Maintenance Mode

    Maintenance Mode is a new mode of operation introduced with Release 11.5.10, in which the Oracle Applications system is made accessible only for patching activities not allowing the users to login to any responsibility.

    Maintenance mode was introduced in AD.I patchset.

    Maintenance mode provides a clear separation between normal runtime
    operation of Oracle Applications and system downtime for maintenance.
    Enabling the maintenance mode feature shuts down the Workflow Business
    Events System and sets up function security so that no Oracle
    Applications functions are available to users.

    Used only during AutoPatch sessions, maintenance mode ensures optimal performance and reduces downtime when applying a patch, disabling tiggers & Workflow business Events.

    1. Scheduling System Downtime

    Administrators can schedule 'System Downtime' using Oracle Applications Manager (OAM):

    Site Map --> Maintenance --> Manage Downtime Schedules

    When the System has been scheduled for 'Downtime', Apache should be re-started on Restricted Mode

    by using the Script ( By doing this, users attempting to log on to Oracle Applications will be automatically redirected to a System Downtime URL.

    This message can be customized with any text message. If No Downtime has been specified, and the users try to access the Applications, the following message might also appear:

    ! Warning
    The system has not been taken off maintenance mode completely.
    Please contact your System Administrator.

    2. Advantages

    There are several practical points relating to the use of Maintenance Mode:

    You can toggle Maintenance Mode between Enabled and Disabled using the new Change Maintenance Mode menu in AD Administration, or the equivalent function in Oracle Applications Manager.

    For more Information on Restricted Mode Access

    3. Enabling and Disabling Maintenance Mode

    Maintenance mode is Enabled or Disabled from adadmin.

    When you Enable or Disable 'Maintenance Mode', adadmin will execute the script:

    $AD_TOP/patch/115/sql/adsetmmd.sql sending the parameter 'ENABLE' or 'DISABLE' :

    sqlplus <APPS_Schema name>/<APPS Password>@adsetmmd.sql ENABLE | DISABLE

    ENABLE - Enable Maintenance Mode .
    DISABLE - Disable Maintenance Mode.

    When adsetmmd.sql runs, it sets the Profile Option 'Applications Maintenance Mode'

    (APPS_MAINTENANCE_MODE) to 'MAINT' to Enable 'Maintenance Mode' and to 'NORMAL' to Disable it.

    4. Determining if Maintenance Mode is Running

    A quick way to verify if the Environment is on Maintenance Mode or not, is by checking the value of this

    Profile Option as follows:

    sqlplus apps/apps

    SQL> select fnd_profile.value('APPS_MAINTENANCE_MODE') from dual;

    If the query returns 'MAINT', then Maintenance Mode has been Enabled and the Users will not be able to

    Login. If the query returns 'NORMAL' then Maintenance Mode has been De-Activated and the Users will be

    able to use the application.

    Note: Maintenance Mode is only needed for AutoPatch Sessions. Other AD utilities do not require Maintenance Mode to be enabled. Maintenance Mode must be 'Enabled' before running AutoPatch and 'Disabled' after the patch application was completed.

    When Maintenance Mode is disabled, you can still run Autopatch by using options=hotpatch on the

    command line, if necessary. However, doing so can cause a significant degradation of performance.

    5. Error Messages

    Always remember to Disable Maintenance Mode after any Patch application. If Maintenance Mode is not

    Disabled, the Application will not allow the users to use the system. Take note that Apache must be re-started in normal mode after disabling 'Maintenance Mode' by using the Script (or

    As explained before, when 'Maintenance Mode' is enabled, a Downtime should be Scheduled from OAM and

    Apache should be started on Restricted Mode by using the Script (

    If a 'DownTime' is not Scheduled from OAM and Apache has not been re-started on Restricted Mode,the Application will allow the users to Login, but it might experience unusual behaviors afterwards depending on the Patch Level.

    Here are some examples of the possible error messages:

    When clicking on a Responsibility from the PHP
    There are no applications available for this responsibility. Please click on a different responsibility link to display the list of available applications.


    You are not authorized to access the function Applications Home Page. Please contact your System Administrator.

    6. Step by Step Process

    1. Schedule the 'System Downtime' from OAM

    OAM: Site Map --> Maintenance --> Manage Downtime Schedules

    At the moment of the downtime, do the following:

    2. Shutdown Apache (on Normal Mode): stop
    or <apps_user>/<apps_pwd>

    3. Enable 'Maintenance Mode' from adadmin

    adadmin: Options 5, 1

    4. Start Apache (on Restricted Mode) start

    5. Apply the Patch with adpatch

    6. Stop Apache (on Restricted Mode) stop

    7. Disable 'Maintenance Mode' from adadmin

    adadmin: Options 5, 2

    8. Start Apache (on Normal Mode): start
    or <apps_user>/<apps_pwd>

+ Reply to Thread

Similar Threads

  1. The cloning of the database in noarchivelog mode
    By shoaibansari in forum Database Installation,Upgrades,Migration,Patching and Cloning
    Replies: 1
    Last Post: 07-20-2012, 01:03 PM
  2. Archivelog Mode On RAC
    By devesh_ocp in forum RAC Installation, ASM Install , ASM Administration
    Replies: 0
    Last Post: 04-25-2012, 03:28 PM
  3. Forms Servlet or Socket Mode? Which is Better ?
    By pkumar in forum Concepts,Service Management,Apache,OC4J,OPMN,JServ,Forms, Issues,Troubleshooting,
    Replies: 0
    Last Post: 02-21-2012, 07:42 AM
  4. Changing the Archivelog Mode on 9i and earlier
    By Sandeep Sharma in forum Core Database Administration and Monitoring
    Replies: 3
    Last Post: 12-22-2011, 09:29 PM
  5. Apply HOT patch (without enabling maintenance mode / while services are running)
    By Amit in forum Oracle Apps Patching and Cloning, Installation , Migration,Upgrades
    Replies: 0
    Last Post: 11-04-2011, 09:55 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

DBA Lounge (P) Ltd. deals in Oracle Technologies on Consulting, Resourcing, Corporate Training

Online and corporate training available on Oracle Database 11g, Oracle 11g Real Application Cluster (RAC), Oracle Applications 11i/R12, Oracle Fusion Middleware 11g, Oracle Identity Management-OIM, Oracle Internet Directory 11g-OID, Oracle Business Intelligence Enterprise Edition-OBIEE, Oracle Golden Gate, Oracle Access Management-OAM, Oracle Internet Directory-ODS, Oracle Identity Analytics Architecture-OIA Statistics