7 Oracle Business Intelligence Post-Upgrade Tasks and Considerations

This chapter describes post-upgrade tasks and considerations for an Oracle Business Intelligence upgrade.

• Post-Upgrade Tasks and Considerations for Oracle Business Intelligence Enterprise Edition

• Post-Upgrade Tasks and Considerations for Oracle Business Intelligence Publisher

7.1 Post-Upgrade Tasks and Considerations for Oracle Business Intelligence Enterprise Edition

This section describes post-upgrade tasks and considerations for Oracle Business Intelligence Enterprise Edition (Oracle BI EE).

7.1.1 Agents are Not Scheduled

Oracle Business Intelligence Agents (iBots in 10g) with a schedule in 10g, will not have the same schedule in 11g until the schema has been imported, or the Agent is re-scheduled by selecting a schedule and saving it in 11g.

After the Scheduler schema has been upgraded, you must use Enterprise Manager to verify that the Scheduler is configured to use the upgraded schema. Without this verification, when you edit an Agent, its schedule becomes disabled.

7.1.2 Post-Upgrade Configurations

Manually copy the following files, paths, style sheets, and skins from the Oracle BI EE 10g installation to the Oracle BI EE 11g installation. You can also use Oracle Enterprise Manager to refer the 11g installation to the 10g files.

Note: These steps apply only if you have made modifications to these files in 10g (which are all optional).

• Scheduler script path

• Scheduler Default script path

• OBIPS User pref currencies config file

• OBIPS PDF font map file

• Javahost user config file (Move the specific configuration you require, not the entire file.)

• Javahost scheduler user jar file path

• Language specific custom messages

  
  

  Note: In order to follow the Oracle standard internationalization naming convention, some of the directories that contain language-dependent message files have been modified. following table lists the message file directory names that have been changed between Oracle BI EE 10g and 11g.

  
  

  10g Name	11g Name
  l_zh	l_zh-C
  l_zh-tw	l_zh-TW (not applicable for Windows installations)
  l_pt-br	l_pt-BR (not applicable to Windows installations)
  l_iw	l_he

  
  

7.1.3 Ensure all Data Source Paths and System Variables are Accurate

After running Upgrade Assistant to upgrade an Oracle BI EE RPD, be sure that Connection Pools in the 11g environment are still pointing to the correct data source. In the case of xml data sources, be aware that the path to the source xml is held against each table definition in the physical layer, rather than at the connection pool level.

7.1.4 Upgrading a Cluster

You cannot upgrade an entire Oracle BI EE cluster. If you require a clustered 11g deployment, perform a simple installation and upgrade to that single instance before scaling out.

For information about scaling out an Oracle BI EE deployment, see "Extending and Scaling Your Deployment" in the Oracle Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition.

7.1.5 Upgraded RPDs and Web Catalog

After upgrading your Oracle BI EE RPDs and catalog, consider the following:

• Your 11g system will use the upgraded RPDs and catalog.

• Existing catalogs of the same name are renamed.

• RPDs are given a unique version number as they are added to the system so that any existing RPDs are not overwritten.

7.1.6 Authentication for External Users

Users migrated from the RPD into WebLogic LDAP derive their application role memberships directly from the Policy Store, which can be managed within Oracle Enterprise Manager. However, users that exist in an external user population, and are authenticated using an Authentication Init Block, derive their application role memberships from the ROLES (or GROUP) session variable that is set in response to a database query within an Authorization Init Block. To ensure consistent behavior for any given user, ensure that each user exists in only one place. Therefore, any users migrated from the RPD into WebLogic LDAP should be removed from your external user population.

7.2 Post-Upgrade Tasks and Considerations for Oracle Business Intelligence Publisher

This section describes post-upgrade tasks and considerations for Oracle Business Intelligence Publisher (Oracle BI Publisher).

7.2.1 Restart the Managed Server

Before restarting the Managed Server - If the 10g security model is Oracle BI Server, after the upgrade to 11g, the security model is set to Oracle BI Server. Therefore, you must manually change the Oracle BI Server name (or IP Address) in xmlp-server-config.xml file located in the repository/Admin/Configuration folder.

Restart the Managed Server that runs the Oracle BI Publisher instance. Once the server is running, you can log in with a 10g user ID and password.

The repository is a file system, therefore the integrated environment does not work. In this case, log in to the following URL:

http://servername:port/xmlpserver

If you cannot log in with a 10g user ID and password, you can log in with the superuser ID and password.

7.2.2 Upgrading the File-Based Repository to the BI Web Catalog

After the upgrade process, a file-based repository upgraded to the BI Web Catalog (for BI Server Security Model) is required, use the utility from Oracle BI Publisher Administration Page under Server Configuration in Catalog section.