Intermittent Environment Issues,OBIEE Server Inaccessible In OBIEE 11g (Doc ID 1491358.1)

Last updated on MARCH 01, 2019

Applies to:

Symptoms

You are finding that you are getting 20-25 nqsserver log files generated per day. You believe that the BI Server is restarting periodically which occurs at the same time that the log file is generated. At this time the users are not able to login however if they wait 10-15 minutes they then can login fine.

Clarifying two issues, which are likely related:

1.  Automatic restarts of NQserver

This application has requested the runtime to terminate it in an unusual way.
Please contact the application's support team for more information.
ORA-24550: signal received: Unhandled exception: Code=c0000005 Flags=0

2. Services are up, but login doesn't happen

[2012-06-19T12:48:14.000+00:00] [OracleBIClusterControllerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: 178] Cluster Controller initialized
[2012-06-19T12:48:14.000+00:00] [OracleBIClusterControllerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: 183c] [71070] A connection with Oracle BI Scheduler [servername]:9705 (monitor port 9708) was established.
[2012-06-19T12:48:16.000+00:00] [OracleBIClusterControllerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: 7c4] [71021] An attempt to establish a connection with Oracle BI Server [servername]:9703 (monitor port 9701) failed.
[2012-06-19T12:48:19.000+00:00] [OracleBIClusterControllerComponent] [ERROR:1] [] [] [ecid: ] [tid: 183c] [71069] The connection with Oracle BI Scheduler [servername]:9705 (monitor port 9708) was lost.
[2012-06-19T12:48:19.000+00:00] [OracleBIClusterControllerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: 183c] [71068] Oracle BI Scheduler [servername]:9705 has transitioned to offline state.
[2012-06-19T12:48:24.000+00:00] [OracleBIClusterControllerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: 183c] [71070] A connection with Oracle BI Scheduler [servername]:9705 (monitor port 9708) was established.
[2012-06-19T13:02:31.000+00:00] [OracleBIClusterControllerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: 810] [71026] Cluster Controller exiting.
[2012-06-19T13:02:31.000+00:00] [OracleBIClusterControllerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: 810] [71026] Cluster Controller exiting.

In summary, the BI Server is crashing intermittently, however, the services are re-starting automatically and it is not obvious there is a NQServer crash occurring.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.