Run the Stop Maintenance Script

After you upgrade the software, follow the steps in this procedure to stop the maintenance activity.

To run the Stop Maintenace script:

1. Download or copy the maintenance start script file from the Oracle LSH application server (EBS Middle Tier server) $CDR_TOP/patch/115/sql/cdrmaintstop.sql to the database server’s ORACLE_HOME location or any other preferred location.

2. From the database server, log in to SQL*Plus (not SQL Developer) as the APPS database user.

3. Enter this command to execute the script:

   SQL> @cdrmaintstop.sql

4. Check the log file.

   The log file validates the success of the Stop Maintenance process and provides a maintenance ID. For example, it lists the job report (ID, user name, job duration, job type), Distributed Processing (DP) server report (location, description, and machine), and service details. If you notice that any errors with stopping the maintenance script, contact Oracle Support.