Monday, July 27, 2009

Installation and Configuration of OBIEE 10.1.3.4.1

The Blog is about installation and Configuration of OBIEE 10.1.3.4 (Basic Installation)

You can obtain OBIEE here

The Prerequisites:
1. JDK1.5.0 or above Download JDK

A Server with temporary tablespace of around 200 MB

Considerations:
The Document follows the installation procedure on RHEL 4 update 5

1. Unzip the biee_linux_x86_redhat_101341.zip
2. It will deploy
about.jsp
biee_linux_x86_redhat_101341_1of1.tar
META-INF
WEN-INF

3. untar the biee_linux_x86_101341_1of1.tar using
$tar -xvf biee_linux_x86_101341_1of1.tar

4. It will create RH_LINUX
Run: Server/Oracle_Business_Intelligence/setup.sh

You follow the screens, and specify the necessary informations

5. Follow the install log located in
$ORACLE_BI_HOME/log/install.log

Once completed you will be given an output stating to browse the html page in the location of Oracle BI HOME

Start working using
http://hostname:port (port will be 9704)/xmlpserver

Issue:
The login page failed to login using Administrator/Administrator
1. Shutdown the oc4j using
$(ORACLE_BI_HOME)/setup/oc4j

oc4j will give the options like
-start
-shutdown -port (ORMI Port) -password (Password which you gave during the installation) for oc4jadmin

ORMI Port:
Locate rmi.xml in the
$ORACLE_BI_HOME/oc4j_bi/j2ee/home/config/rmi.xml
Inside you can get the port of the ORMI Port. In my case it is 23971

I stopped oc4j like
ORACLE_BI_HOME/setup/oc4j -shutdown -port 23971 -password Welcome1
Shutdown OC4J instance...

The locate the xmlp-server-config.xml inside
$ORACLE_BI_HOME/ xmlp/ XMLP/ Admin/ Configuration /xmlp-server-config.xml

Change the variable
property name=”SECURITY_MODEL” value=”BI_SERVER“/
TO
property name=”SECURITY_MODEL” value=”XDO“/

3. Restart the oc4j from
$ORACLE_BI_HOME/setup/oc4j -start

Now the Administrator/Administrator will work

You can now navigate to Admin page from welcome page.

Issues:

When you access the Dashboard from the OBIEE Page, you may encounter

500 Internal Error: - Server error: An exception occured. The current application deployment descriptors do not allow for including it in this response. Please consult the application log for details.

I resolved the issue like this:

1. Edit ./oc4j_bi/j2ee/home/applications/analytics/analytics/WEB-INF/web.xml

Replace the port as 9703 instead of 9710

2. Go to $ORACLE_BI_HOME/setup/

$run-sa.sh stop

wait for 10 seconds

$run-saw.sh stop

wait for 10 seconds

$run-sa.sh start

$run-saw.sh start.

Now click on the application Dashboard. It will work fine.

1 comment:

  1. Great Post balaji
    Thanks
    I Have Installed as per your blog and everything went fine.
    Can you aslo direct me how we can integrate this with Oracle EBS.

    Thanks Again
    Rupesh Raghavan

    ReplyDelete