BI Publisher Integration in EM12c

As some of you would already know, for my sins I am the product manager with responsibility for BI Publisher in Enterprise Manager [I must have a lot of sins because I’m also responsible for Change Management, Compliance Management, Configuration Management (these three form the Database Lifecycle Management pack), jobs, the target discovery framework, and at least part of DBaaS along with data cloning and refresh 🙂 )]. While I was investigating another issue from a customer, I re-discovered (no pun intended) one of the most useful notes you can find on BI Publisher use with EM12c. Many people may not even have realized how useful this note was, because the document’s title is somewhat misleading. It’s called Integrate BI Publisher (BIP) in EM 12c Console after Fresh Install or Upgrade of EM 12c Cloud Control (Doc ID 1392921.1). It’s been recently updated (March 9th) and covers all versions of EM12c – 12.1.0.1 through to 12.1.0.5. Now I know as a product manager I want people moving to the latest and greatest (which of course is EM13c – version number 13.1.0.0.0), but I’m also pragmatic enough to realize there are a lot of people still happily using EM12c. I hope none of you are back on versions 12.1.0.1 or 12.1.0.2 though! 🙂

So what does the document cover? Well, this is the table of contents from the document:

  • Integration procedure for EM Versions 12.1.0.1, 12.1.0.2, 12.1.0.3
    • A – Mandatory Pre-Requisites for the Integration of BI Publisher In Both Cases : After a Fresh Install or an Upgrade of EM 12c Cloud Control
      1. Download the BI Publisher (Business Intelligence Publisher)
      2. Installation of BI Publisher in “Software-only” mode.
    • B – Integration of BI Publisher After A Fresh Install of EM 12c Cloud Control
      1. Integrating BI Publisher with Enterprise Manager using the configureBIP Script in Normal Mode
      2. Check the integration.
    • C – Integration of BI Publisher After An Upgrade of EM 12c Cloud Control from 12.1.0.1 to 12.1.0.2 or from 12.1.0.1/12.1.0.2 to 12.1.0.3
      1. Integrating BI Publisher with Enterprise Manager using the configureBIP Script in Upgrade Mode
      2. Check the integration.
    • Integration procedure for EM Version 12.1.0.4 or 12.1.0.5
      • Oracle BI Publisher 11.1.1.7.0 is now bundled with Enterprise Manager Cloud Control 12.1.0.4 (EM 12cR4) or 12.1.0.5 (EM 12cR5)
      • A – Integration and configuration of BI Publisher in Normal Mode
      • B – Integration and configuration of BI Publisher in Upgrade Mode
    • Verification of the Integration of BI Publisher
    • Managing the BI Publisher Server : Start, Stop, Control the Status of BI Publisher
    • How to patch the Oracle BI Publisher integrated within Enterprise Manager (ONLY EM 12.1.0.4)
    • High Availability with BI Publisher and EM
      • EM versions 12.1.0.1 or 12.1.0.2 or 12.1.0.3
      • EM version 12.1.0.4 or 12.1.0.5
    • How to implement the security model
    • Documentation Information on other BI Publisher within EM Console administrative tasks
    • Documentation Information on developing BI Publisher Reports

    So if you use BI Publisher with any frequency at all in EM12c, bookmark that Doc ID!

Pete

After 22 years of working at Oracle in just about every role except Marketing and Support, I am now working as a Senior Managed Services Consultant with Data Intensity, specializing in Oracle Database technology, High Availability and Disaster Recovery solutions. I am also a member of the OakTable Network, and have presented at RMOUG Training Days, Hotsos Symposia, Oracle OpenWorld conferences, and other user group events. I have co-authored the Expert Oracle Enterprise Manager 12c and Practical Oracle Database Appliance books published by Apress, and am one of the authors of the Building Database Clouds in Oracle Database 12c book published by Addison Wesley.

Comments are closed.