22 Patching Oracle Business Intelligence Systems

This chapter provides information on patching Oracle Business Intelligence.

See Oracle Fusion Middleware Patching Guide.

This chapter includes the following sections:

About Patching Oracle Business Intelligence Systems

Patching involves copying a small collection of files over an existing installation.

A patch is normally associated with a particular version of an Oracle product and involves updating from one minor version of the product to a newer minor version of the same product (for example, from version to version A patch set is a single patch that contains a collection of patches that are designed to be applied at the same time.

Typically you apply a patch that contains one or more bug fixes to an existing production Oracle BI EE system that is distributed across one or more computers. Bug fixes might affect the system components and Java components that are deployed inside the Oracle WebLogic Server. The patch might include new server executables and updated and new Java class files.

Where Do I Find Complete Information on Patching?

You use the Oracle OPatch utility to apply (and to roll back) Oracle BI EE platform patches. You download patches from Oracle Support Services. Consult the following sources:

  • For complete information about patching in Oracle Fusion Middleware, see Oracle Fusion Middleware Patching Guide.

  • The patch readme contains all the information necessary to understand what the patch does and the steps that you must perform to apply the patch. You access the Readme documentation from the Patches & Updates screen on the My Oracle Support site when downloading patches.

Updating an Existing 12c BI Server Installation

This section explains how you update an existing 12.2.x BI Server installation.


  • For one-off patches you download <patch-number>.ZIP from:


  • For all other updates you download bi_platform-12.2.x.y.z-<platform>.<extension> from:


  • Software updates will only change ORACLE_HOME and PRODUCT_HOME content, DOMAIN_HOME and BI_DATA_HOME will be untouched.


All product processes have been shutdown.

  1. For each distinct ORACLE_HOME, run the Oracle Universal Installer.

    For information, see new server install in Installing and Configuring Oracle Business Intelligence.

  2. (Optional) For each distinct ORACLE_HOME, you launch OPatch (ORACLE_HOME/OPatch/opatch) with the zip file.

    This will update the ORACLE_HOME.

What Happens If a Patching Conflict Occurs?

If a patching conflict occurs, then the process stops. An example of a conflict is when a duplicate patch fixes the same set of bugs fixed by another patch.

For details on resolving patch conflicts, see Oracle OPatch User's Guide. Contact Oracle Support Services for assistance in resolving conflicts.

What Is Patched for the Oracle Business Intelligence Platform?

Oracle Business Intelligence platform patching applies patches for binary files with extensions such as DLL, JAR, and EXE.

Oracle Business Intelligence platform patching does not patch the following:

  • Configuration Files

    If configuration updates are required as part of a patch, then these are detailed in the accompanying README.txt file, and you must manually apply them. No automated mechanism is available for merging customer configuration and patched configuration files.

  • Schema-based Metadata

    Nondesign-time metadata that is stored in database schemas (including schemas for the Scheduler, usage statistics, event polling, repository files, and the Oracle BI Presentation Catalog) is not patched.

    Other platform metadata (such as repository files and Oracle BI Presentation Catalog files) that are delivered in the context of an application are patched, but as part of an applications patch and not as part of a platform patch.

Rolling Back a Platform Patch

OPatch maintains metadata for each patch that is applied to each Oracle home and keeps copies of what it replaces during a patch.

You can roll back a complete patch.


To confirm that an Oracle BI EE platform patch is no longer applied after a rollback, you must establish the patch levels before applying the rollback, then repeat the task after rollback. See Determining Current Patch Levels.

Determining Current Patch Levels

Each Oracle home must be patched to the same version as OPatch to ensure that Oracle BI EE functions properly.

Use the OPatch lsinventory utility to determine the current patch version for any given Oracle home in the system. You can also use the utility to retrieve a full list of patches, with their corresponding IDs, for a given Oracle home.

  1. Display a command window and navigate to the location of the OPatch executable:


  2. Run the lsinventory utility using the following command syntax:

    Path_to_OPatch/opatch lsinventory [-all] [-detail] [-patch] [-oh (Oracle home location)]

    For example:

    opatch lsinventory -patch -detail

    For information about the lsinventory options, see the user guides in the ORACLE_HOME/OPatch/docs directory.

  3. To run the lsinventory utility against other Oracle homes, repeat the previous steps for each Oracle home.

See Oracle Fusion Middleware Patching Guide.