Run the Start Maintenance Script
Before you upgrade any of the software, follow the steps in this procedure to start the maintenance activity.
To run the Start Maintenace script:
-
Download or copy the maintenance start script file from the Oracle LSH application server (EBS Middle Tier server)
$CDR_TOP/patch/115/sql/cdrmaintstart.sql
to the database server’s ORACLE_HOME location or any other preferred location. -
From the database server, log in to SQL*Plus (not SQL Developer) as the APPS database user.
-
Enter this command to stop the study health monitor scheduler:
SQL> EXECUTE DBMS_SCHEDULER.DISABLE('STUDY_HEALTH_REFRESH', FORCE => TRUE);
-
Enter this command to execute the script:
SQL> @cdrmaintstart.sql
-
Check the log file.
The log file validates the success of the Start Maintenance process and provides a maintenance ID. For example, it lists messages to show what it found up and running and what it stopped (such as the message queue and job queue).
Parent topic: Upgrading to Oracle LSH Release 3.4