Run the Upgrade Script to Edition Existing Schemas

Run the dmeupg31runprgs.sql script to ensure that all the applicable Oracle DMW and Oracle LSH schemas get editioned which were created in an earlier version of Oracle DMW and Oracle LSH. You must plan a maintenance window to run the script.

Note:

Run this script only if you want to upgrade from Oracle DMW or Oracle LSH release 3.0 to release 3.1. For any other upgrade path, do not run this script.

This script generates a log file. For example, dmeupg31runprgs<YYYYMMDDHHMISS>.LST. The script displays the output on the console and also writes in the log file.

Enable the Oracle DMW Maintenance Mode and perform the following steps to run the script on a computer with an Oracle client that can connect to the Oracle DMW database server using SQLPlus:

  1. Before you run the dmeupg31runprgs.sql script, you must remove the obsolete editions by executing the following commands:

    adop phase=prepare
    adop phase=actualize_all
    adop phase=finalize finalize_mode=full
    adop phase=cutover
    adop phase=cleanup cleanup_mode=full
  2. Download the dmeupg31runprgs.sql script file from $CDR_TOP/patch/115/sql/.
  3. Log on to SQLPlus (not SQLDeveloper) as the APPS database user.
  4. Invoke the script from your download directory. For example, <download_directory>/ dmeupg31runprgs.sql.

This script submits the job DMEUPG31$EDITIONSCHS. To track the status of this job, execute the following query:

SELECT * FROM DBA_SCHEDULER_JOBS WHERE JOB_NAME = 'DMEUPG31$EDITIONSCHS';

You can also monitor the job while it is executing:

SELECT * FROM DBA_SCHEDULER_RUNNING_JOBS WHERE JOB_NAME = 'DMEUPG31$EDITIONSCHS';

After the job execution completes, check the status of the job:

SELECT * FROM DBA_SCHEDULER_JOB_RUN_DETAILS WHERE JOB_NAME = 'DMEUPG31$EDITIONSCHS';

The scripts displays the number of schemas to get editioned. If this number is high, job execution may take more time to complete.

You can monitor the processed and remaining schemas using the below query anytime in addition to the above queries:

Select Decode(Success_Flag, 'Y', 'processed_schema_Count', 'F', 'failed_schema_Count', 'remaining_schema_count') as status,
Count(*) as num_schemas
From DME_UPG31_SCH_TAB
Group By Success_Flag;

Note:

If you resubmit the script while the above job is already running, the script will abort.