472,143 Members | 1,605 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,143 software developers and data experts.

Oracle 9IR2 OLAP and BI Beans - How to get it working

Hi Guys!

Just would like to share with you my experiense in this matter.
I was trying to evaluate how suitable Oracle OLAP for our
As probably you did, I have downloaded from OTN website OraJDeveloper
and BI Beans, installed them and opened Cube Viewer ... no luck! Just
did not work.

After very long conversation(s) with Oracle Support I finally figured
out how to fix this thing. So - below the sequence of actions that
will bring you to really working BI Beans with BIBDEMOS schema.

One more comment - in the end I was really disappointed how Oracle
Presentation beans look like - poorly looking, S L O W W W W and huge
software, that I can reaplace with sequence of 5-7 web pages doing the
same work...

Anyway, here we go:
What I have done:

- Install fresh Win XP Prof SP1
- Install Ora 92010
- drop XMLCONCAT synonym and function
OLAP catalog is valid, version 9201
- shutdown DB with instance's win service, listener, Apache and agent
- everything
- Install OUI (from patchset 3095277)
- Install patch 92040 (3095277) WITH oui
- STARTUP DB and listener
- set shared pool and java pool to 180M each
- resize system tablespace to 800M
OLAP catalog is valid, version 9201
- shutdown and startup migrate, listener still up
- run catpatch.sql - no errors
- shutdown / startup normal
- utlrp.sql - no errors
- unlock and connect as OLAPSYS
- postamd.sql - no errors
- set ORACLE_HOME variable
- clearly shutdown, disconnect from sqlplus
3084634 one-off applied successfully
- startup
- clearly shutdown DB and service, listener is UP (Important!!!!!)
- run Installer, apply patch 92041 - success
Now in UOI inventory I have:
+Ora DB 92010
+Patch set 92040
+patchset 92041
- startup
OLAP Catalog VALID - 92041
- as sys: @olap\admin\olapu92041.sql - no errors
OLAP CAtalog valid
- Install Jdev (unarchive it to C:\JDEV9033\)
- Download BI Beans ( BI Beans will appear as Oracle9i
Business Intelligence Beans as the component to install on
the summary page during installation)
- Unzip BIBEANS file, run OUI 22018 (NOT 22014 shipped with BIBeans),
install BI Bean into NEW Oracle Home (where you have installed
JDeveloper - i.e. C:\JDEV9033\)
- install BIBDEMO schema
- Run Cube viewer - it works!

I would really appreciate some more comments from people who was
testing / using it. It looks like nobody use them at production for
mow - is that right?

Have a great day, Guys!
Jul 19 '05 #1
0 3227

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

125 posts views Thread by Rhino | last post: by
7 posts views Thread by BigDaDDY | last post: by
11 posts views Thread by lenygold via DBMonster.com | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.