Hello, all. I'm running an OEM 188.8.131.52.0 (about to try applying the recently released 184.108.40.206.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 220.127.116.11 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.
Check the adv config sizing guide... about 2gb extra memory is required.
BI Publisher Configuration
If you plan on integrating BI Publisher version 18.104.22.168 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.
Since you are on EM 22.214.171.124, you should be using BIP 126.96.36.199 and not 188.8.131.52. 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;
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 184.108.40.206 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 220.127.116.11 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