Enable Maintenance Mode in Oracle EBS

Maintenance Mode is a new mode of operation in which the Oracle Applications system is made accessible only for patching activities not allowing the users to login to any responsibility. This provides optimal performance for AutoPatch sessions, reduces downtime during patching sessions and also it provides a clear separation between normal runtime operation and system downtime for patching.

You can enable maintenance mode either by using Ad utility (adadmin) or OAM (oracle applications Manager)

To enable Maintenance Mode by adadmin,  and apply your environment file and then start adadmin.

In the adadmin utility you will get a main menu where you can select to 'change to maintenance mode' then you will get a sub menu where you select 'Enable Maintenance Mode', If you want to disable select 'Disable Maintenance Mode'. When you Enable or Disable 'Maintenance Mode', adadmin will execute the below script:

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

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.

Once patch application is completed you can again disable the maintenance mode by using adadmin. Also to check that maintenance mode is enabled or not to executing the following query in your apps schema

-bash-3.2$ sqlplus apps/apps

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

The above query will return MAINT if maintenance mode is enabled else it will return NORMAL.

Note: Also remember that Maintenance Mode is only needed for AutoPatch Sessions. Other AD utilities do not require Maintenance mode.

Follow below steps for Enabling Maintenance Mode:

Connect as Apps user.

SQL> select fnd_profile.value('APPS_MAINTENANCE_MODE') from dual;
FND_PROFILE.VALUE('APPS_MAINTENANCE_MODE')
--------------------------------------------------------------------------------
NORMAL
SQL>

Sourced the environment file and run adadmin

-bash-3.2$ adadmin
                     Copyright (c) 2002, 2012 Oracle Corporation
                        Redwood Shores, California, USA
                   Oracle E-Business Suite AD Administration
                                 Version 12.2.0
NOTE: You may not use this utility for custom development
      unless you have written permission from Oracle Corporation.
Successfully created out directory
Your default directory is '/u01/R122_TEST_EBS/fs1/EBSapps/appl'.
Is this the correct APPL_TOP [Yes] ?
AD Administration records your AD Administration session in a text file
you specify.  Enter your AD Administration log file name or press [Return]
to accept the default file name shown in brackets.
Filename [adadmin.log] :
************* Start of AD Administration session *************
AD Administration version: 12.2.0
AD Administration started at: Wed Aug 12 2015 03:47:22
*** Not Edition Enabled User ***
            AD Administration Main Menu
   --------------------------------------------------
   1.    Generate Applications Files menu
   2.    Maintain Applications Files menu
   3.    Compile/Reload Applications Database Entities menu
   4.    Maintain Applications Database Entities menu
   5.    Change Maintenance Mode
   6.    Exit AD Administration
Enter your choice [6] : 5

             Change Maintenance Mode
   ----------------------------------------
Maintenance Mode is currently: [Disabled].
Maintenance mode should normally be enabled when patching
Oracle E-Business Suite and disabled when users are logged on
to the system.  See the Oracle E-Business Suite Maintenance
Utilities manual for more information about maintenance mode.

Please select an option:
   1.    Enable Maintenance Mode
   2.    Disable Maintenance Mode
   3.    Return to Main Menu

Enter your choice [3] : 1

sqlplus -s &un_apps/***** @/u01/R122_TEST_EBS/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsetmmd.sql ENABLE

Successfully enabled Maintenance Mode.

Review the messages above, then press [Return] to continue
Please select an option:
   1.    Enable Maintenance Mode
   2.    Disable Maintenance Mode
   3.    Return to Main Menu
Enter your choice [3] : 3
            AD Administration Main Menu
   --------------------------------------------------
   1.    Generate Applications Files menu
   2.    Maintain Applications Files menu
   3.    Compile/Reload Applications Database Entities menu
   4.    Maintain Applications Database Entities menu
   5.    Change Maintenance Mode
   6.    Exit AD Administration
Enter your choice [6] : 6

Backing up restart files, if any......Done.
There is no timing information available for the current session.
AD Administration is complete.
Errors and warnings are listed in the log file
/u01/R122_TEST_EBS/fs_ne/inst/r1213nls_slc04pjp/logs/appl/conc/log/adadmin.log
and in other log files in the same directory.
-bash-3.2$



SQL> select fnd_profile.value('APPS_MAINTENANCE_MODE') from dual;
FND_PROFILE.VALUE('APPS_MAINTENANCE_MODE')
--------------------------------------------------------------------------------
MAINT
SQL>

Same way you can invoke adadmin to disable maintenance mode.

That's it. Hope this will help you.

Regards,
Chowdari