This discussion is archived
5 Replies Latest reply: Nov 15, 2013 1:53 AM by 4da006c7-f44a-4c52-bb71-8c2c9dc2ea0e RSS

ORA-03134: Connections to this server version are no longer supported from 11.2 to 9.2.0.8 database

4da006c7-f44a-4c52-bb71-8c2c9dc2ea0e Newbie
Currently Being Moderated

Hi,

 

I am using the ODP.NET 11.2 (Oracle.DataAccess.dll 4.112.3.0) for .NET 4.5 (in Visual Studio 2012). I can connect to 11g Databases but when trying to connect to 9.2.0.8 database this error is thrown:

 

ORA-03134: Connections to this server version are no longer supported

 

I don't understand why, as I could connect using Toad, but not from a .NET application.

 

By the way, I'm using Windows 7 64bits.

 

Any idea?

Thanks in advance,

Dave

  • 1. Re: ORA-03134: Connections to this server version are no longer supported from 11.2 to 9.2.0.8 database
    Mark Williams-Oracle Employee ACE
    Currently Being Moderated

    Hi Dave,

     

    While I recall that Oracle Client 10.2 and higher should be able to connect to 9.2.0.4 and higher I'd need to review to verify. It's been awhile.

     

    Can you verify if Toad is using a different Oracle Home which contains a version of the client software which can connect to 9.2.0.8 server?

     

    I've never used Toad so not sure of the exact steps needed to verify from within Toad, but my first thought is that Toad must be using a different install/version than your .NET application.

     

    Is the install for ODP a full client install? Do you have SQL*Plus in this home? If so, what behavior do you see trying to connect to the 9.2.0.8 server with SQL*Plus in the 11.2 home?

     

    Thanks,

    Mark

  • 2. Re: ORA-03134: Connections to this server version are no longer supported from 11.2 to 9.2.0.8 database
    Mark Williams-Oracle Employee ACE
    Currently Being Moderated

    I had some time this evening to do some testing and this is all working correctly on my local system.

     

    Here's some information - perhaps you can confirm against your environment.

     

    C:\>gacutil /l Oracle.DataAccess
    Microsoft (R) .NET Global Assembly Cache Utility.  Version 4.0.30319.1
    Copyright (c) Microsoft Corporation.  All rights reserved.

    The Global Assembly Cache contains the following assemblies:
      Oracle.DataAccess, Version=4.112.3.0, Culture=neutral, PublicKeyToken=89b483f429c47342, processorArchitecture=x86
    Number of items = 1

    SQL> select product, version from sys.product_component_version;

    PRODUCT                                          VERSION
    ------------------------------------------------ ---------------
    NLSRTL                                           9.2.0.8.0
    Oracle9i Enterprise Edition                      9.2.0.8.0
    PL/SQL                                           9.2.0.8.0
    TNS for 32-bit Windows:                          9.2.0.8.0

    4 rows selected.

    using System;
    using System.Collections.Generic;
    using System.Linq;
    using System.Text;
    using System.Diagnostics;
    using System.Data;
    using Oracle.DataAccess.Types;
    using Oracle.DataAccess.Client;

    namespace V92Test
    {
      class Program
      {
        static void Main(string[] args)
        {
          string constr = "Data Source=V92;" +
                          "User Id=scott;" +
                          "Password=tiger;" +
                          "Pooling=false;" +
                          "Enlist=false";

          OracleConnection con = new OracleConnection(constr);
          try
          {
            con.Open();
          }
          catch (OracleException ex)
          {
            Console.WriteLine(ex.Message);
          }

          if (con.State == ConnectionState.Open)
          {
            Console.WriteLine("Connected to: {0}", con.ConnectionString);
            Console.WriteLine("Server Version: {0}\n", con.ServerVersion);
          }

          con.Dispose();

          if (Debugger.IsAttached)
          {
            Console.Write("Any key to terminate...");
            Console.ReadKey(true);
          }
        }
      }
    }


    Connected to: Data Source=V92;User Id=scott;Pooling=false;Enlist=false
    Server Version: 9.2.0.8.0

    Any key to terminate...
  • 3. Re: ORA-03134: Connections to this server version are no longer supported from 11.2 to 9.2.0.8 database
    4da006c7-f44a-4c52-bb71-8c2c9dc2ea0e Newbie
    Currently Being Moderated

    Thanks Mark for looking into this.

     

    The GAC contains the following assemblies:

     

    Microsoft (R) .NET Global Assembly Cache Utility.  Version 4.0.30319.17929

    Copyright (c) Microsoft Corporation.  All rights reserved.

     

    The Global Assembly Cache contains the following assemblies:

      Oracle.DataAccess, Version=2.102.4.0, Culture=neutral, PublicKeyToken=89b483f4

    29c47342, processorArchitecture=AMD64

      Oracle.DataAccess, Version=2.112.3.0, Culture=neutral, PublicKeyToken=89b483f4

    29c47342, processorArchitecture=AMD64

      Oracle.DataAccess, Version=2.112.3.0, Culture=neutral, PublicKeyToken=89b483f4

    29c47342, processorArchitecture=x86

      Oracle.DataAccess, Version=2.121.1.0, Culture=neutral, PublicKeyToken=89b483f4

    29c47342, processorArchitecture=x86

      Oracle.DataAccess, Version=4.112.3.0, Culture=neutral, PublicKeyToken=89b483f4

    29c47342, processorArchitecture=AMD64

      Oracle.DataAccess, Version=4.112.3.0, Culture=neutral, PublicKeyToken=89b483f4

    29c47342, processorArchitecture=x86

      Oracle.DataAccess, Version=4.121.1.0, Culture=neutral, PublicKeyToken=89b483f4

    29c47342, processorArchitecture=x86

     

    Number of items = 7

     

    As you can see, I have been trying with different versions but nothing. Anyway, as far as I know if the referenced library in VStudio is marked as CopyToLocal, it shouldn't take any library from GAC.

     

    And SQL query is returning this info:

     

     

     

    PRODUCT

    ----------------------------------------------------------------

    VERSION

    ----------------------------------------------------------------

    NLSRTL

    9.2.0.8.0

     

     

    Oracle9i Enterprise Edition

    9.2.0.8.0

     

     

    PL/SQL

    9.2.0.8.0

     

     

     

     

    PRODUCT

    ----------------------------------------------------------------

    VERSION

    ----------------------------------------------------------------

    TNS for HPUX:

    9.2.0.8.0

     

    Thanks.

  • 4. Re: ORA-03134: Connections to this server version are no longer supported from 11.2 to 9.2.0.8 database
    Mark Williams-Oracle Employee ACE
    Currently Being Moderated

    Hi Dave,

     

    I see you have version 12 of the provider in the GAC (i.e. Version=4.121.1.0). But only for x86 and you mentioned you had Windows 7 64-bit. Is your application compiled as x86, x64 or Any CPU?

     

    Have you confirmed that your application is not loading this version? For example, due to policy redirects in GAC (such as Policy.4.112.Oracle.DataAccess, Version=4.121.1.0).

     

    You could use a tool like SysInternals Process Explorer or the Assembly Binding Log Viewer (i.e. fuslogvw from the SDK) to confirm this if needed.

     

    It is correct that version 12 would return the ORA-3134 when attempting to connect to a 9.2 database as that combination is not supported.

     

    Thanks,

    Mark

  • 5. Re: ORA-03134: Connections to this server version are no longer supported from 11.2 to 9.2.0.8 database
    4da006c7-f44a-4c52-bb71-8c2c9dc2ea0e Newbie
    Currently Being Moderated

    Hi Mark,

     

    Thanks a lot for your help, I solved the issue uninstalling version 12, as I am using databases 11 and 9.2.

     

    Now it's working fine with client 11.

     

    Best wishes,

    David

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points