Pages

Wednesday, April 6, 2016

Adadmin Is Not Working How To Enable Maintenance Mode In Oracle Applicationss (EBS)

Adadmin Is Not Working How To Enable Maintenance Mode In Oracle Applicationss (EBS)

@$AD_TOP/patch/115/sql/adsetmmd.sql

You can also put your application in Maintenance mode from backend:

Enable Maintenance mode:
SQL> @$AD_TOP/patch/115/sql/adsetmmd.sql ENABLE

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

Disable Maintenance mode :
SQL> @$AD_TOP/patch/115/sql/adsetmmd.sql DISABLE

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

Maintenance mode is Enabled or Disabled from adadmin, When you Enable or Disable 'Maintenance Mode', adadmin will execute the below script

$AD_TOP/patch/115/sql/adsetmmd.sql sending the parameter 'ENABLE' or 'DISABLE' :

sqlplus /@adsetmmd.sql ENABLE | DISABLE

ENABLE - Enable Maintenance Mode .
DISABLE - Disable Maintenance Mode.

When adsetmmd.sql runs, it sets the Profile Option 'Applications Maintenance Mode'

(APPS_MAINTENANCE_MODE) to 'MAINT' to Enable 'Maintenance Mode' and to 'NORMAL' to Disable it.

Determining if Maintenance Mode is running
A quick way to verify if the Environment is on Maintenance Mode or not, is by checking the value of this Profile Option as follows:
sqlplus apps/apps
SQL> select fnd_profile.value('APPS_MAINTENANCE_MODE') from dual;

-If the query returns 'MAINT', then Maintenance Mode has been Enabled and the Users will not be able to
-If the query returns 'NORMAL' then Maintenance Mode has been De-Activated and the Users will be able to use the application.

Note: Maintenance Mode is only needed for AutoPatch Sessions. Other AD utilities do not require Maintenance Mode to be enabled. Maintenance Mode must be 'Enabled' before running AutoPatch and 'Disabled' after the patch application is completed.

When Maintenance Mode is disabled, you can still run Autopatch by using options=hotpatch on the command line, if necessary. However, doing so can cause a significant degradation of performance.

No comments:

Post a Comment