How to Enable/DISABLE Maintenance Mode in Oracle EBS R12.1.3
Login with Application OS user.
Conn with apps.
$ sqlplus apps/****
$AD_TOP/patch/115/sql/adsetmmd.sql ENABLE
$AD_TOP/patch/115/sql/adsetmmd.sql DISABLE
sending the parameter 'ENABLE' or 'DISABLE'
How to verify Enable/DISABLE Maintenance Mode
$ sqlplus apps/****
SQL> select fnd_profile.value('APPS_MAINTENANCE_MODE') from dual;
FND_PROFILE.VALUE('APPS_MAINTENANCE_MODE')
----------------------------------------------------------------------------
NORMAL
The above query will return MAINT (maintenance mode is ENABLE)
The above query will return NORMAL (maintenance mode is DISABLE)
