My Oracle Support Banner

Upgrade Repository Database To 18c For OBIEE 12.2.1.2 (obips1,obisch1,obis1 Failed To Start) (Doc ID 2508444.1)

Last updated on AUGUST 14, 2019

Applies to:

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

Symptoms

Upgraded Repository Database for OBIEE 12.2.1.2 to Oracle Database 18.5.
Upgrade want well with no issue, but when  try to start OBIEE, 3 components failed to start.

Name Type Machine Status
---- ---- ------- ------
AdminServer Server myserver.com  RUNNING
bi_server1 Server  myserver  RUNNING
obips1 OBIPS      myserver SHUTDOWN
obijh1 OBIJH       myserver RUNNING
obiccs1 OBICCS   myserver RUNNING
obisch1 OBISCH   myserver SHUTDOWN
obis1 OBIS          myserver SHUTDOWN

Seeing the following errors in the logs:

[TIME_STAMP] [OBIS] [ERROR:1] [] [] [ecid: ] [sik: ssi] [tid: 1a2b2740] Oracle BI Server startup failed.[46137] CSF error encountered. Error code: 43131. [[
file: server/NQSNative/Driver/Src/NQDDriverImpl.cpp; line: 488
]]
[TIME_STAMP] [OBIS] [NOTIFICATION:1] [] [] [ecid: ] [sik: ssi] [tid: 1a2b2740] nqsserver: Oracle BI Server shutdown. [[
file: server/NQSNative/Driver/Src/NQDDriverImpl.cpp; line: 66
]]
errCode:28040 errSQLStateBuf:HY000 errMsg:[Oracle DataDirect][ODBC Oracle Wire Protocol driver][Oracle]ORA-28040: No matching authentication protocol
errCode:0 errSQLStateBuf:08003 errMsg:[DataDirect][ODBC lib] Connection not open
Oracle BI Server startup failed.
nqsserver: Oracle BI Server shutdown.

 
Planning migration OBIEE to 12.2.1.4 after upgrading the repository database.

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
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.