1.1.1 Analyzing and Optimizing the Existing 11g System

Migrating metadata and configuration from an existing Oracle BI 11g system requires time and resources. A poorly optimized 11g deployment can disrupt the migration process and can affect the performance of the 12c system. Oracle recommends that you analyze and optimize the existing 11g system by removing redundant content and merging and consolidating similar content.

When you analyze the existing 11g system, note the current hardware and operating system environment on which it is running. Compare the current environment with the Oracle Fusion Middleware 12c system requirements and certification information. There is a set of new system requirements for deploying Oracle BI 12c. For example, Oracle BI 12c requires a newer version of the operating system and a newer version of Java JDK. For more information, see:

• The system requirements document at Oracle® Fusion Middleware System Requirements and Specifications

• The certification document at Oracle Fusion Middleware Supported System Configurations

While analyzing the 11g system, note the following details:

• Name and size of the repository
• Name and size of the Oracle BI Presentation Catalog
• Existing security model details
• Data sources
• Number of scheduled jobs
• Any links to external systems

To optimize the existing 11g system in readiness for migration, perform the following tasks:

1. Run the Consistency Checker to check the validity of the 11g repository, and to identify and fix the syntax or semantic errors and warnings that can cause the queries to fail on the Oracle BI 12c Administration Tool. For more information, see Checking the Consistency of a Repository or a Business Model in Metadata Repository Builder's Guide for Oracle Business Intelligence Enterprise Edition.
2. Disable the initialization blocks that are no longer being used.
3. Identify and remove users and groups that are no longer required, and therefore do not need to be migrated.
4. Identify and remove objects in the repository and the Oracle BI Presentation Catalog that are no longer required, and therefore do not need to be upgraded.
5. If you have been using the Oracle BI Server usage tracking functionality, then review the usage tracking data to identify unused objects.
6. If you have been using the Oracle BI Server summary advisor functionality, then review the summary advisor for aggregated data and aggregation script.