We had a SDL Tridion 2011 SP1 HR2 setup running with Oracle 11g R2 (188.8.131.52). We followed the below upgrade path:
- Updated the DB Server to patchset 184.108.40.206 as required by SDL Tridion 2013 SP1
- Upgraded all Tridion DBs to 2013 SP1 using the PowerShell scripts
- Installed Oracle 12c (220.127.116.11 x64) client on the CMS box
- Upgraded the CMS sotware using the installer
After the upgrade we were getting some Oracle version mismatch errors (see below).
Could not load file or assembly 'Oracle.DataAccess, Version=18.104.22.168, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified.
So we also installed the 32 bit client of Oracle 12c on the CMS box. Now we are getting the following errors in the Event Logs on the CMS
The type initializer for 'Oracle.DataAccess.Client.OracleConnectionStringBuilder' threw an exception. The provider is not compatible with the version of Oracle client
We have also installed 64 bit an 32 bit versions of ODAC 22.214.171.124 on the CMS. Please advice on how to proceed.