Enable/Disable Maintenanace Mode from SQLPLUS Session (Without adadmin)

We can enable or disable maintenance mode without using adutility (adadmin), Perform the same from SQLPLUS session.

Check the current status of Maintenance Mode:

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

MAINT     =  MAINTENANCE MODE is ENABLED
NORMAL =  MAINTENANCE MODE is DISABLED

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

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

Post a comment or leave a trackback: Trackback URL.

Comments

  • Sunil  On November 10, 2013 at 4:28 am

    Helpful !!

  • absder  On April 28, 2016 at 12:12 pm

    ERROR at line 1:
    ORA-00972: identifier is too long

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: