4 Post-Migration Tasks for Oracle BI EE
After migrating the Oracle BI EE metadata, manually migrate the configuration settings for catalog groups and other components such as security for WebLogic and Enterprise Manager, BI Server, and BI Presentation Services.
- Migrating Catalog Groups
Catalog groups were a feature of Oracle BI EE that allowed administrators to organize users and application roles for security administration purposes. - Migrating Configuration of Oracle BI EE
After migrating the data, manually migrate the configuration information from the 11g system to the 12c system, which includes WebLogic security, Enterprise Manager security, the managed BI configurations, BI logs, BI Server, and BI Presentation Server configuration settings. - Configuring the Database to Use DataDirect Drivers
You must configure the database to use the appropriate DataDirect drivers. If you are using a database that is already configured to use the DataDirect drivers, modify the database configuration's odbc.ini file to use the correct DataDirect drivers. - Configuring Usage Tracking
The Oracle BI Server supports the collection of usage tracking data. When usage tracking is enabled, the BI Server collects usage tracking data for each query. The statistics are then written to a usage tracking log file or are inserted directly in to a database table. After you complete migrating and configuring the 12c system, you must enable usage tracking in the NQSConfig.INI file. - Configuring the SQL Server
After configuring the 12c system, you must configure the SQL Server settings in the odbc.ini file. - Adding Roles and Permissions
After migrating the data, you must add roles and permissions for BI Administrator, BI Author, and BI Consumer groups. - Configuring MySQL for Oracle BI
You must configure the MySQL database to use the DataDirect driver. If you are using a database that is already configured to use the DataDirect drivers, modify the database configuration's odbc.ini file to use the correct DataDirect drivers. - Checking Oracle BI JavaHost Configuration
Make sure that the XMLP and Oracle BI JavaHost settings match with the settings specified for the configuration of the 11g system. - Enabling Clusters
After migrating the data, you must manually enable the ClusterEnabled parameter in the ClusterConfig.xml file to turn on the cluster instances on the 12c system. - Enabling Oracle Hardware Acceleration and Compatibility Mode
Hardware acceleration affects the autocompletion of features such as dashboard prompts, trellis charts and microcharts, Summary Advisor functionality, and aggregate persistence for the TimesTen In-Memory database. Therefore, you must manually enable the bi:hw-acceleration flag in the 12c bi-config.xml file post-migration. You must also enable the bi:compat-mode-11g flag, so that the state of the 11g system is preserved at run time. - Setting the Compatibility Framework for Oracle BI Server
The compatibility framework allows the BI Server to add new features or bug fixes in Oracle BI 12c (12.2.1.1 and later) that are not compatible with the Oracle BI 11g releases while providing a flexible framework that enables the BI Server to operate in a compatibility mode with the earlier major release. Individual features and bug fixes can be enabled or disabled independently using compatibility flags. Alternatively, you can set all the compatibility flags to the default values using a single COMPATIBLE_RELEASE flag for the Oracle BI system to be compatible with the earlier release, which is 11.1.1.9. Add the COMPATIBLE_RELEASE parameter to the NQSConfig.INI file to ensure that the migrated 12c environment behaves as closely as possible to Oracle Business Intelligence 11g Release 1 (11.1.1.9) environment. - Migrating the Fusion Middleware MapViewer Configuration
Oracle Fusion Middleware Mapviewer (MapViewer) is a programmable tool for rendering maps using spatial data managed by Oracle Spatial and Graph or Oracle Locator (also referred to as Locator). MapViewer provides tools that hide the complexity of spatial data queries and cartographic rendering, while providing customizable options for more advanced users. These tools can be deployed in a platform-independent manner and are designed to integrate with map-rendering applications. After migrating the data, you must manually modify the 12c MapViewer configuration file to contain the same contents as the 11g file except the Logging section. - Resolving Authentication Issues After Migration
To avoid authentication issues post-migration, you must uncheck the Required for Authentication option in the DYNAMIC_OLAP_LOGIN initialization block. - Copying Configuration Files
You must manually copy the following configuration files after the migration: writebacktemplate.xml, userpref_currencies.xml, and bicustom.ear. - Removing the Display of HTML Codes in a Customized "No Results" Message
In an analysis, content developers can control the text that is displayed when the results of the analysis return no data. Content developers can accept the default message, or they can customize the text of the message, including by inserting HTML formatting codes in the message.
Migrating Catalog Groups
Catalog groups were a feature of Oracle BI EE that allowed administrators to organize users and application roles for security administration purposes.
In Oracle BI Release 12c (12.2.1.1 and higher), catalog groups are obsolete. The catalog groups are migrated by the upgrade process to application roles.
Parent topic: Post-Migration Tasks for Oracle BI EE
Migrating Configuration of Oracle BI EE
After migrating the data, manually migrate the configuration information from the 11g system to the 12c system, which includes WebLogic security, Enterprise Manager security, the managed BI configurations, BI logs, BI Server, and BI Presentation Server configuration settings.
- Migrating the Security Configuration for Oracle BI with Oracle WebLogic Server
Oracle BI 12c is tightly integrated with the Oracle Fusion Middleware Security architecture and delegates core security functionality to components of that architecture. By default, an Oracle BI installation is configured with an authentication provider that uses the Oracle WebLogic Server embedded LDAP server for user and group information. The Oracle BI default policy store provider and credential store provider stores credentials, application roles, and application policies in files in the domain. You must manually migrate the security configuration for Oracle BI from the 11g system to the 12c system with Oracle WebLogic Server. - Migrating the Oracle Enterprise Manager Fusion Middleware Control Security Configuration
Most of the security configuration related to application roles, security grants, and application policies are migrated to the Oracle Enterprise Manager Fusion Middleware Control 12c during the migration process. You must examine and manually apply any special Security Provider configuration in the Fusion Middleware Control 12c. - Migrating the Oracle Enterprise Manager Fusion Middleware Control Managed Business Intelligence Configurations
The Fusion Middleware Control is used to manage some of the important configurations for Oracle BI. You must manually examine the configuration of the General, Presentation, Performance, and Mail sections of the Fusion Middleware Control 11g and apply the same settings to the 12c system. - Migrating the Oracle Enterprise Manager Fusion Middleware Control Managed Business Intelligence Log Configuration
The Oracle Enterprise Manager Fusion Middleware Control is used to manage the log configuration for the Oracle BI components. You must manually examine the log configuration settings in the 11g system and apply the same settings to your 12c system. - Migrating the Oracle BI Server Configuration
Various files for the BI Server contain configuration information: odbc.ini and tnsnames.ora. The odbc.ini file contains non-Oracle data source (DSN) connection information. The tnsnames.ora file contains network service names mapped to connect descriptors for the local naming method, or net service names mapped to listener protocol addresses. You must examine these 11g files and manually copy the configuration information to the respective 12c files. - Migrating the Oracle BI Presentation Server Configuration
The Oracle BI Presentation Services process hosts most of the business logic of the Web server and provides the framework and interface for the presentation of business intelligence data to web clients. The userpref_currencies.xml file defines the currency options that are displayed in the Currency box of the Preferences tab of the My Account dialog. The bridgeconfig.properties file contains the Presentation Services Plug-in information. Examine these 11g files and manually copy the configuration information to the respective 12c files.
Parent topic: Post-Migration Tasks for Oracle BI EE
Migrating the Security Configuration for Oracle BI with Oracle WebLogic Server
Oracle BI 12c is tightly integrated with the Oracle Fusion Middleware Security architecture and delegates core security functionality to components of that architecture. By default, an Oracle BI installation is configured with an authentication provider that uses the Oracle WebLogic Server embedded LDAP server for user and group information. The Oracle BI default policy store provider and credential store provider stores credentials, application roles, and application policies in files in the domain. You must manually migrate the security configuration for Oracle BI from the 11g system to the 12c system with Oracle WebLogic Server.
- Examine your Oracle BI 11g WebLogic security configuration by accessing the Oracle BI 11g WebLogic Console to examine the current security configuration for security providers.
- Manually configure the same security configuration in WebLogic Console of Oracle BI 12c.
Parent topic: Migrating Configuration of Oracle BI EE
Migrating the Oracle Enterprise Manager Fusion Middleware Control Security Configuration
Most of the security configuration related to application roles, security grants, and application policies are migrated to the Oracle Enterprise Manager Fusion Middleware Control 12c during the migration process. You must examine and manually apply any special Security Provider configuration in the Fusion Middleware Control 12c.
- Examine the Security Provider configuration in the Oracle Enterprise Manager Fusion Middleware Control 11g.
- Validate the Oracle Enterprise Manager Fusion Middleware Control 12c security setup by searching application policies and appropriate users.
- Apply any special Security Provider configuration in the Oracle Enterprise Manager Fusion Middleware Control 12c.
- Ensure that the user, group, and application roles appear correctly in the 12c system.
Parent topic: Migrating Configuration of Oracle BI EE
Migrating the Oracle Enterprise Manager Fusion Middleware Control Managed Business Intelligence Configurations
The Fusion Middleware Control is used to manage some of the important configurations for Oracle BI. You must manually examine the configuration of the General, Presentation, Performance, and Mail sections of the Fusion Middleware Control 11g and apply the same settings to the 12c system.
Parent topic: Migrating Configuration of Oracle BI EE
Migrating the Oracle Enterprise Manager Fusion Middleware Control Managed Business Intelligence Log Configuration
The Oracle Enterprise Manager Fusion Middleware Control is used to manage the log configuration for the Oracle BI components. You must manually examine the log configuration settings in the 11g system and apply the same settings to your 12c system.
- In the Fusion Middleware Control 11g, navigate to the Business Intelligence link and examine the settings in the Diagnostics tab.
- Note the configuration settings and apply the Oracle BI component log configuration and component log levels in the Fusion Middleware Control 12c.
Parent topic: Migrating Configuration of Oracle BI EE
Migrating the Oracle BI Server Configuration
Various files for the BI Server contain configuration information: odbc.ini and tnsnames.ora. The odbc.ini file contains non-Oracle data source (DSN) connection information. The tnsnames.ora file contains network service names mapped to connect descriptors for the local naming method, or net service names mapped to listener protocol addresses. You must examine these 11g files and manually copy the configuration information to the respective 12c files.
Parent topic: Migrating Configuration of Oracle BI EE
Migrating the Oracle BI Presentation Server Configuration
The Oracle BI Presentation Services process hosts most of the business logic of the Web server and provides the framework and interface for the presentation of business intelligence data to web clients. The userpref_currencies.xml file defines the currency options that are displayed in the Currency box of the Preferences tab of the My Account dialog. The bridgeconfig.properties file contains the Presentation Services Plug-in information. Examine these 11g files and manually copy the configuration information to the respective 12c files.
Parent topic: Migrating Configuration of Oracle BI EE
Configuring the Database to Use DataDirect Drivers
You must configure the database to use the appropriate DataDirect drivers. If you are using a database that is already configured to use the DataDirect drivers, modify the database configuration's odbc.ini file to use the correct DataDirect drivers.
Parent topic: Post-Migration Tasks for Oracle BI EE
Configuring Usage Tracking
The Oracle BI Server supports the collection of usage tracking data. When usage tracking is enabled, the BI Server collects usage tracking data for each query. The statistics are then written to a usage tracking log file or are inserted directly in to a database table. After you complete migrating and configuring the 12c system, you must enable usage tracking in the NQSConfig.INI file.
Note:
Ensure that the queries of the BI Server are being tracked in the table by view data.Parent topic: Post-Migration Tasks for Oracle BI EE
Configuring the SQL Server
After configuring the 12c system, you must configure the SQL Server settings in the odbc.ini file.
Parent topic: Post-Migration Tasks for Oracle BI EE
Adding Roles and Permissions
After migrating the data, you must add roles and permissions for BI Administrator, BI Author, and BI Consumer groups.
Parent topic: Post-Migration Tasks for Oracle BI EE
Configuring MySQL for Oracle BI
You must configure the MySQL database to use the DataDirect driver. If you are using a database that is already configured to use the DataDirect drivers, modify the database configuration's odbc.ini file to use the correct DataDirect drivers.
Parent topic: Post-Migration Tasks for Oracle BI EE
Checking Oracle BI JavaHost Configuration
Make sure that the XMLP and Oracle BI JavaHost settings match with the settings specified for the configuration of the 11g system.
Parent topic: Post-Migration Tasks for Oracle BI EE
Enabling Clusters
After migrating the data, you must manually enable the ClusterEnabled parameter in the ClusterConfig.xml file to turn on the cluster instances on the 12c system.
Parent topic: Post-Migration Tasks for Oracle BI EE
Enabling Oracle Hardware Acceleration and Compatibility Mode
Hardware acceleration affects the autocompletion of features such as dashboard prompts, trellis charts and microcharts, Summary Advisor functionality, and aggregate persistence for the TimesTen In-Memory database. Therefore, you must manually enable the bi:hw-acceleration flag in the 12c bi-config.xml file post-migration. You must also enable the bi:compat-mode-11g flag, so that the state of the 11g system is preserved at run time.
Parent topic: Post-Migration Tasks for Oracle BI EE
Setting the Compatibility Framework for Oracle BI Server
The compatibility framework allows the BI Server to add new features or bug fixes in Oracle BI 12c (12.2.1.1 and later) that are not compatible with the Oracle BI 11g releases while providing a flexible framework that enables the BI Server to operate in a compatibility mode with the earlier major release. Individual features and bug fixes can be enabled or disabled independently using compatibility flags. Alternatively, you can set all the compatibility flags to the default values using a single COMPATIBLE_RELEASE flag for the Oracle BI system to be compatible with the earlier release, which is 11.1.1.9. Add the COMPATIBLE_RELEASE parameter to the NQSConfig.INI file to ensure that the migrated 12c environment behaves as closely as possible to Oracle Business Intelligence 11g Release 1 (11.1.1.9) environment.
Note:
If the COMPATIBLE_RELEASE parameter is not set, then the system defaults to the behavior of the current release, such as 12.2.1.3.0.The framework does not distinguish individual bundle patches (only the first four digits of the version number are significant for determining compatibility).
When applying new features, enhancements, or bug fixes that are not inherently backward-compatible, ensure that you specify a compatibility flag using the guidelines described in this topic.
Note:
The NQSConfig.INI file does not contain the COMPATIBLE_RELEASE parameter by default. The global bi:compat-mode-11g is the default flag and it applies to all Oracle BI EE components. When the bi:compat-mode-11g element in the bi-config.xml file is set totrue
, the BI Server compatibility framework behaves as if the COMPATIBLE_RELEASE were set to 11.1.1.9 and it disables any features or bug fixes that would cause major compatibility issues during migration from 11g to 12c. However, if you explicitly edit the NQSConfig.INI file to set the COMPATIBLE_RELEASE parameter or any other compatibility flag, then the setting in the NQSConfig.INI file takes precedence over the global bi:compat-mode-11g flag specified in the bi-config.xml file.
In addition to setting the general COMPATIBLE_RELEASE parameter, you can set compatibility flags for specific features or bug fixes, which begin with the prefix "OBIS_". Instructions to set these specific compatibility flags are provided by the support team to solve certain issues on a need basis. For example,
[ COMPATIBILITY ]
COMPATIBLE_RELEASE=11.1.1.9;
OBIS_ENABLE_DIMENSIONALITY=0;
Setting the COMPATIBLE_RELEASE parameter or specific compatibility flags in the NQSConfig.INI file applies the changes to the entire system. You can also set the COMPATIBLE_RELEASE parameter or the specific feature flag as a session variable or an environment variable so that the compatibility mode is set to specific reports or dashboards. You can do this by adding a query prefix to an analysis request. The following is an example of a variable setting:
set variable COMPATIBLE_RELEASE='11.1.1.9':
Parent topic: Post-Migration Tasks for Oracle BI EE
Migrating the Fusion Middleware MapViewer Configuration
Oracle Fusion Middleware Mapviewer (MapViewer) is a programmable tool for rendering maps using spatial data managed by Oracle Spatial and Graph or Oracle Locator (also referred to as Locator). MapViewer provides tools that hide the complexity of spatial data queries and cartographic rendering, while providing customizable options for more advanced users. These tools can be deployed in a platform-independent manner and are designed to integrate with map-rendering applications. After migrating the data, you must manually modify the 12c MapViewer configuration file to contain the same contents as the 11g file except the Logging section.
- Go to the 12c Fusion Middleware MapViewer Administration Console.
- Create a copy of the default 12c MapViewer configuration file.
- Overwrite the contents in the copy of the 12c MapViewer configuration file with the content from the mapViewerConfig.xml file from the 11g MapViewer install.
- Replace the logging section of the MapViewer configuration file copy with the settings from the default 12c MapViewer configuration file.
- Update the logging settings log levels of the MapViewer configuration file as needed for the 12c.
- Click Save on the 12c MapViewer Administration Console and then click Restart.
Parent topic: Post-Migration Tasks for Oracle BI EE
Resolving Authentication Issues After Migration
To avoid authentication issues post-migration, you must uncheck the Required for Authentication option in the DYNAMIC_OLAP_LOGIN initialization block.
Note:
Follow this procedure only if you are migrating from Oracle BI Release 11.1.1.7 to 12c.Parent topic: Post-Migration Tasks for Oracle BI EE
Copying Configuration Files
You must manually copy the following configuration files after the migration: writebacktemplate.xml, userpref_currencies.xml, and bicustom.ear.
Parent topic: Post-Migration Tasks for Oracle BI EE
Removing the Display of HTML Codes in a Customized "No Results" Message
In an analysis, content developers can control the text that is displayed when the results of the analysis return no data. Content developers can accept the default message, or they can customize the text of the message, including by inserting HTML formatting codes in the message.
If content developers customized the message and included HTML codes in Release 11g, then the message is displayed with the codes showing as readable text in Release 12c, rather than performing their functions to format the message. To work around this issue, open the Analysis Properties dialog for each analysis whose custom message includes HTML codes and select the Contains HTML Markup option.
For information on the use of the Contains HTML Markup option, see EnableSavingContentWithHTML in Security Guide for Oracle Business Intelligence Enterprise Edition.
Parent topic: Post-Migration Tasks for Oracle BI EE