System.Data.OracleClient.OracleException:ORA-12154: TNS:could not resolve the connect identifier spe_system.data.oracleclient.oracleexception (0x801319-优快云博客

本文链接：https://blog.youkuaiyun.com/sniper007/article/details/9126463

最近接手离职同事的项目，交接进行了30分钟，牛人直接给了我一个.7z的压缩包，然后电话不接，QQ消息不回，失踪了。
没法，将压缩包解压出来之后，打算编译一个版本准备先发布到服务器上去

项目环境：

VS2010 + MVC3 + ORACLE，

服务器环境：

PL/SQL Developer
Version 7.1.1.1339
Windows Vista (64-bit) 6.0 Build 6002 (Service Pack 2)

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

PL/SQL Release 11.2.0.1.0 - Production

CORE 11.2.0.1.0 Production

TNS for Linux: Version 11.2.0.1.0 - Production

NLSRTL Version 11.2.0.1.0 - Production

X86下本地测试一切正常，

于是乎编译X64往64位Server 2008服务器上放的时候发生错误-

System.Data.OracleClient.OracleException:ORA-12154: TNS:could not resolve the connect identifier spe

当前服务器上有一个老的版本，并且应用程序池设定不兼容32bit,能够正常运行，PLSQL也运行正常，数据库操作正常，可就是新部署的新版本网站不正常，报错信息如下。

我发现这个Exception来至于System.Data.OracleClient.OracleException ，

1>我下载了一个64位的System.Data.OracleClient.dll测试，问题依旧，

2>我在程序池中设定兼容32位，然后本地BUILD 一个x86的包部署，不但所有DLL无法加载，老的版本也跟着报错

3>改回设定默认：不兼容32位，然后本地BUILDX64,ANYCPU的包部署，问题依旧，

ORA-12154: TNS:could not resolve the connect identifier specified

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.OracleClient.OracleException: ORA-12154: TNS:could not resolve the connect identifier specified

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[OracleException (0x80131938): ORA-12154: TNS:could not resolve the connect identifier specified
]
   System.Data.OracleClient.OracleException.Check(OciErrorHandle errorHandle, Int32 rc) +519713
   System.Data.OracleClient.OracleInternalConnection.OpenOnLocalTransaction(String userName, String password, String serverName, Boolean integratedSecurity, Boolean unicode, Boolean omitOracleConnectionName) +469060
   System.Data.OracleClient.OracleInternalConnection..ctor(OracleConnectionString connectionOptions) +147
   System.Data.OracleClient.OracleConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) +58
   System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +49
   System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +417430
   System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +91
   System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +1922
   System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +85
   System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +253966
   System.Data.OracleClient.OracleConnection.Open() +48
   NHibernate.Connection.DriverConnectionProvider.GetConnection() +377
   NHibernate.Tool.hbm2ddl.SuppliedConnectionProviderConnectionHelper.Prepare() +92
   NHibernate.Tool.hbm2ddl.SchemaMetadataUpdater.GetReservedWords(Dialect dialect, IConnectionHelper connectionHelper) +154
   NHibernate.Tool.hbm2ddl.SchemaMetadataUpdater.Update(ISessionFactory sessionFactory) +312
   NHibernate.Impl.SessionFactoryImpl..ctor(Configuration cfg, IMapping mapping, Settings settings, EventListeners listeners) +1810
   NHibernate.Cfg.Configuration.BuildSessionFactory() +292
   iTCP.Db.NHibernateSession..cctor() in D:\conti\ITCP\Chery\Solutions\iTCP.Db\NHibernateSession.cs:22

[TypeInitializationException: The type initializer for 'iTCP.Db.NHibernateSession' threw an exception.]
   iTCP.Db.NHibernateSession.GetNHibernateSession() in D:\conti\ITCP\Chery\Solutions\iTCP.Db\NHibernateSession.cs:32
   iTCP.Db.SessionFactory.GetSession() in D:\conti\ITCP\Chery\Solutions\iTCP.Db\SessionFactory.cs:33
   iTCP.Db.NHibFactory.get_DataBaseSession() in D:\conti\ITCP\Chery\Solutions\iTCP.Db\NHibFactory.cs:68
   iTCP.Db.DBHelper.GetList(String strWhere, String strSortFiled, Boolean direction, Boolean sessionClear) in D:\conti\ITCP\Chery\Solutions\iTCP.Db\DBHelper.cs:248
   iTCP.Db.DBHelper.GetList(String strWhere, String strSortFiled, Boolean direction) in D:\conti\ITCP\Chery\Solutions\iTCP.Db\DBHelper.cs:234
   iTCP.Lib.LogManageLib.GetLastQuitMessage() in D:\conti\ITCP\Chery\Solutions\iTCP.Lib\LogManageLib.cs:92
   iTCP.Web.Controllers.HomeController.Index(Nullable`1 pageindex) in D:\conti\ITCP\Chery\Solutions\iTCP.Web\Controllers\HomeController.cs:34
   lambda_method(Closure , ControllerBase , Object[] ) +118
   System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters) +248
   System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters) +39
   System.Web.Mvc.<>c__DisplayClass15.<InvokeActionMethodWithFilters>b__12() +125
   System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation) +640
   System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation) +640
   System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodWithFilters(ControllerContext controllerContext, IList`1 filters, ActionDescriptor actionDescriptor, IDictionary`2 parameters) +312
   System.Web.Mvc.ControllerActionInvoker.InvokeAction(ControllerContext controllerContext, String actionName) +691
   System.Web.Mvc.Controller.ExecuteCore() +162
   System.Web.Mvc.ControllerBase.Execute(RequestContext requestContext) +305
   System.Web.Mvc.<>c__DisplayClassb.<BeginProcessRequest>b__5() +62
   System.Web.Mvc.Async.<>c__DisplayClass1.<MakeVoidDelegate>b__0() +20
   System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +453
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +371

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1