Tuesday, October 8, 2013

EBS -- enable/disable/control maintenance mode from backend

To enable maintenance mode:
Login to apps server as application owner , and execute the following (using sqlplus);

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

To disable maintenance mode:
Login to apps server as application owner , and execute the following (using sqlplus);

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


To control the maintenance mode of the instance:

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

Note that: The above query returns NORMAL if the instance is not in maintenance mode, and it returns MAINT if the instance is in maintenance mode..

No comments :

Post a Comment