Upgrading to Oracle 11.2.0.4 Dashboard Error

Document ID : KB000048031
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

When upgrading to Oracle 11.2.0.4 on BSI 8.25 you will have to replace a database access dll with a newer version from oracle client 11.2.0.4 into BSI Bin.

Solution:

Upgrading to Oracle 11.2.0.4 Dashboard Error

Purpose: This Document was created to fix a known error you will encounter when upgrading to Oracle 11.2.0.4 on BSI 8.25.

The error occurs when trying to start the Dashboard service of BSI.

Error:

Info:

- <errors>
- <error>
<coding_context />
<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>
</error>
</errors>

Solution:

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.