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.