Thursday, March 24, 2011

Queries on maintenance mode


Query to know status of maintenance mode:
select fnd_profile.value('APPS_MAINTENANCE_MODE') from dual;

Query to ENABLE of maintenance mode:
sqlplus -s &un_apps/******** @/tcme3i/applmgr/1159/ad/11.5.0/patch/115/sql/adsetmmd.sql ENABLE

Query to DISABLE of maintenance mode:
sqlplus -s &un_apps/******** @/tcme3i/applmgr/1159/ad/11.5.0/patch/115/sql/adsetmmd.sql DISABLE  

Regards,
Sukhwinder Singh

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.

There was an error in this gadget