5 Replies Latest reply: May 3, 2013 12:55 PM by 994429 RSS

    Managed ODP.Net Beta 2: ORA-03111

    290833
      I am trying a small test project with the new ODP.NET Managed Driver Beta 2.

      I have installed using configure.bat and I am trying to connect to an Oracle 10.1 instance.

      On the call to OracleConnection.Open() the following exception is thrown:

      "ORA-03111: Break received on communication channel"

      StackTrace:
         at Oracle.ManagedDataAccess.Client.OracleException.HandleError(OracleTraceLevel level, OracleTraceTag tag, Exception ex)
         at OracleInternal.ServiceObjects.OracleConnectionImpl.DoDataTypeNegotiation()
         at OracleInternal.ServiceObjects.OracleConnectionImpl.Connect(ConnectionString cs, Boolean bOpenEndUserSession)
         at OracleInternal.ConnectionPool.PoolManager`3.CreateNewPR(Int32 reqCount, Boolean bForPoolPopulation, ConnectionString csWithDiffOrNewPwd)
         at OracleInternal.ConnectionPool.PoolManager`3.Get(ConnectionString csWithDiffOrNewPwd)
         at OracleInternal.ConnectionPool.OraclePoolManager.Get(ConnectionString csWithNewPassword)
         at OracleInternal.ConnectionPool.OracleConnectionDispenser`3.Get(ConnectionString cs, PM conPM, ConnectionString pmCS, SecureString securedPassword, SecureString securedProxyPassword)
         at Oracle.ManagedDataAccess.Client.OracleConnection.Open()
         at ConsoleApplication5.Program.Main(String[] args)
      Testing program source:
      using System;
      using System.Collections.Generic;
      using System.Linq;
      using System.Text;
      using Oracle.ManagedDataAccess.Client;
      
      namespace ConsoleApplication5
      {
          class Program
          {
              static void Main(string[] args)
              {
                  string connstring = "User Id=scott;Password=tiger;Data Source=testserver:1521/testservice";
                  var conn = new Oracle.ManagedDataAccess.Client.OracleConnection(connstring);
                  conn.Open();
                  conn.Close();
                  Console.ReadLine();
              }
          }
      }
      Server version:
      scott@TESTSERVICE(196)> select * from v$version
        2  /
      
      BANNER
      ----------------------------------------------------------------
      Oracle Database 10g Enterprise Edition Release 10.1.0.5.0 - Prod
      PL/SQL Release 10.1.0.5.0 - Production
      CORE    10.1.0.5.0      Production
      TNS for 32-bit Windows: Version 10.1.0.5.0 - Production
      NLSRTL Version 10.1.0.5.0 - Production
      Any ideas?