Tag Archives: adsetmmd

Enabling Maintenance Mode in SQL

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)