So , Nowhere in OBIEE 12c Installation said that, you need to have certain pre-requisite condition in the DB to ensure successful installation and you end up scratching head why you are getting all the nonsense in OBIEE installation logs when everything you did right !
Yes , unfortunately that life with Oracle tool ! (! Sigh ! ) and if you are the one person who hit this error you can try out the option below to fix.
While installing brand new OBIEE12c (not an upgrade) we have seen issue below and log : /home/orabi/oraInventory/logs/config<time>/startallservers.log
OPMN failed and BIServer , BIPServer and BIScheduler all was in SHUTTING DOWN state.
Below is the server status (./status.sh)
Name Type Machine Status
—- —- ——- ——
AdminServer Server dfatobi RUNNING
bi_server1 Server dfatobi RUNNING
obips1 OBIPS dfatobi SHUTDOWN
obijh1 OBIJH dfatobi RUNNING
obiccs1 OBICCS dfatobi RUNNING
obisch1 OBISCH dfatobi SHUTDOWN
obis1 OBIS dfatobi SHUTDOWN
And you see the errors below in bunch of log files :
[OBIS] [ERROR:1] [] [] [ecid: ] [sik: ssi] [tid: f1b51720] [46137] CSF error encountered. Error code: 43131. [[^M
file: server/Utility/Generic/Src/SUGCSF.cpp; line: 133
[OBIPS] [WARNING:16] [] [saw.csf.cache] [ecid: ] [tid: ] [SI-Name: ] [IDD-Name: ] [IDD-GUID: ] [userId: ] OFM security reported error 43131[[
File:csfwrapperimpl.cpp
Line:213
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 starting…
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.
This means you might end up with Hitting Oracle bug ? My DB server was Oracle 12c R2 12.2 . Lot of places in OTN, Oracle said you might try Oracle 12c R1 but I recommend try below step to see if this works for you .
Try disabling OAS (Oracle Advanced Security) . Ask Oracle DBA to change the DB with below in sqlnet.ora file and you are good to go …
SQLNET.ENCRYPTION_SERVER = rejected
If that doesn’t help you can try enabling OBIEE (creating a sqlnet.ora file under [DOMAIN_HOME]/config/fmwconfig/bienv/core/) for OAS decryption. However I tried this option and it doesn’t work as for new and scratch installation where do I get this before until installation is done… so previous step does the trick .
SQLNET.ENCRYPTION_CLIENT=accepted
SQLNET.ENCRYPTION_TYPES_CLIENT=(AES256)
The actual reason for the issue is : You are using an Oracle Database (for RCU or datasource) with Oracle Advanced Security (OAS) enabled and with SQL*Net Encryption.
I have install OBIEE 12c on Redhat Linux 7.0 using Oracle 12 C database. Three servers are failing to run or start and these are obips1, Obisch1, obis1. In the logs are receiving error [46137] CSF error encountered. Error code:43131.
How can I resolve this problem. I have checked user oracle accounts and are showing that they are ok. Please help. How can I resolve this problem?
Thank you
http://bit.ly/2H1CJfl