My Oracle Support Banner

OBIEE 12c : DB2 Database For RCU : Could Not Start OBIS1,OBIPS1and OBISCH1 Services After Installation (Doc ID 2539791.1)

Last updated on DECEMBER 16, 2019

Applies to:

Business Intelligence Suite Enterprise Edition - Version 12.2.1.4.0 and later
Information in this document applies to any platform.

Symptoms

On:Oracle Business Intelligence Enterprise Edition

Fresh installation of OBIEE 12C DB2 as Datasource

Fresh Installation of BI using DB2 Database for the RCU,

Installation Completed Successfully 

But after installation, unable to start obips1, obisch1and obis1 services.

Error messages in the log files :

 

SAW.log :

[TIMESTAMP] [OBIPS] [WARNING:16] [] [saw.csf.cache] [ecid: ] [tid: ] [SI-Name: ] [IDD-Name: ] [IDD-GUID: ] [userId: ] OFM security reported error 43131

[OBIPS] [ERROR:10] [] [saw.webextensionbase.shutdown] [ecid: ] [tid: ] [SI-Name: ] [IDD-Name: ] [IDD-GUID: ] [userId: ] Assertion failure: false at line 18 of handle.cpp
Message: PN3saw18NQSchedulerManagerE[[

OBIS1-diagnostic.log :

[TIMESTAMP] [OBIS] [NOTIFICATION:1] [] [] [ecid: ] [sik: ssi] [tid: ]  [] Unloaded all subject areas. [[
Properties: EnvShutdownCall=RpMgr::ShutDown(); EnvShutdownCallFileLine=server/NQSNative/NQSServEntry/Source/NQSQueryEnvironment.cpp:1750; 
]]
[TIMESTAMP] [OBIS] [ERROR:1] [] [] [ecid: ] [sik: ssi] [tid: ] Oracle BI Server startup failed.[46137] CSF error encountered. Error code: 43131. [[
file: server/NQSNative/Driver/Src/NQDDriverImpl.cpp; line: 436
]]
[TIMESTAMP] [OBIS] [NOTIFICATION:1] [] [] [ecid: ] [sik: ssi] [tid: ] nqsserver: Oracle BI Server shutdown. [[
file: server/NQSNative/Driver/Src/NQDDriverImpl.cpp; line: 66 

OBIPS1.out

<TIMESTAMP> <INFO> <NodeManager ComponentManager> <ORACLE_OBICCS_HOSTS=<HOSTNAME>:<PORT>>
Copyright (c) 1997-2018 Oracle Corporation, All rights reserved
Version 12.2.1.4.0
errCode:-551 errSQLStateBuf:HY000 errMsg:[Oracle DataDirect][ODBC DB2 Wire Protocol driver][DB2]D2_OPSS DOES NOT HAVE PRIVILEGE TO PERFORM OPERATION BIND ON THIS OBJECT NULLID.DDOS510A.
errCode:0 errSQLStateBuf:08003 errMsg:[DataDirect][ODBC lib] Connection not open
errCode:-551 errSQLStateBuf:HY000 errMsg:[Oracle DataDirect][ODBC DB2 Wire Protocol driver][DB2]D2_OPSS DOES NOT HAVE PRIVILEGE TO PERFORM OPERATION BIND ON THIS OBJECT NULLID.DDOS510A.
errCode:0 errSQLStateBuf:08003 errMsg:[DataDirect][ODBC lib] Connection not open
No additional details<TIMESTAMP> <INFO> <NodeManager ComponentManager> <The server 'obips1' with process id <PID> is no longer alive; waiting for the process to die.>
<TIMESTAMP> <FINEST> <NodeManager ComponentManager> <Process died.>

OBISC1.out 

TIMESTAMP> <INFO> <NodeManager ComponentManager> <UTILS_MEM_ARGS=-Xms32m -Xmx1024m>
<TIMESTAMP> <INFO> <NodeManager ComponentManager> <ORACLE_OBICCS_HOSTS=<HOSTNAME>:<PORT>>
Copyright (c) 1997-2018 Oracle Corporation, All rights reserved
Version 12.2.1.4.0
errCode:-551 errSQLStateBuf:HY000 errMsg:[Oracle DataDirect][ODBC DB2 Wire Protocol driver][DB2]D2_OPSS DOES NOT HAVE PRIVILEGE TO PERFORM OPERATION BIND ON THIS OBJECT NULLID.DDOS510A.
errCode:0 errSQLStateBuf:08003 errMsg:[DataDirect][ODBC lib] Connection not open
<TIMESTAMP> <INFO> <NodeManager ComponentManager> <The server 'obisch1' with process id <PID> is no longer alive; waiting for the process to die.>
<TIMESTAMP> <FINEST> <NodeManager ComponentManager> <Process died.>

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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