When upgrading to Oracle 18.104.22.168 on BSI 8.25 you will have to replace a database access dll with a newer version from oracle client 22.214.171.124 into BSI Bin.
Upgrading to Oracle 126.96.36.199 Dashboard Error
Purpose: This Document was created to fix a known error you will encounter when upgrading to Oracle 188.8.131.52 on BSI 8.25.
The error occurs when trying to start the Dashboard service of BSI.
<info>The type initializer for
'Oracle.DataAccess.Client.OracleConnectionStringBuilder' threw an exception.;Inner exception: Oracle.DataAccess.Client.OracleException The provider is not compatible with the version of Oracle client at Oracle.DataAccess.Client.OracleInit.Initialize() at Oracle.DataAccess.Client.OracleConnectionStringBuilder..cctor()</info>
The file that is causing the problem is the OraOps11w.dll file.
The reason is that we use ODAC 11 files and it's very sensitive to the versions of DLLs in BSI and in Oracle. If they are not the same, this issue could happen.
The OraOps11w.dll file exists in our bin folder and directly under dbhome_1 for Oracle. If wereplace the one in our folder with the one from Oracle then this will fix the above error.