Could Not Load Oracle Client Check Path/Registry
Posted: Mon 28 Sep 2015 17:07
Please provide explicit, step by step instructions on how to provide the correct path settings and registry settings. Have searched extensively throughout your documentation and found no such instructions.
It is a poor user experience to pay for software and have to check/update settings that could easily be programmed by the developers of this product.
These two lines are the first items in my path
C:\app\<user>\product\11.2.0\client_2;C:\app\<user>\product\11.2.0\client_2\bin;
I have switched these around and restarted with no luck (oci.dll in in /client_2 not in /client_2/bin).
Path related
tns_admin: path to tns admin\
ORACLE_HOME: C:\app\<user>\product\11.2.0\client_2
1. Provide all needed Registry settings
2. Provide all necessary PATH settings.
dot connect version: 8.2 Pro
client folder: C:\app\295501\product\11.2.0\client_2
client folder(64?): C:\Oracle\product\11.2.0\client_1
[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraClient11g_home2]
"ORACLE_HOME"="..\product\\11.2.0\\client_2"
"ORACLE_HOME_NAME"="OraClient11g_home2"
"ORACLE_GROUP_NAME"="Oracle - OraClient11g_home2"
"OLEDB"="..\11.2.0\\client_2\\oledb\\mesg"
"tns_admin"="...\11.2.0\\client_2\\Network\\Admin"
{"The underlying provider failed on Open."}
{"Can not load Oracle client. Check your PATH environment variable and registry settings."}
Stack Trace:
at System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean openCondition, DbConnection storeConnectionToOpen, DbConnection originalConnection, String exceptionCode, String attemptedOperation, Boolean& closeStoreConnectionOnFailure)
at System.Data.EntityClient.EntityConnection.Open()
at System.Data.Objects.ObjectContext.EnsureConnection()
at System.Data.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)
at System.Data.Objects.ObjectQuery`1.System.Collections.Generic.IEnumerable<T>.GetEnumerator()
at System.Linq.Enumerable.Single[TSource](IEnumerable`1 source)
at System.Data.Objects.ELinq.ObjectQueryProvider.<GetElementFunction>b__3[TResult](IEnumerable`1 sequence)
at System.Data.Objects.ELinq.ObjectQueryProvider.ExecuteSingle[TResult](IEnumerable`1 query, Expression queryRoot)
at System.Data.Objects.ELinq.ObjectQueryProvider.System.Linq.IQueryProvider.Execute[S](Expression expression)
at System.Data.Entity.Internal.Linq.DbQueryProvider.Execute[TResult](Expression expression)
at System.Linq.Queryable.Count[TSource](IQueryable`1 source)
inner stack trace:
at Devart.Data.Oracle.az..ctor(Boolean A_0, Boolean A_1, OracleHome A_2)
at Devart.Data.Oracle.az.a(Boolean A_0, Boolean A_1, OracleHome A_2, Boolean A_3, Boolean A_4)
at Devart.Data.Oracle.OracleInternalConnection..ctor(b8 connectionOptions, OracleInternalConnection proxyConnection)
at Devart.Data.Oracle.am.a(p A_0, Object A_1, DbConnectionBase A_2)
at Devart.Common.DbConnectionFactory.a(DbConnectionPool A_0, p A_1, DbConnectionBase A_2)
at Devart.Common.DbConnectionPoolGroup.a(DbConnectionPool A_0, DbConnectionBase A_1)
at Devart.Common.DbConnectionPool.a(DbConnectionBase A_0)
at Devart.Common.DbConnectionPool.GetObject(DbConnectionBase owningConnection)
at Devart.Common.DbConnectionFactory.b(DbConnectionBase A_0)
at Devart.Common.DbConnectionClosed.Open(DbConnectionBase outerConnection)
at Devart.Common.DbConnectionBase.Open()
at Devart.Data.Oracle.OracleConnection.Open()
at System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean openCondition, DbConnection storeConnectionToOpen, DbConnection originalConnection, String exceptionCode, String attemptedOperation, Boolean& closeStoreConnectionOnFailure)
It is a poor user experience to pay for software and have to check/update settings that could easily be programmed by the developers of this product.
These two lines are the first items in my path
C:\app\<user>\product\11.2.0\client_2;C:\app\<user>\product\11.2.0\client_2\bin;
I have switched these around and restarted with no luck (oci.dll in in /client_2 not in /client_2/bin).
Path related
tns_admin: path to tns admin\
ORACLE_HOME: C:\app\<user>\product\11.2.0\client_2
1. Provide all needed Registry settings
2. Provide all necessary PATH settings.
dot connect version: 8.2 Pro
client folder: C:\app\295501\product\11.2.0\client_2
client folder(64?): C:\Oracle\product\11.2.0\client_1
[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraClient11g_home2]
"ORACLE_HOME"="..\product\\11.2.0\\client_2"
"ORACLE_HOME_NAME"="OraClient11g_home2"
"ORACLE_GROUP_NAME"="Oracle - OraClient11g_home2"
"OLEDB"="..\11.2.0\\client_2\\oledb\\mesg"
"tns_admin"="...\11.2.0\\client_2\\Network\\Admin"
{"The underlying provider failed on Open."}
{"Can not load Oracle client. Check your PATH environment variable and registry settings."}
Stack Trace:
at System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean openCondition, DbConnection storeConnectionToOpen, DbConnection originalConnection, String exceptionCode, String attemptedOperation, Boolean& closeStoreConnectionOnFailure)
at System.Data.EntityClient.EntityConnection.Open()
at System.Data.Objects.ObjectContext.EnsureConnection()
at System.Data.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)
at System.Data.Objects.ObjectQuery`1.System.Collections.Generic.IEnumerable<T>.GetEnumerator()
at System.Linq.Enumerable.Single[TSource](IEnumerable`1 source)
at System.Data.Objects.ELinq.ObjectQueryProvider.<GetElementFunction>b__3[TResult](IEnumerable`1 sequence)
at System.Data.Objects.ELinq.ObjectQueryProvider.ExecuteSingle[TResult](IEnumerable`1 query, Expression queryRoot)
at System.Data.Objects.ELinq.ObjectQueryProvider.System.Linq.IQueryProvider.Execute[S](Expression expression)
at System.Data.Entity.Internal.Linq.DbQueryProvider.Execute[TResult](Expression expression)
at System.Linq.Queryable.Count[TSource](IQueryable`1 source)
inner stack trace:
at Devart.Data.Oracle.az..ctor(Boolean A_0, Boolean A_1, OracleHome A_2)
at Devart.Data.Oracle.az.a(Boolean A_0, Boolean A_1, OracleHome A_2, Boolean A_3, Boolean A_4)
at Devart.Data.Oracle.OracleInternalConnection..ctor(b8 connectionOptions, OracleInternalConnection proxyConnection)
at Devart.Data.Oracle.am.a(p A_0, Object A_1, DbConnectionBase A_2)
at Devart.Common.DbConnectionFactory.a(DbConnectionPool A_0, p A_1, DbConnectionBase A_2)
at Devart.Common.DbConnectionPoolGroup.a(DbConnectionPool A_0, DbConnectionBase A_1)
at Devart.Common.DbConnectionPool.a(DbConnectionBase A_0)
at Devart.Common.DbConnectionPool.GetObject(DbConnectionBase owningConnection)
at Devart.Common.DbConnectionFactory.b(DbConnectionBase A_0)
at Devart.Common.DbConnectionClosed.Open(DbConnectionBase outerConnection)
at Devart.Common.DbConnectionBase.Open()
at Devart.Data.Oracle.OracleConnection.Open()
at System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean openCondition, DbConnection storeConnectionToOpen, DbConnection originalConnection, String exceptionCode, String attemptedOperation, Boolean& closeStoreConnectionOnFailure)