ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Polling with Proxy Connection Giving timed out exception after few hours

517966May 18 2007 — edited Feb 7 2008

My connection string is something like this

"User Id=scott;Password=tiger;" +
"Data Source=oracle;Proxy User Id=appserver;Proxy Password=eagle;Pooling=True;Connection Lifetime=120; Incr Pool Size=2 ; Decr Pool Size=5 ;Min Pool Size =5

Now when simultanous connections open, lets say 10 + users are connected,

Following errors start coming after about 3-4 hours of usage

First error

Oracle.DataAccess.Client.OracleException ORA-28179: client user name not provided by proxy at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure)
at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, Object src)
at Oracle.DataAccess.Client.OracleConnection.Open()
at DataAccess.DBConnection.BuildConnection(Boolean isThroughProxy)5/18/2007 11:12:24 AM-->ORA-28179: client user name not provided by proxy
at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure)
at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, Object src)
at Oracle.DataAccess.Client.OracleConnection.Open()
at DataAccess.DBConnection.BuildConnection(Boolean isThroughProxy)

Second error

Oracle.DataAccess.Client.OracleException Connection request timed out at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure)
at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, Object src)
at Oracle.DataAccess.Client.OracleConnection.Open()
at DataAccess.DBConnection.BuildConnection(Boolean isThroughProxy)5/18/2007 3:50:59 PM-->Connection request timed out
at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure)
at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, Object src)
at Oracle.DataAccess.Client.OracleConnection.Open()
at DataAccess.DBConnection.BuildConnection(Boolean isThroughProxy)

Third Error

Oracle.DataAccess.Client.OracleException ORA-1045: user %s lacks CREATE SESSION privilege; logon denied at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure)
at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, Object src)
at Oracle.DataAccess.Client.OracleConnection.Open()
at DataAccess.DBConnection.BuildConnection(Boolean isThroughProxy)5/16/2007 7:08:17 PM-->ORA-1045: user %s lacks CREATE SESSION privilege; logon denied
at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure)
at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, Object src)
at Oracle.DataAccess.Client.OracleConnection.Open()
at DataAccess.DBConnection.BuildConnection(Boolean isThroughProxy)

After this IIS stops to respond..

I tried using
ClearAllPools after such error but it is not of any use

Any suggestion

Environment is window 2003 server,
OracleDataAccess = 10.2.0.200

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 6 2008

Added on May 18 2007

#odp-net

4 comments

6,330 views