Connection issue in ASP.NET MVC + NHibernate+Oracle application after a couple of minutes -

Connection issue in ASP.NET MVC + NHibernate+Oracle application after a couple of minutes -

first of all, have mvc web application uses nhibernate (version 3) , oracle 11g database.

the application working, when publish in production server curious scenario happens:

the user access application , perform task, example, select link menu. the user waits couple of minutes (2-3 minutes). the user perform task, example, reload same page or select link menu. the application fails ora-12571: tns:packet author failure exception. the user refresh error page, application works.

the first thing tried isolate problem, published application server same configuration:

same binaries, of course. same oracle x64 client version, minor version. same windows server 2008 version iis 7.5. same iis configuration (we compared windows/system32/inetsrv/config files using winmerge). accessing same production database.

and our surprise couldn't reproduce problem.

please, have clue of going on?

the problem related connection pool of server's oracle client. seems delivering invalid connections web application, while in other servers not happens.

the solution not interesting, putting validate connection = true within connection string resolved issue. aware of performance penalty of this, out of options.

ps: using flag, each connection validated connection pool service before delivering client application. not nice, since database round-trip happen every connection request.

asp.net nhibernate oracle11g