How to enable and check Maintenance mode status - (11i & R12)

How to enable and check Maintenance mode status - (11i & R12)

Use the Query below:

To Enable maintenance mode from SQLPLUS on MT node

sqlplus apps/*****

SQL> @$AD_TOP/patch/115/sql/adsetmmd ENABLE

PL/SQL procedure successfully completed.

Commit complete.

To Disable maintenance mode from SQLPLUS on MT node

sqlplus apps/*****

SQL> @$AD_TOP/patch/115/sql/adsetmmd DISABLE

PL/SQL procedure successfully completed.

Commit complete.

To check status:

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

FND_PROFILE.VALUE('APPS_MAINTENANCE_MODE')

--------------------------------------------------------------------------------

MAINT/NORMAL