Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

opmn biserver service not starting

Question
3
Views
0
Comments
Maxwell Mumba
Maxwell Mumba Rank 3 - Community Apprentice

Hi Community,

I have an enterprise Oracle Bi running on Exalytics Linux environment. I have applied the July bundle patch  2994430 and upon starting the opmn components its failed with the below errors:

1. Nqserver log:

]]

[2019-10-25T14:39:41.533+02:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: 4b657720] nqsserver: Oracle BI Server shutdown. [[

file: server/NQSNative/Driver/Src/NQDDriverImpl.cpp; line: 62

]]

[2019-10-25T14:39:45.507+02:00] [OracleBIServerComponent] [WARNING:1] [] [] [ecid: ] [tid: 18bae720] Warning: Clustering and cache are enabled for this OBIS node, but cluster aware cache is disabled.  This can lead to inconsistencies.

[2019-10-25T14:39:45.521+02:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 18bae720]  [nQSError: 72013] A WinSock call returned error (98) Address already in use [[

[nQSError: 71046] Cluster Controller startup error. Unable to establish listener on port specified in RPC port or monitor port field in cluster configuration file.

]]

[2019-10-25T14:39:45.521+02:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 18bae720]  [nQSError: 43061] Server startup error. Cluster monitor could not be setup. [[

file: server/NQSNative/Driver/Src/NQDDriverImpl.cpp; line: 471

]]

[2019-10-25T14:39:45.521+02:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: 18bae720] nqsserver: Oracle BI Server shutdown. [[

file: server/NQSNative/Driver/Src/NQDDriverImpl.cpp; line: 62

2. OPMN Status:

[oracle@exalytics-bi01 bin]$ ./opmnctl status

Processes in Instance: instance1

---------------------------------+--------------------+---------+---------

ias-component                    | process-type       |     pid | status

---------------------------------+--------------------+---------+---------

coreapplication_obips2           | OracleBIPresentat~ |  105375 | Alive

coreapplication_obijh2           | OracleBIJavaHostC~ |  101205 | Alive

coreapplication_obis2            | OracleBIServerCom~ |     N/A | Down

coreapplication_obiccs1          | OracleBIClusterCo~ |     N/A | Down

coreapplication_obisch1          | OracleBIScheduler~ |  114943 | Init

coreapplication_obijh1           | OracleBIJavaHostC~ |  101198 | Alive

coreapplication_obips1           | OracleBIPresentat~ |  101199 | Alive

coreapplication_obis1            | OracleBIServerCom~ |     N/A | Down

3. OPMN LOG:

[2019-10-25T14:56:14+02:00] [opmn] [NOTIFICATION:1] [662] [pm-process] Starting Process: coreapplication_obijh2~OracleBIJavaHostComponent~coreapplication_obijh2~1 (1894434818:0)

[2019-10-25T14:56:14+02:00] [opmn] [NOTIFICATION:1] [662] [pm-process] Starting Process: coreapplication_obips2~OracleBIPresentationServicesComponent~coreapplication_obips2~1 (1894434819:0)

[2019-10-25T14:56:15+02:00] [opmn] [NOTIFICATION:1] [665] [pm-process] Process Alive: coreapplication_obisch1~OracleBISchedulerComponent~coreapplication_obisch1~1 (1894434815:116773)

[2019-10-25T14:56:15+02:00] [opmn] [TRACE:32] [] [pm-monitor] Proc 1894434815:116773 Start->Alive

[2019-10-25T14:56:15+02:00] [opmn] [NOTIFICATION:1] [665] [pm-process] Process Alive: coreapplication_obips1~OracleBIPresentationServicesComponent~coreapplication_obips1~1 (1894434813:116771)

[2019-10-25T14:56:15+02:00] [opmn] [TRACE:32] [] [pm-monitor] Proc 1894434813:116771 Start->Alive

[2019-10-25T14:56:15+02:00] [opmn] [NOTIFICATION:1] [665] [pm-process] Process Alive: coreapplication_obijh2~OracleBIJavaHostComponent~coreapplication_obijh2~1 (1894434818:116778)

[2019-10-25T14:56:15+02:00] [opmn] [TRACE:32] [] [pm-monitor] Proc 1894434818:116778 Start->Alive

[2019-10-25T14:56:15+02:00] [opmn] [NOTIFICATION:1] [665] [pm-process] Process Alive: coreapplication_obijh1~OracleBIJavaHostComponent~coreapplication_obijh1~1 (1894434814:116772)

[2019-10-25T14:56:15+02:00] [opmn] [TRACE:32] [] [pm-monitor] Proc 1894434814:116772 Start->Alive

[2019-10-25T14:56:15+02:00] [opmn] [NOTIFICATION:1] [665] [pm-process] Process Alive: coreapplication_obips2~OracleBIPresentationServicesComponent~coreapplication_obips2~1 (1894434819:116779)

[2019-10-25T14:56:15+02:00] [opmn] [TRACE:32] [] [pm-monitor] Proc 1894434819:116779 Start->Alive

[2019-10-25T14:56:17+02:00] [opmn] [TRACE:32] [] [pm-monitor] Proc 1894434812:116770 Start->Dead: wait for ready job

[2019-10-25T14:56:17+02:00] [opmn] [WARNING:1] [660] [pm-process] Process Crashed: coreapplication_obips1~OracleBIPresentationServicesComponent~coreapplication_obips1~1 (1894434813:116771) - Restarting

[2019-10-25T14:56:17+02:00] [opmn] [WARNING:1] [660] [pm-process] Process Crashed: coreapplication_obisch1~OracleBISchedulerComponent~coreapplication_obisch1~1 (1894434815:116773) - Restarting

[2019-10-25T14:56:17+02:00] [opmn] [TRACE:32] [] [pm-monitor] Proc 1894434817:116776 Start->Dead: wait for ready job

[2019-10-25T14:56:17+02:00] [opmn] [TRACE:32] [] [pm-monitor] Proc 1894434812:116770 Start->Dead: wait for ready job

[2019-10-25T14:56:17+02:00] [opmn] [TRACE:32] [] [pm-monitor] Proc 1894434817:116776 Start->Dead: wait for ready job

[2019-10-25T14:56:19+02:00] [opmn] [TRACE:32] [] [pm-monitor] Proc 1894434812:116770 Start->Dead: retry

[2019-10-25T14:56:19+02:00] [opmn] [TRACE:32] [] [pm-monitor] Proc 1894434817:116776 Start->Dead: retry

[2019-10-25T14:56:19+02:00] [opmn] [NOTIFICATION:1] [662] [pm-process] Starting Process: coreapplication_obis1~OracleBIServerComponent~coreapplication_obis1~1 (1894434812:0)

[2019-10-25T14:56:19+02:00] [opmn] [NOTIFICATION:1] [662] [pm-process] Starting Process: coreapplication_obis2~OracleBIServerComponent~coreapplication_obis2~1 (1894434817:0)

[2019-10-25T14:56:21+02:00] [opmn] [TRACE:32] [] [pm-monitor] Proc 1894434816:116775 Start->Dead: wait for ready job

[2019-10-25T14:56:23+02:00] [opmn] [TRACE:32] [] [pm-monitor] Proc 1894434812:117646 Start->Dead: wait for ready job

[2019-10-25T14:56:23+02:00] [opmn] [TRACE:32] [] [pm-monitor] Proc 1894434816:116775 Start->Dead: retry

[2019-10-25T14:56:23+02:00] [opmn] [TRACE:32] [] [pm-monitor] Proc 1894434817:117647 Start->Dead: wait for ready job

[2019-10-25T14:56:23+02:00] [opmn] [NOTIFICATION:1] [662] [pm-process] Starting Process: coreapplication_obiccs1~OracleBIClusterControllerComponent~BIClusterController~1 (1894434816:0)

[2019-10-25T14:56:23+02:00] [opmn] [TRACE:32] [] [pm-monitor] Proc 1894434812:117646 Start->Dead: wait for ready job

[2019-10-25T14:56:23+02:00] [opmn] [TRACE:32] [] [pm-monitor] Proc 1894434817:117647 Start->Dead: wait for ready job

[2019-10-25T14:56:25+02:00] [opmn] [TRACE:32] [] [pm-monitor] Proc 1894434812:117646 Start->Dead: retry

[2019-10-25T14:56:25+02:00] [opmn] [TRACE:32] [] [pm-monitor] Proc 1894434817:117647 Start->Dead: retry

[2019-10-25T14:56:25+02:00] [opmn] [NOTIFICATION:1] [662] [pm-process] Starting Process: coreapplication_obis1~OracleBIServerComponent~coreapplication_obis1~1 (1894434812:0)

[2019-10-25T14:56:25+02:00] [opmn] [NOTIFICATION:1] [662] [pm-process] Starting Process: coreapplication_obis2~OracleBIServerComponent~coreapplication_obis2~1 (1894434817:0)

[2019-10-25T14:56:27+02:00] [opmn] [TRACE:32] [] [pm-monitor] Proc 1894434812:117699 Start->Dead: maxretry (21)

I checked netstat ans lsof on port 9703 and the default opmn port 9500 local and 9501 report and they all in use.

Please assist if there anything am missing here??