This chapter describes how to upgrade an existing Oracle Business Intelligence Enterprise Edition (Oracle BI EE) 10g Release 3 (10.1.3.2 or later) environment to Oracle Business Intelligence 10g.
This chapter contains the following sections:
Task 1: Understand the Starting Points for Oracle BI EE Upgrade
Task 2: Decide Upon an Oracle Business Intelligence Topology
Task 3: Run RCU to Create the Destination BIPLATFORM Schemas
Task 7: Perform Any Required Post-Upgrade Configuration Tasks
For information about starting points for an Oracle Business Intelligence upgrade, see Chapter 3, "Supported Starting Points for Oracle Business Intelligence Upgrade." If you are running a version of Oracle Business Intelligence older than version specified in Chapter 3, then you must upgrade to the supported starting point version before attempting to upgrade to 11g.
This guide provides instructions for upgrading from Oracle Business Intelligence 10g to the latest Oracle Business Intelligence 11g.
If you are already running Oracle Fusion Middleware 11g, then see the Oracle Fusion Middleware Patching Guide, which provides information about applying the latest Oracle Fusion Middleware patches. In particular, for information on applying the latest patch set to an existing Oracle BI EE 11g installation, review the following key sections of the Oracle Fusion Middleware Patching Guide:
Note that when you review the post-patching procedures, refer to the specific post-patching procedures for your starting point release, as well as the post-patching procedures that are specific to Oracle BI EE.
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 Oracle Business Intelligence 11g integration with Oracle WebLogic Server and Oracle Fusion Middleware applications.
Before you can install Oracle Business Intelligence 10g, you must first identify and prepare a database for the Oracle Business Intelligence 10g 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:
The Oracle Fusion Middleware Repository Creation Utility User's Guide
"Create Database Schemas Using the Repository Creation Utility" in Oracle Fusion Middleware Installation Guide for Oracle Business Intelligence.
While using RCU to install the Oracle Business Intelligence schemas, note the following important information:
Database Connection Details screen — Select the type of database on the system. This is the database in which you create the Oracle Business Intelligence schemas. Provide the necessary credentials for RCU to be able to connect to the database.
Select Components screen — Near the top of the screen, select Create a New Prefix. The default prefix is DEV. You can provide another prefix, if preferred. Select a prefix that will allow you to quickly and easily identify the schema.
Expand the Business Intelligence component group by clicking the plus sign (+) next to it. Then, click Business Intelligence Platform so that a check appears next to it. This action automatically selects the Metadata Services (MDS) schema (under the AS Common Schemas group), which is also required by Oracle Business Intelligence.
Use the Oracle Business Intelligence 10g installer to install Oracle Business Intelligence 10g on a separate host computer. Do not install Oracle Business Intelligence 10g on a computer that is running Oracle Business Intelligence 10g, as this installation scenario is not supported.
For more information, see the following topics:
Section 5.4.1, "Availability of the 10g Oracle BI Repository and Catalog Files"
Section 5.4.2, "Installing Oracle Business Intelligence 11g in Preparation for Upgrade"
When you install Oracle Business Intelligence 11g, ensure that the following 10g source directories are accessible to the Oracle Business Intelligence 10g Upgrade Assistant, which you run from the Business Intelligence 10g Oracle home. Upgrade Assistant must be able to browse to and access these directories:
Directories that contain the 10g Oracle BI repository files
The 10g Catalog and Catalog Deliveries directories
If the 10g installation is 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 5-2 for information about specifying the source details for these components on the Specify Source Details screen of Upgrade Assistant.
Before you upgrade to Oracle Business Intelligence 10g, you must install and configure a new Oracle Business Intelligence 10g environment on a separate host from the Oracle Business Intelligence 10g host computer.
When you perform the installation with the Oracle Business Intelligence 10g installer, you can select the Enterprise install for new installations installation type, or you can select the Software Only installation type.
For more information, see the following sections:
Installing Oracle Business Intelligence Using the Enterprise Installation Type
Installing Oracle Business Intelligence 10g Using the Software Only Installation Type
The Enterprise install for new installations installation type automatically installs Oracle WebLogic Server and provides all the options you need to configure an enterprise-ready Oracle Business Intelligence 10g installation.
For more information, see "Enterprise Install for New Installations" in Oracle Fusion Middleware Installation Guide for Oracle Business Intelligence.
When you are using the Oracle Business Intelligence 10g installer, note the following when you are installing in preparation for an upgrade from Oracle Business Intelligence 10g:
On the Select Installation Type screen, select Enterprise install for new installations. This option installs and configures a new Oracle Business Intelligence system for a hosted deployment.
On the Create or Scale Out BI System screen, select Create New BI System.
On the Specify Installation Location screen, specify the location of the new Oracle Middleware home that will be created by the installer. The installer will install Oracle WebLogic Server and the Oracle Business Intelligence 10g Oracle home inside the Middleware home.
On the Database Details screen, specify the database type, the database connection string, and the user name and password for the Business Intelligence Platform schema you installed in Section 5.3, "Task 3: Run RCU to Create the Destination BIPLATFORM Schemas".
If you are installing on a 64-bit operating system, then you must perform the steps listed in Table 5-1.
Table 5-1 Summary of the Steps Required to install Oracle Business Intelligence 11g on a 64-bit Operating System
| Task | Description | Tool | More Information |
|---|---|---|---|
|
Install Oracle WebLogic Server and create a Middleware home. |
This step copies the Oracle WebLogic Server binary files to disk and creates a Middleware home directory where you will install your Oracle Business Intelligence 10g Oracle home. |
Oracle WebLogic Server Installer |
Oracle Fusion Middleware Installation Guide for Oracle WebLogic Server |
|
Install the Oracle Business Intelligence 10g files and create the BI Oracle home. |
This step copies the Oracle Business Intelligence 10g binaries files to disk and creates a new Oracle Business Intelligence Oracle home inside the Middleware home. |
Oracle Business Intelligence 10g Installer |
"Software Only Install" in the Oracle Fusion Middleware Installation Guide for Oracle Business Intelligence |
|
Configure your new Oracle Business Intelligence 10g environment. |
This steps creates a new Oracle WebLogic Server domain and the required Oracle WebLogic Server servers for your new 10g environment. |
Oracle Business Intelligence 10g Configuration Assistant |
"Configuring Oracle Business Intelligence with the Configuration Assistant" in the Oracle Fusion Middleware Installation Guide for Oracle Business Intelligence |
Use the Oracle Fusion Middleware Upgrade Assistant to upgrade the Oracle BI repository and Catalog. For more information, see the following topics:
Before running Upgrade Assistant configure TNSNAMES.ora in the 11g system so that it connects to any databases that are used by the Oracle BI repository.
In addition, any custom changes to the Oracle BI EE 10g configuration files, for example, instanceconfig.xml, are not upgraded by Upgrade Assistant. You must manually edit the 11g configuration files to re-apply the customizations.
The following configuration changes might be necessary before running Upgrade Assistant:
Confirm that any data sources that are used by the Oracle BI repository are configured in the 11g system.
If you configured the nqsconfig.ini file in the 10g system for database authentication, for an 11g system you must follow the instructions in "Configuring an Oracle Database as the Security Store" in the Oracle Fusion Middleware Security Guide for Oracle Business Intelligence Enterprise Edition.
Some parameters in the nqsconfig.ini file are centrally managed by Fusion Middleware Control in 11g and cannot be set manually. For more information about using the nqsconfig.ini file in Oracle Business Intelligence 10g, see "NQSConfig.INI File Configuration Settings" in Oracle Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition.
If you have configured catalog directory hashing in your 10g instanceconfig.xml , for example:
<Catalog> <HashUsersHomeDirectories>2</HashUsersHome Directories> </Catalog>
Then you must include the same catalog entry in the 11g instanceconfig.xml file where you are planning to run the upgrade prior to running Upgrade Assistant. This is to prevent all user content becoming inaccessible.
The Administration Server and the Managed Server must remain running during the upgrade process.
Upgrade Assistant is installed automatically into the bin directory of the Oracle Fusion Middleware Oracle home. For information on the Oracle home, see Section 4.1, "Oracle Business Intelligence 11g and Oracle WebLogic Server."
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 5-2 Running Upgrade Assistant to Upgrade the Oracle BI Repository and Catalog
| Step | Screen | Description and Action Required |
|---|---|---|
|
1 |
None. |
To start Upgrade Assistant using the graphical user interface, change the directory to the Note: If you have multiple Oracle BI repositories, you must run Upgrade Assistant once for each Oracle BI repository. (UNIX) ./ua (Windows) ua.bat |
|
2 |
Click Next to continue. |
|
|
3 |
Click Next to continue. Note: Specify the option while doing the upgrade, or it will take up the default option. |
|
|
4 |
Enter the details for the source 10g Oracle BI repository and Catalog. This could be in the existing 10g installation, or a copy made to a shared network location or USB drive: Upgrade Repository (RPD) RPD File: Enter the name of the Oracle BI repository file. Administrator User Name: Enter the 10g Administrator User Name. Typically the name is Administrator Password: Enter the 10g Administrator Password Enter the password which will be used to secure the upgraded 11g RPD: The repository password does not have to match the Administrator or any other password. Upgrade Catalog Catalog Directory: Enter the name, or browse to the Catalog Directory. Catalog Deliveries Directory: In 10g, the
OracleBIData/web/catalog
In many cases, the 10g directory is empty. If the 10g Click Next to continue. |
|
|
5 |
Enter the following:
Click Next to continue. |
|
|
6 |
During the examination process, Upgrade Assistant checks for the following:
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. |
|
|
7 |
Click Upgrade. |
|
|
8 |
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. You can also check the component log files, in directories organized by component under ORACLE_INSTANCE\diagnostics\logs Click Next to continue. |
|
|
9 |
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.The 10g iBots (called agents in 11g) are stored entirely in the Oracle BI Presentation Catalog. If you upgrade the catalog, then you have all the agents, but they will not run automatically. (The scheduler schema holds the list of jobs that the scheduler runs, including agents).
You could choose to re-enable the agents in the catalog instead of upgrading the scheduler schema. This is a valid use case as you might want to enable a subset of agents for test purposes after upgrading.
Use the Oracle Fusion Middleware Upgrade Assistant to upgrade the Oracle BI EE Scheduler schema to the new BIPLATFORM schema.
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.
Upgrade Assistant performs the Scheduler schema upgrade by upgrading source schema content into the destination Oracle Business Intelligence Scheduler schema content.
Note:
You can upgrade the Oracle BI EE Scheduler schema and the Oracle BI Publisher Scheduler schema at the same time by selecting both and in the Specify Operation screen.Table 5-3 describes the procedure for upgrading just the Oracle BI EE Scheduler schema.
Table 5-3 Running Upgrade Assistant to Upgrade the Oracle BI EE Scheduler Schema
| Step | Screen | Description and Action Required |
|---|---|---|
|
1 |
None. |
To start Upgrade Assistant using the graphical user interface: Change the directory to the For UNIX: ./ua On a Windows operating system: ua.bat |
|
2 |
Click Next to continue. |
|
|
3 |
Select Upgrade Oracle BIEE content. Click Next to continue. |
|
|
4 |
Enter the details for the database that hosts the Oracle BI EE 10g Scheduler schema: Database Type: 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. BIEE 10g Schema: Enter the name of the existing 10g schema database user. BIEE 10g Password: Enter the password associated with the specified source schema. DBA User Name: To log in as the Oracle SYS database account specify DBA Password: Enter the password associated with the specified DBA Username. |
|
|
5 |
Enter the details for the database that hosts the Oracle BI EE 11g BI 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 JdbcConnectionString. Examples of the appropriate syntax for this field appear immediately below the field. 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. |
|
|
6 |
Enter the 11g BI schema name for the target database. 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 |
Upgrade Assistant examines the components and checks that the source and target schemas contain the expected columns. 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 |
Click Upgrade. |
|
|
9 |
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 |
Click Close. |
Note:
Review the log file for any errors or warnings. Resolve any errors or warnings found in the 10g files manually in the upgraded 11g repositories and catalogs.See Section 8.1, "Post-Upgrade Tasks and Considerations for Oracle Business Intelligence Enterprise Edition" for a description of the post-upgrade tasks you might need to perform for Oracle BI EE components.
Note:
Check the final Upgrade Assistant screen for suggested manual upgrade steps.You can verify that Oracle BI EE has been upgraded successfully by logging into the 11g system to confirm that the Oracle BI EE components are up and running.
You can also verify the upgrade using either of the following methods:
Run the Upgrade Assistant again and select Verify Instance on the Specify Operation page.
Follow the instructions on the screen for information on how to verify that specific Oracle Fusion Middleware components are up and running.
Use the Fusion Middleware Control to verify that the Oracle Business Intelligence components are up and running.
For more information, see "Getting Started Using Oracle Enterprise Manager Fusion Middleware Control" in Oracle Fusion Middleware Administrator's Guide.