Thursday 22 October 2015

How to enable maintenance mode in oracle apps if adadmin is not working

In my case i faced an issue with the compiling flexfield, In this case adadmin is not working for enable maintenance mode.

Please follow the below steps to enable/disable maintenance mode.

How to know the status of maintenance mode:

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

How to enable maintenance mode:

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

How to disable maintenance mode:

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

When we enable or disable "Maintenance Mode" adadmin will execute the above scripts.

Note: Maintenance Mode is only needed for AutoPatch Sessions. Other AD utilities do not require.

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. But oracle never recommend for hotpatch.

No comments:

Post a Comment