Problem with IIS 6 and Oracle 11

[cabbage]

Hello,

Don't know if this is the right forum but sometimes we have the problem, that the following error occurs:

2008-10-30 17:03:57,199 [1] INFO CS.Test.DAO.Security.SecurityDAO [(null)] - Exception thrown in GetUserInfoList;GetUserInfoList;13499,7408 ms
System.Exception: General Exception!
Methode: SecurityDAO.GetUserInfoList() ---> Spring.Data.CannotGetAdoConnectionException: Could not get ADO.NET connection. ---> Oracle.DataAccess.Client.OracleException ORA-12154: TNS: Could not resolve Connect Identifier at Oracle.DataAccess.Client.OracleException.HandleErr orHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure)
bei Oracle.DataAccess.Client.OracleException.HandleErr or(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, Object src)
bei Oracle.DataAccess.Client.OracleConnection.Open()
bei Spring.Data.Support.ConnectionUtils.DoGetConnectio n(IDbProvider provider)
bei Spring.Data.Support.ConnectionUtils.GetConnectionT xPair(IDbProvider provider)
--- Ende der internen Ausnahmestapelüberwachung ---
bei Spring.Data.Support.ConnectionUtils.GetConnectionT xPair(IDbProvider provider)
bei Spring.Data.Generic.AdoTemplate.Execute[T](IDbCommandCallback`1 action)
bei Spring.Data.Generic.AdoTemplate.QueryWithResultSet Extractor[T](CommandType cmdType, String cmdText, IResultSetExtractor`1 resultSetExtractor)
bei Spring.Data.Generic.AdoTemplate.QueryWithRowMapper[T](CommandType cmdType, String cmdText, IRowMapper`1 rowMapper)
bei CS.NET.Data.Extensions.SpringNET.AdoCSBaseTemplate .QueryDomainWithRowMapper[T](CommandType cmdType, String cmdText, IRowMapper`1 rowMapper, Boolean isReadOnly)
bei CS.Test.DAO.Security.SecurityDAO.GetUserInfoList()
--- Ende der internen Ausnahmestapelüberwachung ---
bei CS.Test.DAO.Security.SecurityDAO.GetUserInfoList()
bei CompositionAopProxy_2aaab9d9bbaf490a83f45173144205 60.GetUserInfoList()
bei Spring.DynamicReflection.Method_GetUserInfoList_c4 c90cb3acfb4d77a864262b7528b994.Invoke(Object target, Object[] args)
bei Spring.Reflection.Dynamic.SafeMethod.Invoke(Object target, Object[] arguments)
bei Spring.Aop.Framework.DynamicMethodInvocation.Invok eJoinpoint()
bei Spring.Aop.Framework.AbstractMethodInvocation.Proc eed()
bei Spring.Aspects.Logging.SimpleLoggingAdvice.InvokeU nderLog(IMethodInvocation invocation, ILog log)

We are using IIS 6.0 and Oracle 11 with Spring 1.1.1. As mentioned before the error occurs only sometimes and sometimes all works fine. Could this be an IIS problem or is it an Oracle problem? Has anybody else the same issue? Please help.

Regards

cabbage

[Mark Pollack]

Hi 'cabbage'

Perhaps this thread will be of use. Let us know how it goes. What does your
connection string look like? What version of ODP.NET?

Cheers,
Mark

[cabbage]

Hi Mark,

thank you for answering. Surfing through the internet we found some messages that this error could be caused by multiple exist of Oracle.Data.Access.dll or OraHome directory. And, we can't believe it - we had a copy of Oracle.Data.Access.dll in our bin directory ...

We removed it on monday and since that we have had no further troubles with our application. I think, we should wait for one or two weeks. If our application will throw no exceptions until then, it may be solved. If it is interesting for you, I can inform you after that periode or when the error will occur again.

Regarding to your question about the versions:
- The file version of Oracle.Data.Access.dll is 2.111.6.20 - I think it is the newest one.
- The connection string must be ok because normally the application works fine, the error will only occur sometimes

By the way: the link was not usefull because it was posted by a colleague of mine, so we knew it - sounds a little bit like
'World is small' for me...

Greetings from Hamburg,

cabbage

[Mark Pollack]

Cool, glad to hear it is working now and greetings from NYC!
Mark

[cabbage]

Hi Mark!

Seems that there was an incomplete ODP installation on the server. With ODP, Oracle is delivering some SQL scripts for ASP which have to be executed after installation of ODP itselve... What should I say? Yes, we forgot them

Without these scripts being executed, it seems that ORACLE will only allow one connection and then this error will occur when the application is running under IIS...

After installing them, we tested the typical error situations and all worked fine til now. Let' s wait a week again and then we will see...

Regards

cabbage