EBS R12.2 checking maintenance mode status from sqlplus

SQL> connect apps/apps
Connected.
SQL> /
FND_PROFILE.VALUE(‘APPS_MAINTENANCE_MODE’)
——————————————————————————–
NORMAL
SQL> l
1* select fnd_profile.value(‘APPS_MAINTENANCE_MODE’) from dual
SQL>
or
SQL> l
1* select fnd_profile.value(‘APPS_MAINTENANCE_MODE’) from dual
SQL> /
FND_PROFILE.VALUE(‘APPS_MAINTENANCE_MODE’)
——————————————————————————–
MAINT
To ENABLE maintenance mode from SQLPLUS Session:
sqlplus apps/apps @$AD_TOP/patch/115/sql/adsetmmd.sql ENABLE
To DISABLE maintenance mode from SQLPLUS Session:
sqlplus apps/apps @$AD_TOP/patch/115/sql/adsetmmd.sql DISABLE