Problem: Show how to enable or disable maintenance mode from SQL.
Solution: Run adsetmmd.sql
Step 1: Set up the environment by running APPSORA.env:
. ./$APPL_TOP/APPSORA.env
Step 2: Change directory to $AD_TOP/patch/115/sql/:
cd $AD_TOP/patch/115/sql/
Step 3: Run the SQL script:
sqlplus apps/apps @adsetmmd.sql ENABLE | DISABLE
Step 4: Bounce the Apache Web listener. (adapcctl.sh)
See Metalink Note: 291901.1 (Subject: Maintenance Mode – A New Feature in 11.5.10)
Recent Comments