To enable maintenance mode:
Login to apps server as application owner , and execute the following (using sqlplus);
sqlplus apps/apps
SQL> select fnd_profile.value('APPS_MAINTENANCE_MODE') from dual;
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 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
If you will ask a question, please don't comment here..
For your questions, please create an issue into my forum.
Forum Link: http://ermanarslan.blogspot.com.tr/p/forum.html
Register and create an issue in the related category.
I will support you from there.