In Oracle : Configure the Maintenance Wizard for Upgrade ( from Apps 11i to Apps R12 )

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

Oracle Applications EBS

Oracle Apps 11i DBA (I) Oracle Apps 11i DBA (II) Oracle Apps 11i DBA (III) Oracle Apps 11i Sys Admin UPGRADE 11i Apps to R12 Oracle Apps R12 DBA

The last articles in the site (HOT)

The most visited articles in the site

In-Oracle.com  -> Oracle Applications (apps)  -> R12

-> Configure the Maintenance Wizard for Upgrade ( from Apps 11i to Apps R12 )

 

 Configure the Maintenance Wizard for Upgrade

( from Apps 11i to Apps R12 )

 

 

1. Login as Upgrade Engineer User

2. Select a Category

3. Complete configuration of Maintenance Wizard

4. Enable remote access of the Applications database

5. Filter steps

6. Generate patch list and dynamically create pre-upgrade patching steps

7. Configure the Maintenance Wizard: status

 

 

1. Login as Upgrade Engineer User

 

   a) Login as Upgrade Engineer User

 

   b) Choose the Project you want to view:

 

 

 

2. Select a Category

 

Select the "Configuration" Category. 

 

The following screen will appear:

 

 

 

3. Complete configuration of Maintenance Wizard

 

Click on the "Execute" button for the first task. The following screen will appear:

 

 

Click on "Run" button. 

 

When the job complete you must see the following message at the end of the log information:

 

*******************************************************************************
*******************************************************************************
**                                                                                                                 **
**                                   Congratulations!!!                                                 **
**                                                                                                                 **
**      You have successfully completed project node configuration.         **
**                                                                                                                 **
*******************************************************************************
*******************************************************************************

If you have any errors please fix them and redo this run ( from Redo the Action button) and run this job again.

 

NOTES: 

    1) For this step please define utl_file_dir database initialization parameter;

    2) Check if $APPL_TOP/patch (on the apps node)  and  $ORACLE_HOME/patch (on the database node) are created. 

 

 

4. Enable remote access of the Applications database

 

  a) Check if the database of the Oracle Applications 11i and the database listener are running. If there are not started, start them. 

 

  b) Click on the "Execute" button for the 2nd task. Click "Run". 

 

  c) At the end of the job the following message must be at the end of the log information:

 

Successfully created a database link named REMOTE_1597
Testing it now...
Test of database link succeeded.

PL/SQL procedure successfully completed.

Successfully completed enabling remote access of the Applications database.

   d) Click on "Complete" button, and after that on "Success" button. 

 

 

5. Filter steps

 

This step runs filtering routines against the content of the upgrade instructions. The results of this step are used in determining what steps to display in the tool, and what steps to suppress or mark as automatically completed.

 

If the following message will appear in the log information "Found that at least one of Student Systems, Student Recruiting and/or  Financial Aid products is installed! Setting this project back to  DATA COLLECTION COMPLETE to prevent continuation of this upgrade.", only in a test environment you can force to fix the error by updating the fnd_product_installations table:  

 

update fnd_product_installations set status = 'N' where application_id in (8406, 8405);

commit;

 

If this step complete successfully, you will see the following message at the end of the log information:

 

Checking to see if Student Systems or Student Recruiting are installed...
Neither Student System nor Student Recruiting are installed.
It is safe to proceed with the Release 12 upgrade.
Successfully performed all filtering routines.

 

 

6. Generate patch list and dynamically create pre-upgrade patching steps

 

This step loads only relevant patches into EOF_REQUIRED_PATCHES, based on the upgrade from version and the product filter built in a previous step. It then queries the Applications database to determine the list of patches which have already been applied and flags the appropriate records in EOF_REQUIRED_PATCHES, by updating the APPLIED_FLAG. Finally, it dynamically generates steps in the 11i Pre-Upgrade Category for downloading, merging and applying those patches.

 

This step will contains in the log information the following message:

 

Creating 1 merge step(s).
Creating the Compilation step.
Creating the Verification step.
PL/SQL procedure successfully completed.
Completed execution of eof17208e.sh.

 

 

7. Configure the Maintenance Wizard: status

 

If the Maintenance Wizard complete the configuration successfully, you can see the following screen:

 

 

 

In-Oracle.com  -> Oracle Applications (apps)  -> R12

-> Configure the Maintenance Wizard for Upgrade ( from Apps 11i to Apps R12 )

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

 

     Copyright (c) 2011-2015  www.in-oracle.com  |  Disclaimer: The views expressed on this web site are my own and do not reflect the views of Oracle Corporation. You may use the information from this site only at your risk.