This post takes a step back from all the BI concepts and describes just how to get your own Oracle BI demo up and running.
When you’re new to Oracle and / or the Business Intelligence suite the sheer number of options and variety of tools might prove a bit daunting. This article tries to shed some light on which tools to download from technet.oracle.com and install them in the right order. I know these guides have a limited time in which they are useful and never entirely complete but it will help so set up the most important parts of the BI system.
Because Oracle supplies so many different tools I’ll just stick on a basic system using Oracle Warehouse Builder and Discoverer.
To start, download the following installation files (for windows):
- Oracle Application Server 10g release 2 (3 files)
- Oracle Warehouse Builder 10g release 1 (1 file)
- Oracle Database 10g Release 2 (1 file)
- Oracle Database 10g Client Release 2 (1 file)
- Business Intelligence Tools CD (1 file). This one is hidden in de Application Server download page, look for ‘ business intelligence ‘.
This download contains the Discoverer Desktop and Administrator which you’ll need to create EUL’s
- Alternatively you can also download the AS companion CD for extra data.
So when everything is downloaded proceed in the following order:
1. Install the Oracle Database and create your own database
2. Install the Oracle Database client tools
3. Install the Application Server in two runs (in this order):
a. The first install will be the infrastructure into a new AS database
b. The application server main installation
If installing on your laptop make sure you’re not connected to the network! Write down all your settings or make screenshots.
4. Install OWB
5. Install the BI Tools
The next things to do are to reshuffle your Oracle homes from the Universal Installer and set all the TNS settings right. When you can connect to all your schema’s from the Oracle client or any SQL Client you’re set to create runtime, metadata and target schema’s from the OWB installation programs (runtime assistant). Remember to create the target schema’s from there as well since OWB creates some tables for auditing and logging purposes.
All in all a very quick run through the installation but I hope it gives some sense of direction through all the different options.
March 23rd, 2006 at 12:46:30
When I tried to install Appllication Server on my laptop it told me that it won’t work on Windows XP. Then it just got really, really confusing. Can you point to a decent and comprehensive installation guide for Apps Server specifically for Discoverer?
March 28th, 2006 at 09:59:37
It will say that the product is not certified on XP (Professional) but I haven’t experienced any errors. One thing to make notice of is to set your browser security settings correct for application server gauges. I dont know any specific installation guides but ‘Oracle 10g Data Warehousing’ (ISBN 1555583229) gives a nice overview.
February 7th, 2008 at 18:00:30
I’m a Oracle 8 OCP and now I’m again involved in Oracle Database side, the problem is that I don’t understand the what components do we need to install for Oracle Application Server 10G Release2 after Oracle 10G Release2 database creation.
Many examples are online but all are different.
I’m beginner in APPS side, so please some one help me out.
With many thanks in advance.
Regards
Salman