Can no longer connect in Direct Mode (ORA-03113)

[utahking]

I just updated our solution and tools to the most recent update and now I receive ORA-03113: end-of-file on communication channel. I attempted to make the connection in Entity Developer as well as within Visual Studio 2017 with both resulting in the same error. I tried on another machine with the previous version (9.4.280) and was successful in connecting, I then updated to 9.4.299 and was no longer able to connect. I no longer have an installer for the previous version so I am unable to move forward without a fix, or access to an older installer package.

[Shalex]

1. Does the issue persist only in Entity Developer or in the code as well? Try this code:

Code: Select all

    var conn = new OracleConnection(your_conn_string);
    conn.Open();

2. Specify your connection string (roughly, without credentials).
3. Tell us the exact version of your target Oracle Server.

[utahking]

1. This error persists no matter the context. If I switch from Direct to OCI, I can connect. Other installed apps that rely on Devart in the GAC also fail to connect in Direct Mode (i.e. Toad DataPoint). If I downgrade to 9.4.280, the problem goes away and I can connect id Direct mode again.

2. "User Id=xxxxxxxx;Password=xxxxx;Server=XXXX-ORACLE;Direct=True;Sid=XXXXXXXX;Persist Security Info=True"

3. 12.1.0.1.0 Enterprise

[sbslavonac]

I second that.
Tried on Oracle 11, Oracle 12i ,same error.
Boris

[pari]

I absolutely agree.

2. "Data Source=jeseter;Service Name=jeseter;Direct=true;User Id=scott;Password=asd"

3. Oracle 12c Enterprise Edition release 12.1.0.1.0 64 bit edition

[Pinturiccio]

We could not reproduce the issue, with dotConnect for Oracle 9.4.299. Could you grant us remote access to your Oracle database only with connect privileges? This would help us to fix the issue much faster. You can send us a connection string for remote connecting to your server via our contact form.

[Pinturiccio]

We have reproduced the issue. We will investigate it and post here about the results as soon as possible.

[Pinturiccio]

We have fixed the bug with the "ORA-03113" error when a Windows account is not in a domain in the Direct mode. We will post here when the corresponding build of dotConnect for Oracle is available for download.

[utahking]

I just installed the latest patch release and now I am receiving a different error, and still can't connect in Direct Mode.

Here are the details:

Exception message: "A call to SSPI failed, see inner exception."
InnerException message: "No credentials are available in the security package"

Stack Trace:

• System.Net.Security.NegoState.StartSendAuthResetSignal(LazyAsyncResult lazyResult, Byte[] message, Exception exception)
  System.Net.Security.NegoState.StartSendBlob(Byte[] message, LazyAsyncResult lazyResult)
  System.Net.Security.NegoState.CheckCompletionBeforeNextSend(Byte[] message, LazyAsyncResult lazyResult)
  System.Net.Security.NegoState.ProcessReceivedBlob(Byte[] message, LazyAsyncResult lazyResult)
  System.Net.Security.NegoState.StartReceiveBlob(LazyAsyncResult lazyResult)
  System.Net.Security.NegoState.CheckCompletionBeforeNextReceive(LazyAsyncResult lazyResult)
  System.Net.Security.NegoState.StartSendBlob(Byte[] message, LazyAsyncResult lazyResult)
  System.Net.Security.NegoState.ProcessAuthentication(LazyAsyncResult lazyResult)
  System.Net.Security.NegotiateStream.AuthenticateAsClient(NetworkCredential credential, ChannelBinding binding, String targetName, ProtectionLevel requiredProtectionLevel, TokenImpersonationLevel allowedImpersonationLevel)
  System.Net.Security.NegotiateStream.AuthenticateAsClient(NetworkCredential credential, String targetName, ProtectionLevel requiredProtectionLevel, TokenImpersonationLevel allowedImpersonationLevel)
  Devart.Data.Oracle.d0.k()
  Devart.Data.Oracle.bp.a(String A_0, String A_1, String A_2, String A_3, String A_4)
  Devart.Data.Oracle.cm.a(dq A_0, Boolean A_1)
  Devart.Data.Oracle.cm.a(dq A_0, bs A_1)
  Devart.Data.Oracle.OracleInternalConnection..ctor(dq connectionOptions, OracleInternalConnection proxyConnection)
  Devart.Data.Oracle.dz.a(n A_0, Object A_1, DbConnectionBase A_2)
  Devart.Common.DbConnectionFactory.a(DbConnectionPool A_0, n A_1, DbConnectionBase A_2)
  Devart.Common.DbConnectionPool.a(DbConnectionBase A_0)
  Devart.Common.DbConnectionPool.GetObject(DbConnectionBase owningConnection)
  Devart.Common.DbConnectionFactory.b(DbConnectionBase A_0)
  Devart.Common.DbConnectionClosed.Open(DbConnectionBase outerConnection)
  Devart.Common.DbConnectionBase.Open()
  Devart.Data.Oracle.OracleConnection.Open()
  Devart.Common.Entity.a2.Open()
  Devart.Data.Oracle.Entity.l.a(DbConnection A_0, OracleServerType& A_1, Nullable`1& A_2)
  Devart.Data.Oracle.Entity.l.b(DbConnection A_0)
  Devart.Data.Oracle.Entity.ax..ctor(IRelationalConnection A_0)
  Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitConstructor(ConstructorCallSite constructorCallSite, ServiceProvider provider)
  Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSite(IServiceCallSite callSite, TArgument argument)
  Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitScoped(ScopedCallSite scopedCallSite, ServiceProvider provider)
  Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSite(IServiceCallSite callSite, TArgument argument)
  Microsoft.Extensions.DependencyInjection.ServiceProvider.<>c__DisplayClass16_0.<RealizeService>b__0(ServiceProvider provider)
  Microsoft.Extensions.DependencyInjection.ServiceProvider.GetService(Type serviceType)
  Microsoft.Extensions.DependencyInjection.ServiceProviderServiceExtensions.GetRequiredService(IServiceProvider provider, Type serviceType)
  Microsoft.Extensions.DependencyInjection.ServiceProviderServiceExtensions.GetRequiredService(IServiceProvider provider)
  Microsoft.EntityFrameworkCore.Storage.DatabaseProviderServices.GetService()
  Devart.Data.Oracle.Entity.OracleEntityProviderServices.TypeMapper
  Microsoft.EntityFrameworkCore.Infrastructure.RelationalServiceCollectionExtensions.<>c.<AddRelational>b__0_11(IServiceProvider p)
  Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitFactoryService(FactoryService factoryService, ServiceProvider provider)
  Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSite(IServiceCallSite callSite, TArgument argument)
  Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitScoped(ScopedCallSite scopedCallSite, ServiceProvider provider)
  Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSite(IServiceCallSite callSite, TArgument argument)
  Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitConstructor(ConstructorCallSite constructorCallSite, ServiceProvider provider)
  Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSite(IServiceCallSite callSite, TArgument argument)
  Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitScoped(ScopedCallSite scopedCallSite, ServiceProvider provider)
  Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSite(IServiceCallSite callSite, TArgument argument)
  Microsoft.Extensions.DependencyInjection.ServiceProvider.<>c__DisplayClass16_0.<RealizeService>b__0(ServiceProvider provider)
  Microsoft.Extensions.DependencyInjection.ServiceProvider.GetService(Type serviceType)
  Microsoft.Extensions.DependencyInjection.ServiceProviderServiceExtensions.GetRequiredService(IServiceProvider provider, Type serviceType)
  Microsoft.Extensions.DependencyInjection.ServiceProviderServiceExtensions.GetRequiredService(IServiceProvider provider)
  Microsoft.EntityFrameworkCore.Storage.DatabaseProviderServices.GetService()
  Devart.Data.Oracle.Entity.OracleEntityProviderServices.ConventionSetBuilder
  Microsoft.EntityFrameworkCore.Internal.DbContextServices.CreateModel()
  Microsoft.EntityFrameworkCore.Internal.LazyRef`1.Value
  Microsoft.EntityFrameworkCore.Internal.DbContextServices.Model
  Microsoft.EntityFrameworkCore.Infrastructure.EntityFrameworkServiceCollectionExtensions.<>c.<AddEntityFramework>b__0_6(IServiceProvider p)
  Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitFactoryService(FactoryService factoryService, ServiceProvider provider)
  Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSite(IServiceCallSite callSite, TArgument argument)
  Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitScoped(ScopedCallSite scopedCallSite, ServiceProvider provider)
  Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSite(IServiceCallSite callSite, TArgument argument)
  Microsoft.Extensions.DependencyInjection.ServiceProvider.<>c__DisplayClass16_0.<RealizeService>b__0(ServiceProvider provider)
  Microsoft.Extensions.DependencyInjection.ServiceProvider.GetService(Type serviceType)
  Microsoft.Extensions.DependencyInjection.ServiceProviderServiceExtensions.GetRequiredService(IServiceProvider provider, Type serviceType)
  Microsoft.Extensions.DependencyInjection.ServiceProviderServiceExtensions.GetRequiredService(IServiceProvider provider)
  Microsoft.EntityFrameworkCore.DbContext.Model
  Microsoft.EntityFrameworkCore.Internal.EntityFinderSource.<>c__DisplayClass2_0.<Create>b__0(Type t)
  System.Collections.Concurrent.ConcurrentDictionary`2.GetOrAdd(TKey key, Func`2 valueFactory)
  Microsoft.EntityFrameworkCore.Internal.EntityFinderSource.Create(DbContext context, Type type)
  Microsoft.EntityFrameworkCore.DbContext.Finder(Type entityType)
  Microsoft.EntityFrameworkCore.DbContext.Find(Object[] keyValues)
  Microsoft.EntityFrameworkCore.Internal.InternalDbSet`1.Find(Object[] keyValues)

[utahking]

Additionally, here is a StackOverflow post with some details:

https://stackoverflow.com/questions/397 ... -to-oracle

It appears to be related to SQLNET.AUTHENTICATION_SERVICES on the client.

[Pinturiccio]

Yes, new dotConnect for Oracle 9.4.314 includes the fix of the ORA-03113 error.

New build of dotConnect for Oracle 9.4.314 is available for download.
It can be downloaded from http://www.devart.com/dotconnect/oracle/download.html (trial version) or from Customer Portal (for users with valid subscription only).
For more information, please refer to viewtopic.php?t=35679

Exception message: "A call to SSPI failed, see inner exception."
InnerException message: "No credentials are available in the security package"

We will investigate the issue and post here about the results as soon as possible.

[Pinturiccio]

Exception message: "A call to SSPI failed, see inner exception."
InnerException message: "No credentials are available in the security package"

We have answered you via e-mail.

[t0pdevice]

I have same problem.

Exception message: "A call to SSPI failed, see inner exception."
InnerException message: "No credentials are available in the security package"
в System.Net.Security.NegoState.StartSendAuthResetSignal(LazyAsyncResult lazyResult, Byte[] message, Exception exception)
в System.Net.Security.NegoState.StartSendBlob(Byte[] message, LazyAsyncResult lazyResult)
в System.Net.Security.NegoState.CheckCompletionBeforeNextSend(Byte[] message, LazyAsyncResult lazyResult)
в System.Net.Security.NegoState.ProcessReceivedBlob(Byte[] message, LazyAsyncResult lazyResult)
в System.Net.Security.NegoState.StartReceiveBlob(LazyAsyncResult lazyResult)
в System.Net.Security.NegoState.CheckCompletionBeforeNextReceive(LazyAsyncResult lazyResult)
в System.Net.Security.NegoState.StartSendBlob(Byte[] message, LazyAsyncResult lazyResult)
в System.Net.Security.NegoState.ProcessAuthentication(LazyAsyncResult lazyResult)
в System.Net.Security.NegotiateStream.AuthenticateAsClient(NetworkCredential credential, ChannelBinding binding, String targetName, ProtectionLevel requiredProtectionLevel, TokenImpersonationLevel allowedImpersonationLevel)
в System.Net.Security.NegotiateStream.AuthenticateAsClient(NetworkCredential credential, String targetName, ProtectionLevel requiredProtectionLevel, TokenImpersonationLevel allowedImpersonationLevel)
в Devart.Data.Oracle.d0.k()
в Devart.Data.Oracle.bo.a(String A_0, String A_1, String A_2, String A_3, String A_4)
в Devart.Data.Oracle.cl.a(dr A_0, Boolean A_1)
в Devart.Data.Oracle.cl.a(dr A_0, br A_1)
в Devart.Data.Oracle.OracleInternalConnection..ctor(dr connectionOptions, OracleInternalConnection proxyConnection)
в Devart.Data.Oracle.dz.a(n A_0, Object A_1, DbConnectionBase A_2)
в Devart.Common.DbConnectionFactory.a(DbConnectionPool A_0, n A_1, DbConnectionBase A_2)
в Devart.Common.DbConnectionPoolGroup.a(DbConnectionPool A_0, DbConnectionBase A_1)
в Devart.Common.DbConnectionPool.a(DbConnectionBase A_0)
в Devart.Common.DbConnectionPool.GetObject(DbConnectionBase owningConnection)
в Devart.Common.DbConnectionFactory.b(DbConnectionBase A_0)
в Devart.Common.DbConnectionClosed.Open(DbConnectionBase outerConnection)
в Devart.Common.DbConnectionBase.Open()
в Devart.Data.Oracle.OracleConnection.Open()

[eridu0]

I also have the SSPI failed exception on Windows 10 when signed in using a Microsoft account. No issue when signed in with a local account.

[Pinturiccio]

We have reproduced the issue with the SSPI failed exception on Windows 10 when signed in using a Microsoft account. We will investigate it and post here about the results as soon as possible.