This discussion is archived
5 Replies Latest reply: Jan 25, 2013 12:31 PM by AdeeshFulay RSS

Additional Storage/Memory requirements for adding BI Publisher?

lrp1 Newbie
Currently Being Moderated
Hello, all. I'm running an OEM 12.1.0.2.0 (about to try applying the recently released 12.1.0.2.1 PSU , patch 14840279) inside a Solaris 10 x86_64 zone. It's been given about 12-16GB of memory for a small deployment. I have a 11.2.0.3 Oracle Database repository and the OEM 12cR2 running on the same box. Together, that eats up.

Looking at OEM12c's reporting feature, they still do let us use Information Publisher, but clearly state in the documents (http://docs.oracle.com/cd/E24628_01/doc.121/e24473/information_publisher.htm#BGBGDBCG) that new development is DEPRECATED. I'm worried about how to develop reports now.. I assume we all have to go to a heavyweight Oracle BI Publisher solution now. My question is, how much heavier is it? I'm a DBA and haven't had much experience running middleware.

I've been looking at the BI Publisher docs (Oracle® Fusion Middleware Installation Guide for Oracle Business Intelligence
11g Release 1 (11.1.1) - http://docs.oracle.com/cd/E14571_01/bi.1111/e10539/c3_requrmnts.htm ) requirements section, but it points me to the main Oracle Fusion Middleware download section.

I navigate that to eventually land on the Oracle® Fusion Middleware System Requirements and Specifications for Oracle Forms and Reports 11g Release 2 (11.1.2) ( http://docs.oracle.com/html/E25460_01/r2_fr_requirements.htm ).

I infer that I require 2GB physical memory and 4GB memory+swap for my Solaris installation (UNIX).

Does anybody know if that 2GB is for a brand new install, or whether I could get away with less if I already had an OEM installation? We had never sized our build to accommodate DB + OEM + agent + BI.
  • 1. Re: Additional Storage/Memory requirements for adding BI Publisher?
    Courtney Llamas Journeyer
    Currently Being Moderated
    Check the adv config sizing guide... about 2gb extra memory is required.

    http://docs.oracle.com/cd/E24628_01/install.121/e24089/sizing.htm#autoId15

    BI Publisher Configuration

    If you plan on integrating BI Publisher version 11.1.1.5 with Enterprise Manager Release 12c Cloud Control, which is required for BI Publisher reports to function, add 1.5 GB to the host memory requirements stated above.
  • 2. Re: Additional Storage/Memory requirements for adding BI Publisher?
    AdeeshFulay Explorer
    Currently Being Moderated
    Since you are on EM 12.1.0.2, you should be using BIP 11.1.0.6 and not 11.1.0.5. Installing the wrong version can cause serious issues with your EM install, so please be careful.

    Refer to the Additional software section on the EM download page;
    http://www.oracle.com/technetwork/oem/grid-control/downloads/index.html
  • 3. Re: Additional Storage/Memory requirements for adding BI Publisher?
    lrp1 Newbie
    Currently Being Moderated
    thank you both -- I was about to ask about that discrepancy. The EM 12c documentation isn't quite clear, and in some places didn't appear to be updated to reflect the newer BI version 11.1.1.6 out there. Your link with the ch14 "Integrating BI Publisher with Enterprise Manager" looks like what I need.

    to confirm memory usage then, is it:
    6 GB for OEM (per http://docs.oracle.com/cd/E24628_01/install.121/e24089/sizing.htm#BCGDAFCA , small deployment) +
    +1.5 GB for BI (per http://docs.oracle.com/cd/E24628_01/install.121/e24089/install_em_bip.htm)

    Since I'm sticking the DB repository on the same machine, I figured to add another 2GB to the memory spec (as a minimum, not recommended).

    I'd assume that I simply:
    - download BI 11.1.1.6 software from OTN
    - Install software only **IMPORTANT**
    - install into middleware home of OMS (presumably /u01/app/oracle/middleware)
    - create BI home as "Oracle_BI1" <-- must use this name
    - backup domain configuration (zip) (cd <Instance-Home>/user_projects/domains and zip -r GCDomain.zip GCDomain)
    - run /u01/app/oracle/middleware/oms/bin/configureBIP
    - use the SYSDBA account, weblogic admin user password, node manager password
    - specify an HTTP and HTTPS port for the BI Publisher Managed Server: *<-- are these two new ports that I need to have publicly accessible to web-users? or are they existing ports that I should have already had in my OMS config?*
    for instance, the documentation seems to show 9701 as a sample port.. are there recommended default ports to stick to? (like how we typically do with listener, agent, oms ports?)

    Edit: I've also linked to a PDF illustrating the process screen-by-screen, pretty nifty [ http://oemgc.files.wordpress.com/2012/10/integrating-bi-publisher-with-enterprise-manager.pdf ] (credit: Rob Zoeteweij)

    Edited by: lrp1 on Jan 25, 2013 11:31 AM
  • 4. Re: Additional Storage/Memory requirements for adding BI Publisher?
    Courtney Llamas Journeyer
    Currently Being Moderated
    Yes, i logged a doc bug yesterday on the 11.1.1.5 reference in the 12.1.0.2 guide.

    12.1.0.2 => 11.1.1.6
    12.1.0.1 => 11.1.1.5
  • 5. Re: Additional Storage/Memory requirements for adding BI Publisher?
    AdeeshFulay Explorer
    Currently Being Moderated
    In addition to the excellent document from Rob Z, you can also refer to our detailed demo series on BI publisher.
    http://apex.oracle.com/pls/apex/f?p=44785:24:0::::P24_CONTENT_ID:6004

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points