ORA-03113 (dcoracle 9.04.299 pro)

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
pari
Posts: 17
Joined: Thu 27 Nov 2008 12:33

ORA-03113 (dcoracle 9.04.299 pro)

Post by pari » Thu 29 Jun 2017 10:11

Hi,
after instalation ver. 9.4.299 I got a error message: ORA-03113: end-of-file on communication channel.
I try it in app using Entity Developer and next I try it in Entity Developer: Update From Database Wizzard.
I have a VS2017 pro.

Can you help me?

PaRi

PS: now I back to ver. 9.3.230

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: ORA-03113 (dcoracle 9.04.299 pro)

Post by Shalex » Fri 30 Jun 2017 07:06

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.

pari
Posts: 17
Joined: Thu 27 Nov 2008 12:33

Re: ORA-03113 (dcoracle 9.04.299 pro)

Post by pari » Mon 03 Jul 2017 07:22

Hi,
there are next information:

Code: Select all

using System;
using Devart.Data.Oracle;

namespace TestOra299
{
    class Program
    {
        static void Main()
        {
            //Oracle 12c Enterprise Edition release 12.1.0.1.0 64 bit edition
            using (var connection = new OracleConnection("Data Source=jeseter;Service Name=jeseter;Direct=true")
            { UserId = "scott", Password = "asd" }
                )
            {
                try
                {
                    connection.Open();
                    connection.Close();
                }
                catch (Exception ex)
                {
                    //ORA-03113: end-of-file on communication channel
                    Console.WriteLine(ex.Message);
                }
            }
        }
    }
}
When I remove an uid and a password, the result is same:

Code: Select all

//Oracle 12c Enterprise Edition release 12.1.0.1.0 64 bit edition
using (var connection = new OracleConnection("Data Source=jeseter;Service Name=jeseter;Direct=true"))
{
...
}
PaRi

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: ORA-03113 (dcoracle 9.04.299 pro)

Post by 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: 2420
Joined: Wed 02 Nov 2011 09:44

Re: ORA-03113 (dcoracle 9.04.299 pro)

Post by 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: 2420
Joined: Wed 02 Nov 2011 09:44

Re: ORA-03113 (dcoracle 9.04.299 pro)

Post by Pinturiccio » Thu 20 Jul 2017 07:58

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

Post Reply