Background
Using anOracle 12c 64-bit client
from Oracle client software (ODAC) version 12.1.0.1 64-bit from Oracle website. Situation
I have just performed a data restoration from a higher to one of my lower environments within DTAP. Everything restored properly - after eyeball test within the TCM - and I have reset my publication targets in the CME specific to the new refreshed environment. However, when I begin to republish all or one piece of content I get this error:Unable to publish item(s) with id
Error: Could not load file or assembly 'Oracle.DataAccess, Version=4.112.3.0, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified.
I've looked online at some reasons why this is happening, but none seem to be specific to my scenario as when I compare environments. I am not missing/blocked files or .dlls
and haven't found this to be tridion specific, yet..
When I view Setting up Oracle client software I see:
Open a command prompt and access the bin\ subdirectory of the Oracle home directory or home directories and execute the following command:
tnsping.exe myoracleserver
- does not exist; but does not exist in any other environments either - tnspingCheck the folder
c:\Windows\assembly
for the presence of a number of new assemblies calledOracle.DataAccess
orPolicy.2.111.Oracle.DataAccess
(the number may differ) - these do not exist; but they do not exist in any other environments either
Has anyone ran into this kind of error before with Tridion? It only happens when I begin to publish.
Event Viewer:
Unable to Initialize TDSE object.
Could not load file or assembly 'Oracle.DataAccess, Version=4.112.3.0, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified.
Error Code:
0x80040000 (-2147221504)
Call stack:
Tridion.ContentManager.Data.AdoNet.Oracle.OracleDatabaseUtilities.GetConnection()
Tridion.ContentManager.Data.AdoNet.Oracle.OracleDatabaseUtilities..ctor()
Tridion.ContentManager.Data.AdoNet.Oracle.OracleDataSession..ctor()
System.RuntimeTypeHandle.CreateInstance(RuntimeType,Boolean,Boolean,Boolean&,RuntimeMethodHandleInternal&,Boolean&)
System.RuntimeType.CreateInstanceSlow(Boolean,Boolean,Boolean,StackCrawlMark&)
System.RuntimeType.CreateInstanceDefaultCtor(Boolean,Boolean,Boolean,StackCrawlMark&)
System.Activator.CreateInstance(Type,Boolean)
System.Activator.CreateInstance(Type)
Tridion.ContentManager.Data.DataSessionFactory.CreateDataSession()
Tridion.ContentManager.Data.DataSessionFactory.CreateDataSession(UserData)
Tridion.ContentManager.Session.GetDataSession()
Tridion.ContentManager.Security.AuthorizationManager.LoadAccessToken(String,IEnumerable`1,IEnumerable`1)
Tridion.ContentManager.Security.AuthorizationManager.LoadAccessToken(String,String)
Tridion.ContentManager.Session..ctor(String,String)
Tridion.ContentManager.BLFacade.SystemFacade.InitializeUserContext(UserContext,String,String)
UtilitiesTDS.GetUserContext
TDSE.Initialize
Component: mscorlib
Errorcode: 0
User: XXX\MTSUSER