5 Replies Latest reply on Jan 25, 2013 8:31 PM by Adeesh Fulay

    Additional Storage/Memory requirements for adding BI Publisher?

      Hello, all. I'm running an OEM (about to try applying the recently released 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 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-Oracle
          Check the adv config sizing guide... about 2gb extra memory is required.


          BI Publisher Configuration

          If you plan on integrating BI Publisher version 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?
            Adeesh Fulay
            Since you are on EM, you should be using BIP and not 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;
            1 person found this helpful
            • 3. Re: Additional Storage/Memory requirements for adding BI Publisher?
              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 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 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-Oracle
                Yes, i logged a doc bug yesterday on the reference in the guide.

                1 person found this helpful
                • 5. Re: Additional Storage/Memory requirements for adding BI Publisher?
                  Adeesh Fulay
                  In addition to the excellent document from Rob Z, you can also refer to our detailed demo series on BI publisher.
                  1 person found this helpful