4 Upgrade Considerations

You can upgrade from OPLA 3.4.0.0.0 to OPLA 3.5, if you are using the Agile PLM database. Upgrading involves a full installation of OPLA 3.5 as well as manual steps to migrate the existing OPLA 3.4 content

Note: The OPLA 3.5 Installer does not include upgrade for any customizations done on the Staging Schema, MDS schema, or ODI ETL components installed with a previous release of OPLA. Take appropriate backups, then re-implement and verify customizations after following the upgrade steps.

4.1 Before You Upgrade

• Current Environment (Environment 1) should not be dropped. This environment is required while performing the upgrade steps.

4.2 Upgrade Steps

To complete the upgrade, perform the following steps:

1. Install Database components and ETL components using the OPLA 3.5 Installer. Refer to "Installing Oracle Product Lifecycle Analytics for Agile PLM."

   
   

   Note: This environment will now be referred to as Environment 2. Do not run ETL until the completion of Step 2.

   
   

2. In order to migrate the configurations done in Environment 1 through the OPLA Configurator into Environment 2, refer to Chapter 11, "Environment Propagation."

3. Run one Full ETL.

4. Install BI Components using the OPLA 3.5 installer. Refer to "Installing BI Components."

4.3 Deploying OPLA Webcatalog in OBIEE 11g

Note You can find the webcatalog at the following location: <OPLA_HOME>\Patches\OPLA35\OBIEE11g\webcatalog

To deploy the OBIEE 11g Webcatalog:

1. Copy PLMA_11g (11g catalog) to the location:

   <OBIEEHomeDirectory>\instances\instance1\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\catalog

   If you are using Windows 2008, follow this step: Cut PLMA_11g (11g catalog) to the location:

   <OBIEEHomeDirectory>\instances\instance1\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\catalog

   Note Make sure you check the status of the BI services by opening the Enterprise Manager using the URL http://localhost:7001/em.

2. Open the Enterprise Manager and enter the WebLogic username and password.

3. Click on Business Intelligence and select Coreapplication.

4. Click on the Lock and Edit Configuration tab. You will notice the Deployment tab displayed.

5. Close the confirmation window displaying the following message Lock and Edit Configuration - Completed Successfully.

6. Select Deployment > Repository.

7. Enter the following location for PLMA_11g in the Catalog Location field located in the BI presentation Catalog section.

   $ORACLE_INSTANCE/bifoundation/OracleBIPresentationServiceComponent/$COMPONENT_NAME/catalog/

8. Click Apply (displayed in the top right corner of the screen).

9. Select Change Center, click Activate Changes.

10. Close the confirmation window displaying the message: Activate Changes - Completed Successfully.

11. To restart the services and apply the changes, in the Overview page select Restart.

12. After completing the restart process, check the status of the presentation services using the URL http://localhost:7001/analytics.

4.4 Upgrading Repositories

For Repository upgrade, refer to the "Merging Oracle BI Repositories" section in the OBIEE Server Administration Guide.

4.5 Upgrading Webcatalog and Permissions in the Presentation Layer

For Webcatalog and Presentation Layer upgrade, refer to the "Managing Presentation Catalog Using Oracle BI Catalog Manager" section in the OBIEE Presentation Services Administration Guide.