Skip Headers
Oracle® Fusion Middleware Upgrade Guide for Oracle Business Intelligence
11g Release 1 (11.1.1.6.2)

Part Number E16452-06
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

6 Upgrading Oracle BI Publisher

This chapter describes how to upgrade an existing Oracle BI Publisher 10g Release 3 (10.1.3.4 or later) environment to Oracle BI Publisher 11g.

This chapter contains the following sections:

6.1 Task 1: Understand the Starting Points for BI Publisher Upgrade

For information about starting points for a BI Publisher upgrade, see Chapter 3, "Supported Starting Points for Oracle Business Intelligence Upgrade." If you are running a version of BI Publisher older than the version specified in Chapter 3, then you must upgrade to the supported starting point version before attempting to upgrade to 11g.

If you are already running Oracle Fusion Middleware 11g, see Oracle Fusion Middleware Patching Guide, which provides information about applying the latest Oracle Fusion Middleware patches.

This guide provides instructions for upgrading from BI Publisher 10g to the latest BI Publisher 11g.

6.2 Task 2: Decide Upon an Oracle Business Intelligence Topology

To help you decide on a target topology for the Oracle Business Intelligence 11g deployment, see Chapter 4, "Oracle Business Intelligence for 10g Users," which compares 10g and 11g features, directory structures, and architecture. It also describes BI Publisher 11g integration with Oracle WebLogic Server and Oracle Fusion Middleware applications.

For more information, see "Understanding Oracle Fusion Middleware Concepts" in Oracle Fusion Middleware Administrator's Guide.

6.3 Task 3: Run RCU to Create the Destination BIPLATFORM Schemas

Before you can install Oracle Business Intelligence 11g, you must first identify and prepare a database for the Oracle Business Intelligence 11g schemas. You can then run the Repository Creation Utility (RCU) to install the required schemas in the database.

For complete information about using RCU to install the required Oracle Fusion Middleware schemas, refer to the following:

Important screens when running RCU:

Note:

If you have already run RCU to create the destination BIPLATFORM schema for Oracle BI EE, then you are not required to perform Task 3. Oracle BI EE and BI Publisher share the BIPLATFORM schema.

6.4 Task 4: Install and Configure BI Publisher 11g

Use the Oracle Business Intelligence 11g installer to install BI Publisher 11g on a separate host computer. Do not install Oracle Business Intelligence 11g on a computer that is running Oracle Business Intelligence 10g, because this installation scenario is not supported.

Note:

If you have already installed Oracle BI EE and BI Publisher, using the Enterprise Install for new installations, as described in Section 5.4.2, "Installing Oracle Business Intelligence 11g in Preparation for Upgrade", then you can skip Task 4.

See the following topics for more information:

6.4.1 Availability of the BI Publisher 10g Directories

When you install BI Publisher 11g, ensure that the following 10g source directories are accessible to the Oracle Business Intelligence 11g Upgrade Assistant, which you run from the Business Intelligence 11g Oracle home.

Upgrade Assistant must be able to browse to and access these directories:

  • The BI Publisher Repository 10g directory

  • The E-Business Data Template 10g directory

If the 10g installation directories are not available to Upgrade Assistant, then you can make them available in other ways. For example, you can copy them to a shared network disk or to a USB drive.

For more information, see Table 6-1 for information about specifying the source details for these components on the Specify Source Details screen of Upgrade Assistant.

6.4.2 Installing Oracle Business Intelligence Publisher 11g in Preparation for Upgrade

Follow the instructions in Section 5.4, "Task 4: Install and Configure Oracle BI EE 11g" to install and configure a new Oracle Business Intelligence 11g environment.

6.5 Task 5: Upgrade the BI Publisher Repository

Use the Oracle Fusion Middleware Upgrade Assistant to upgrade the BI Publisher Repository.

Note:

You can upgrade the BI Publisher Repository and Scheduler schema in any order.

For information on what is upgraded by Upgrade Assistant, see Section 1.5, "Understanding BI Publisher Upgrade."

For a descriptions of the security model upgrade path, see Section 1.5.1.2, "Security Model Changes."

To upgrade the BI Publisher repository, see the following sections:

6.5.1 Before You Begin the BI Publisher Repository Upgrade

Before you start the Upgrade Assistant to upgrade the BI Publisher repository, follow these steps:

  1. Back up the 10g and 11g repositories.

  2. Stop the Managed Server on which BI Publisher is running if the environment is using the BI Publisher catalog (file-based).

The Administration Server should remain running.

6.5.2 Using the Upgrade Assistant to Upgrade the Repository

Upgrade Assistant is installed automatically into the bin directory of the Oracle Fusion Middleware Oracle home.

Note:

The following sections describe how to use the Upgrade Assistant in graphical user interface mode. You can also use the Upgrade Assistant command line to perform these tasks.

For more information, see "Using the Upgrade Assistant Command-Line Interface" in Oracle Fusion Middleware Upgrade Planning Guide.

Table 6-1 Running Upgrade Assistant to Upgrade the BI Publisher Repository

Step Screen Description and Action Required

1

None.

To start Upgrade Assistant using the graphical user interface:

Change directory to the ORACLE_HOME/bin directory of the Oracle Fusion Middleware installation:

(UNIX) ./ua
(Windows) ua.bat

2

Welcome Screen

Click Next to continue.

3

Specify Operation

Select Upgrade Oracle BI Publisher Repository.

Click Next to continue.

4

Specify Source Details

Select Upgrade 10g BI Publisher Repository Directory or Upgrade E-Business Suite Data Template Directory.

For Upgrade 10g BI Publisher Repository Directory, enter, or browse to the Repository Directory.

For Upgrade E-Business Suite Data Template Directory, enter, or browse to the Data Template Directory.

Note: Upgrade Assistant does not support reading the data definition from the E-Business Suite environment. Store the data template XML files in a file system and run Upgrade Assistant to create an equivalent data model definition in the BI Publisher Enterprise Server.

Click Next to continue.

5

Specify Destination Details

In the Repository Directory field, enter the destination 11g BI Publisher Repository directory.

For more information about the value to provide in this field, see Section 6.5.3, "About the Destination Directory for the 11g BI Publisher Repository".

Click Next to continue.

6

Specify WebLogic Server

Enter the following:

  • In the Host field, enter the WebLogic Administration Server's hostname, for example, localhost.

  • In the Port field, enter the server's port number, for example, 7001.

  • In the Username field, enter the administrator user name, for example, weblogic.

  • In the Password field, enter the password associated with the specified administrator user.

Click Next to continue.

7

Examining Components

During the examination process, Upgrade Assistant checks for the following:

  • The source directory exists.

  • The source directory is readable and contains a file for upgrade.

  • The destination directory exists.

  • Destination directory is writable and has sufficient space.

Under the Status column, the word succeeded should appear. If instead, the word failed appears, inspect the log file for details.

Click Upgrade.

8

Upgrade Summary

Click Upgrade to continue.

 

Upgrading Components

The upgrade process begins, and is completed when the status bar reaches 100 percent.

If there are errors during the upgrade, inspect the log file for details. The log files are located in the following directory:

(UNIX) BI_ORACLE_HOME/upgrade/logs/ua<timestamp>.log
(Windows) BI_ORACLE_HOME\upgrade\logs\ua<timestamp>.log

Where <timestamp> is the current date and time.

Click Next to continue.

9

Upgrade Complete

Click Close.


Note:

Review the log for any errors or warnings. Resolve any errors or warnings in 10g files and resolve them manually in the upgraded 11g repositories and catalogs.

6.5.3 About the Destination Directory for the 11g BI Publisher Repository

During the upgrade, the Upgrade Assistant prompts you for a destination for the 11g BI Publisher repository. When prompted for this location, you can enter one of the following:

  • The default repository location used by the Oracle Business Intelligence 11g installation. This default location is in the config directory, inside the domain directory. For example:

    MW_HOME\user_projects\domains\bifoundation_domain\config\bipublisher\repository
    
  • A new, temporary location, such as C:\Temp.

If you choose a new path for the upgraded repository and do not enter the path to the default 11g repository directory, then the Upgrade Assistant upgrades all your 10g catalog contents to the new location. Any seeded 11g content (such as the Sample Files), which were installed by the 11g installer, will not be included.

Make a note of this location, because you will need to reference it after the upgrade, as described in Section 8.2.2, "Completing the Upgrade of the BI Publisher Repository".

6.6 Task 6: Upgrade the BI Publisher Schema

Use the Oracle Fusion Middleware Upgrade Assistant to upgrade the BI Publisher Scheduler schema.

Upgrade Assistant is installed automatically into the bin directory of the Oracle Fusion Middleware Oracle home.

Note:

You can upgrade the BI Publisher Repository or Scheduler schema in any order.

Upgrade Assistant performs the schema upgrade by upgrading source BI Publisher Scheduler schema content into the destination BI Platform schema.

Note:

You can upgrade the Oracle BI EE Scheduler schema and the Oracle BI Publisher Scheduler schema at the same time by selecting both Upgrade Oracle BI EE Content and Upgrade Oracle BI EE Content in the Specify Operation screen.

Table 6-2 describes the procedure for upgrading just the Oracle BI Publisher Scheduler schema.

Table 6-2 Running Upgrade Assistant to Upgrade the BI Publisher Scheduler Schema

Step Screen Description and Action Required

1

None.

To start Upgrade Assistant using the graphical user interface:

Change directory to the ORACLE_HOME/bin directory of the Oracle Fusion Middleware installation:

(UNIX)./ua
(Windows) ua.bat

2

Welcome

Click Next to continue.

3

Specify Operation

Select Upgrade BI Platform Schema.

Select Upgrade Oracle BIEE Content.

Click Next to continue.

4

Specify BIP Source Database

Enter the details for the database that hosts the BI Publisher 10g Scheduler:

Database Types: Select the database type from the drop-down list.

Connect String: Enter the second portion of the connection string. Examples of the appropriate syntax for this field appear immediately below the field.

Source Schema: Enter the name of the existing 10g schema/database/user.

Password: Enter the password associated with the specified source schema.

DBA Username: To log in as the Oracle SYS database account specify SYS AS SYSDBA in this field.

DBA Password: Enter the password associated with the specified DBA Username.

Click Next to continue.

5

Specify Target Database

Enter the details for the database that hosts the Oracle Fusion Middleware 11g BI Publisher Scheduler target database:

Target Database Types: The target database type is based on the source database type.

Connect String: Enter the second portion of the connection string. Examples of the appropriate syntax for this field appear immediately below the field.

Password: Enter the password associated with the specified source schema.

DBA Username: To log in as the Oracle SYS database account specify SYS AS SYSDBA in this field.

DBA Password: Enter the password associated with the specified DBA Username.

Click Next to continue.

6

Specify Schema Name

Enter the 11g BI Publisher schema name from the drop-down list.

Schema Name: Select BIPLATFORM schema from the drop-down list, which has a prefix that is defined when you create the schema with RCU.

Password: Enter the password associated with the specified schema.

Click Next to continue.

7

Examining Components

Upgrade Assistant examines the following:

  • The database connection

  • The tables exists

  • Whether the schema has already been upgraded

Under the Status column, the word succeeded should appear. If instead, the word failed appears, inspect the log file for details.

Click Next to continue.

8

Upgrade Summary

Click Upgrade.

9

Upgrading Components

The upgrade process begins, and is completed when the status bar reaches 100 percent.

If there are errors during the upgrade, inspect the log file for details. The log files are located in the following directory:

BI_ORACLE_HOME/upgrade/logs/ua<timestamp>.log

For Windows Operating Systems:

BI_ORACLE_HOME\upgrade\logs\ua<timestamp>.log

Where <timestamp> is the current date and time.

Click Next to continue.

10

Upgrade Complete

Click Close.


Note:

Review the log for any errors or warnings. Resolve any errors or warnings in 10g files and resolve them manually in the upgraded 11g repositories and catalogs.

6.7 Task 7: Perform Any Required Post-Upgrade Configuration Tasks

See Section 8.2, "Post-Upgrade Tasks and Considerations for BI Publisher" for a description of the post-upgrade tasks that you might need to perform for each of the BI Publisher components.

6.8 Task 8: Verify the BI Publisher Upgrade

To verify that the BI Publisher upgrade was successful, see Section 5.8, "Task 8: Verify the Oracle BI EE Upgrade."