Troubleshooting OBIEE 11g

A couple tips on how to resolve some OBIEE 11g errors. When you receive an error such as …

“Supplementary information regarding operation: PROCESS:instance1:coreapplication_obisch1;FAILED_TO_START;
Operation Failed: start; OracleInstance: instance1; Component: coreapplication_obisch1; msg: 0 of 1 processes

or this …

“Error 500–Internal Server Error
From RFC 2068 Hypertext Transfer Protocol — HTTP/1.1:
10.5.1 500 Internal Server Error
The server encountered an unexpected condition which prevented it from fulfilling the request.”

1. First check to make sure your database instance and Listener are up and running.
You can do this through Enterprise Manager by connecting to the server/port.

If they are not running, then start them.
On Windows, you may need to make sure that the following Services are running:
. OracleServiceORCL
. OracleOraDb11g_home1ClrAgent
. OracleOraDb11g_home1TNSListener

2. Then check the status of other OBIEE components.
You can do this through the OBIEE Enterprise Manager.
http://hostname:7001/em/ then navigating to Business Intelligence -> coreapplication -> Availability tab.

or by running the opmnctl command as below
[Drive]\[FMW_HOME_DIR]\instances\instance1\bin>opmnctl status
for example C:\obiee11g\instances\instance1\bin> opmnctl status

In the example below, the BI Scheduler (coreapplication_obisch1) and the BI Presentation Server (coreapplication_obips1) are down.

Processes in Instance: instance1
ias-component | process-type | pid | status
coreapplication_obiccs1 | OracleBIClusterCo~ | 10136 | Alive
coreapplication_obisch1 | OracleBIScheduler~ | N/A | Down
coreapplication_obijh1 | OracleBIJavaHostC~ | 8396 | Alive
coreapplication_obips1 | OracleBIPresentat~ | N/A | Down
coreapplication_obis1 | OracleBIServerCom~ | 6736 | Alive

You can start the individual components using Enterprise Manager interface, or you may Stop BI Services and then Start BI Services from the Windows Start button
(Start -> All Programs -> Oracle Business Intelligence -> Stop/Start BI Services).


One Response to Troubleshooting OBIEE 11g

  1. Dennis Hancy says:

    One of my coworkers is unable to click on the various dashboard page tabs in OBIEE. When clicking on one of the tabs, there is no response. It does not allow him to navigate to a new page. Any idea why this is happening? Is there a browser setting that is causing this behavior?

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: