Installing Oracle BI Apps 7.9.6.3

The following is a short description of what steps have to be taken to install Oracle BI Applications (OBIA) version 7.9.6.3. This version of OBIA is the first version which runs on the new Oracle BI 11g 11.1.1.5.0 platform

This document assumes, that Oracle BI 11g has been installed already. Make sure the Weblogic Administration Server is running before the installation starts.

  • Unpack the installation software
  • Navigate to the folder; ‘Oracle_BI_Applications’
  • Start Setup.exe
  • A wizard will start

  • Click Next
  • Enter the installation directories — {MIDDLEWARE_HOME}
    • There are three important locations;
      • Oracle BI Home Locatie  –> {MIDDLEWARE_HOME}\Oracle_BI1
      • Oracle Instance Locatie  –> {MIDDLEWARE_HOME}\instances\instance1
      • Oracle Domain Location –> {MIDDLEWARE_HOME}\user_projects\domains\bifoundation_domain

  • Click Next
  • Enter the Weblogic Administrator Details

  • Click Next
  • In the background, some examinations are performed. This could take a while
  • Select the applications (default = everything), which should be installed

  • Click Next
  • A summary appears with the e=information about what will be installed

  • Click Next
  • Wait for the installer to finish
  • Click Finish

After the installation has finished, one can check what has been installed. In the ‘Oracle BI Home’ there has been an additional folder (biapps) added.

You will find the new Repository RPD-file in; {MIDDLEWARE_HOME}\Oracle_BI1\biapps\repository

The Repository can be opened offline. The Repository password (Admin123) is the default.

De new Catalog resides in the; {MIDDLEWARE_HOME}\Oracle_BI1\biapps\catalog-folder.

More to come.

Deinstall Oracle BI 11g

Sometimes you might run into the situation that you have to deinstal, Oracle BI 11g. If you read the manual, you will be presented with a sequence of events. Deinstalling an Oracle Business Intelligence installation on a single Windows computer involves the following tasks:

–> Run the deinstall script and select the Deinstall instances managed by a WebLogic domain option.

Make sure the weblogicserver is running.

Open a command prompt,

Cd <MIDDLEWARE_HOME>\Oracle_BI1\oui\bin

Run setup.exe -deinstall

option: Deinstall ASInstances managed by WebLogic Domain

–> Stop all Oracle Business Intelligence processes and servers, including all OPMN-controlled components and JEE components.

–> Drop the Metadata Services (MDS) and Business Intelligence Platform (BIPLATFORM) schemas using RCU.

Cd <RCU_HOME>\bin

Run rcu.bat

–> Run the deinstall script and select the Deinstall the Oracle home option.

Cd <MIDDLEWARE_HOME>\Oracle_BI1\oui\bin

Run setup.exe -deinstall

option: Deinstall Oracle home

–> Deinstall the Oracle Common home manually or by running the deinstall script that it contains.

oracle_common\oui\bin\

Run setup.exe -deinstall -jreLoc full_path_of_jre_or_jdk

–> Use the Oracle WebLogic Server uninstaller to uninstall WebLogic Server.

Cd <MIDDLEWARE_HOME>\utils\uninstall

uninstall -mode=console

–> Remove the Oracle home (if necessary).

Cd <MIDDLEWARE_HOME>/user_projects/domains

delete folder; bifoundation_domain

–> Remove the Middleware home and any other homes (Domain home, Applications home, and Instance home) that might have been installed outside of the Middleware home.

navigate to <MIDDLEWARE_HOME>- parent_dirictory

delete folder; <MIDDLEWARE_HOME>

Now you are good to go and try again.

Good Luck!

Installing Oracle BI 11g R1

Today I started with the installation of the new Oracle BI 11g R1 release. This time I did something a man normally doesn’t do. I started by RTFM. The documentation could be found here. Lucky for me, John did a four part series about installing the Oracle BI Oracle BI 11g R1 release on a on a windows 32 bit XP-pro box. 

I only want to add some additional info about some issues I had while installing. 

The first error or warning I received was about the character set of my 11g database.

 

For some more details about the 11g database character set, please check OTN.

You can change the character set by issuing the following commands; 

To check the character set

SELECT *
  FROM nls_database_parameters;

To change the character set

alter system enable restricted session;
alter system set job_queue_processes=0;
alter database open;
ALTER DATABASE CHARACTER SET INTERNAL_USE UTF8;
ALTER DATABASE CHARACTER SET INTERNAL_USE AL32UTF8;
Shutdown immediate;
startup mount;

Next I received a few ‘RCU-6107: DB Init Param’ errors.

Thanks to Muhammad Habib, I was able to solve these issues.

Let’s see what  Oracle BI 11g R1 has to offer us.