Determining Application Database in Maintenance Mode or Not

Hi,

To find out the Applications Database is in Maintenance Mode or not, run the following sql statement as an Apps User.

SQL> SELECT FND_PROFILE.VALUE(‘APPS_MAINTENANCE_MODE’) FROM DUAL;

If it is in Maintenance Mode the above query will show as follows:

FND_PROFILE.VALUE(‘APPS_MAINTENANCE_MODE’)
———————————————————
MAINT

If it is not in Maintenance Mode the above query will show as follows:

FND_PROFILE.VALUE(‘APPS_MAINTENANCE_MODE’)
———————————————————
NORMAL

To enable or disable the Maintenance Mode in command level run the following statements in the sql prompt.

Before running these statements need to source your apps environment.

Enable Maintenance Mode :
========================

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

ENABLED

Disable Maintenance Mode :
=========================

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

DISABLED

Best regards,
Vijay.