Issues and Fixes with OBIEE

For Installation of the OBIEE please follow my previous post http://balajiabhi.blogspot.com/2009/07/installation-and-configuration-of-obiee.html


Issue:
The login page failed to login using Administrator/Administrator
Fix:
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 was 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 variableproperty 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.

Issue 2:
When you access the Dashboard from the OBIEE Page, you may encounter

500 Internal Error: - servlet error: An exception occurred. 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.

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.