Page 1 of 2
Can no longer connect in Direct Mode (ORA-03113)
Posted: Thu 29 Jun 2017 15:24
by 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.
Re: Can no longer connect in Direct Mode (ORA-03113)
Posted: Fri 30 Jun 2017 07:11
by 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.
Re: Can no longer connect in Direct Mode (ORA-03113)
Posted: Sat 01 Jul 2017 17:50
by 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
Re: Can no longer connect in Direct Mode (ORA-03113)
Posted: Sun 02 Jul 2017 09:19
by sbslavonac
I second that.
Tried on Oracle 11, Oracle 12i ,same error.
Boris
Re: Can no longer connect in Direct Mode (ORA-03113)
Posted: Mon 03 Jul 2017 07:28
by 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
Re: Can no longer connect in Direct Mode (ORA-03113)
Posted: Mon 03 Jul 2017 10:36
by 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.
Re: Can no longer connect in Direct Mode (ORA-03113)
Posted: Tue 04 Jul 2017 13:05
by Pinturiccio
We have reproduced the issue. We will investigate it and post here about the results as soon as possible.
Re: Can no longer connect in Direct Mode (ORA-03113)
Posted: Fri 07 Jul 2017 13:15
by 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.
Re: Can no longer connect in Direct Mode (ORA-03113)
Posted: Tue 18 Jul 2017 17:05
by 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)
Re: Can no longer connect in Direct Mode (ORA-03113)
Posted: Tue 18 Jul 2017 17:23
by 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.
Re: Can no longer connect in Direct Mode (ORA-03113)
Posted: Thu 20 Jul 2017 08:04
by 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
utahking wrote: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.
Re: Can no longer connect in Direct Mode (ORA-03113)
Posted: Mon 24 Jul 2017 11:52
by Pinturiccio
utahking wrote: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.
Re: Can no longer connect in Direct Mode (ORA-03113)
Posted: Mon 07 Aug 2017 13:36
by 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()
Re: Can no longer connect in Direct Mode (ORA-03113)
Posted: Mon 07 Aug 2017 13:59
by 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.
Re: Can no longer connect in Direct Mode (ORA-03113)
Posted: Thu 10 Aug 2017 14:36
by 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.