How to Find whether Application is Under Maintenance Mode from SQLPLUS   Leave a comment

Query to know the status of maintenance mode:

select fnd_profile.value(‘APPS_MAINTENANCE_MODE’) from dual;

IF THE STATUS
“MAINT” = MAINTENANCE MODE HAS BEEN ENABLED AND THE USERS WILL NOT BE ABLE TO LOGIN.
“NORMAL” = MAINTENANCE MODE HAS BEEN DE-ACTIVATED AND THE USERS WILL BE ABLE TO LOGIN.

ENABLE maintenance mode from SQLPLUS Session:

sqlplus -s apps/apps @$AD_TOP/patch/115/sql/adsetmmd.sql ENABLE

DISABLE  maintenance mode from SQLPLUS Session:

sqlplus -s apps/apps @$AD_TOP/patch/115/sql/adsetmmd.sql DISABLE

Advertisements

Posted October 1, 2013 by balaoracledba.com in 11i/R12

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: