Oci Pooling Error: ORA-24416: Invalid session Poolname was s

ThomasMuellerUGIS · Post by **ThomasMuellerUGIS** » Thu 20 Jan 2011 09:58

Hi,

I'm trying to activate Oci Pooling.
Here is the connection string:
"User Id=xxxxxx;Server=xxxxxx;Persist Security Info=False;Unicode=True;Pooling=False;Oci Session Pooling=True;Oci Session Pool User Id=xxxxxx;Oci Session Pool Password=xxxxxx;Oci Session Pool Min Size=4;Oci Session Pool Max Size=8"

An I get that exception:
2011-01-20 10:36:25,228 ERROR [LoadWorkitems=>()] Puma.WorkItemService.WorkItemManager Exception within threaded execution
Devart.Data.Linq.LinqCommandExecutionException: Error on opening DbConnection. ---> Devart.Data.Oracle.OracleException: ORA-24416: Invalid session Poolname was specified.
at Devart.Data.Oracle.bo.b(Int32 A_0)
at Devart.Data.Oracle.ar.d(Int32 A_0)
at Devart.Data.Oracle.ar.a(t A_0, av A_1)
at Devart.Data.Oracle.OracleInternalConnection..ctor(t connectionOptions, OracleInternalConnection proxyConnection)
at Devart.Data.Oracle.b0.a(l A_0, Object A_1, DbConnectionBase A_2)
at Devart.Common.DbConnectionFactory.a(DbConnectionBase A_0, l A_1)
at Devart.Common.DbConnectionFactory.a(DbConnectionBase A_0)
at Devart.Common.DbConnectionClosed.Open(DbConnectionBase outerConnection)
at Devart.Common.DbConnectionBase.Open()
at Devart.Data.Oracle.OracleConnection.Open()
at Devart.Data.Linq.Provider.n.g()
--- End of inner exception stack trace ---
at Devart.Data.Linq.LinqCommandExecutionException.CanThrowLinqCommandExecutionException(String message, Exception e)
at Devart.Data.Linq.Provider.n.g()
at Devart.Data.Linq.Provider.n.b(IConnectionUser A_0)
at Devart.Data.Linq.Provider.DataProvider.ExecuteQuery(CompiledQuery compiledQuery, Object[] parentArgs, Object[] userArgs, Object lastResult)
at Devart.Data.Linq.Provider.DataProvider.ExecuteAllQueries(CompiledQuery compiledQuery, Object[] userArguments)
at Devart.Data.Linq.Provider.DataProvider.CompiledQuery.Devart.Data.Linq.Provider.ICompiledQuery.Execute(IProvider provider, Object[] userArgs)
at Devart.Data.Linq.DataQuery`1.i()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)

What am I doing wrong?

THX alot,

Thomas

StanislavK · Post by **StanislavK** » Mon 24 Jan 2011 10:09

Thank you for the report, we've reproduced the error for connections with the Unicode parameter set to true. We will investigate the issue and inform you about the results as soon as possible.

ThomasMuellerUGIS · Post by **ThomasMuellerUGIS** » Mon 24 Jan 2011 12:56

StanislavK wrote:Thank you for the report, we've reproduced the error for connections with the Unicode parameter set to true. We will investigate the issue and inform you about the results as soon as possible.

Thanks a lot!

Thomas

StanislavK · Post by **StanislavK** » Thu 27 Jan 2011 18:03

We have fixed the problem, the fix is available in the new 6.10.96 build of dotConnect for Oracle. This build can be downloaded from
http://www.devart.com/dotconnect/oracle/download.html
(the trial version) or from Registered Users' Area (for users with active subscription only):
http://secure.devart.com/

For the detailed information about the fixes and improvements available in dotConnect for Oracle 6.10.96, please refer to
http://www.devart.com/forums/viewtopic.php?t=20115