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

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

Postby utahking » Thu 29 Jun 2017 15:24

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.
utahking
 
Posts: 6
Joined: Thu 29 Jun 2017 15:20

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

Postby Shalex » Fri 30 Jun 2017 07:11

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.
Shalex
Devart Team
 
Posts: 7699
Joined: Thu 14 Aug 2008 12:44

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

Postby utahking » Sat 01 Jul 2017 17:50

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
utahking
 
Posts: 6
Joined: Thu 29 Jun 2017 15:20

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

Postby sbslavonac » Sun 02 Jul 2017 09:19

I second that.
Tried on Oracle 11, Oracle 12i ,same error.
Boris
sbslavonac
 
Posts: 35
Joined: Mon 02 Apr 2007 09:14

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

Postby pari » Mon 03 Jul 2017 07:28

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
pari
 
Posts: 17
Joined: Thu 27 Nov 2008 12:33

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

Postby Pinturiccio » Mon 03 Jul 2017 10:36

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
Devart Team
 
Posts: 1996
Joined: Wed 02 Nov 2011 09:44

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

Postby Pinturiccio » Tue 04 Jul 2017 13:05

We have reproduced the issue. We will investigate it and post here about the results as soon as possible.
Pinturiccio
Devart Team
 
Posts: 1996
Joined: Wed 02 Nov 2011 09:44

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

Postby Pinturiccio » Fri 07 Jul 2017 13:15

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.
Pinturiccio
Devart Team
 
Posts: 1996
Joined: Wed 02 Nov 2011 09:44

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

Postby utahking » Tue 18 Jul 2017 17:05

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
 
Posts: 6
Joined: Thu 29 Jun 2017 15:20

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

Postby utahking » Tue 18 Jul 2017 17:23

Additionally, here is a StackOverflow post with some details:

https://stackoverflow.com/questions/39723323/no-credentials-are-available-in-the-security-package-when-connection-to-oracle

It appears to be related to SQLNET.AUTHENTICATION_SERVICES on the client.
utahking
 
Posts: 6
Joined: Thu 29 Jun 2017 15:20

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

Postby Pinturiccio » Thu 20 Jul 2017 08:04

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 http://forums.devart.com/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.
Pinturiccio
Devart Team
 
Posts: 1996
Joined: Wed 02 Nov 2011 09:44

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

Postby Pinturiccio » Mon 24 Jul 2017 11:52

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.
Pinturiccio
Devart Team
 
Posts: 1996
Joined: Wed 02 Nov 2011 09:44

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

Postby t0pdevice » Mon 07 Aug 2017 13:36

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()
t0pdevice
 
Posts: 3
Joined: Mon 07 Aug 2017 07:19

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

Postby eridu0 » Mon 07 Aug 2017 13:59

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.
eridu0
 
Posts: 1
Joined: Fri 04 May 2012 11:16

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

Postby Pinturiccio » Thu 10 Aug 2017 14:36

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.
Pinturiccio
Devart Team
 
Posts: 1996
Joined: Wed 02 Nov 2011 09:44

Next

Return to dotConnect for Oracle