Oracle BISE1 - Install

Best way to start with OBI is to use Standard Edition One (BISE1), which can be downloaded from here http://www.oracle.com/technology/software/products/ias/htdocs/101321biseone.html, because it comes with a already created database and also with an tutorial which you can use to follow simple tasks and get to know a little bit the product. The only thing for the installation that I can say is that, if you try installing it on a Windows Vista, you'll encounter some problems because OBI does not support windows versions 6.0.


To solve that the simplest way is to add to the configurations files the version 6.0 to the other ones 5.0, 5.1, 5.2.
In the folder where you opened the archive you just search, in files contents, 5.1 or 5.2. There will be 4 files were you'll have to modify and add Vista details.
You should just add 6.0 to the [Certified Versions] and just duplicate the 5.1 (which represents XP) with copy and paste and replace with 6.0, but leave the SERVICE_PACK, SWAP_SPACE and TEMP_SPACE. During the installation pay attention to the DataBase password that you are asked to fill, it will become handy later. If you need guidance on installing the product you can find all help needed here http://download.oracle.com/docs/cd/E10352_01/doc/nav/portal_1.htm.
During the installation best way to manage the passwords for users is to set only one for all of them.


This are the most important accounts that you'll need to remember:

• Administrator - default password "Administrator" in order to access Presentation Services (http://localhost:9704/analytics), Publisher (http://localhost:9704/xmlpserver).
• BIPUBSCHED - password established at the install by yourself. Owner of the database schema that contains the objects to Oracle BI Publisher Scheduler.
• BISE1_SALES - Owner of the database schema with the tables that stores the data which represents the source of the example warehouses.
  
• BISE1_SALESWH - Owner of the database schema schema that contains the pre-built data mart objects.
• BISE1_TUTORIALWH - Owner of the schema that is used as the data mart target schema for Oracle Warehouse Builder. Once this schema is populated with the data mart objects, it is used by Oracle BI as the data source for the repository definition, as detailed in the tutorial.
• oc4jadmin - The Oracle Containers for Java (OC4J) administration account. It is used to access Application Server Control (e.g. http://localhost:9704/em) to stop, start, manage, and monitor Oracle BI Presentation Services and Oracle BI Publisher.
• SYS - This is the database 'super user' account. It has access to all database objects and can perform any task in the database.
• SYSTEM - This is the database administrator account. It is typically used for day-to-day database maintenance and operational tasks.

By accessing "All Programs/Oracle Business Intelligence Standard Edition One/Welcome to Oracle BISE1" it will open a web page where you'll find links to the tutorial, Interactive Dashboards and Oracle BI Publisher.
The install will create to your "All Programs" menu 4 entries "Oracle - BISE_1 DataBase", "Oracle - BISE_1 Warehouse Builder", "Oracle Business Intelligence" and "Oracle Business Intelligence Standard Edition One".
Other documentation regarding the installed products: Oracle Warehouse Builder you'll find in here http://www.oracle.com/technology/documentation/warehouse.html and http://www.filibeto.org/sun/lib/nonsun/oracle/11.1.0.6.0/B28359_01/owb.111/b31278/concept_overview.htm, but for the moment, when you are just trying to get to know a little the product (OBISE1) you don't need to work with OWB.
So, everything that you'll need to start working on OBI, you have it on your computer now.
Do not forget to start the OC4J before trying to connect to Presentation Services.
Have fun with it!