Re: SQL*Net : error - ORA 01011
From: Kim Hughes <Kim=Hughes%NA%Contractors_at_bangate.compaq.com>
Date: 1995/08/01
Message-ID: <DCn8to.Kq7_at_twisto.eng.hou.compaq.com>#1/1
> Problem!!
> My server is running Oracle 6.0.33.1 with SQL*Net V1
> The client is V7.0.15.4.0 Oracle with SQL*Net V1 and V2
>
> In SQL*DBA I can connect to the server using the connect string,
> no problem. But when I try to do any SQL statement (in fact, if I try
> to send any statement, even gibberish) I get this error :
>
> ORA 01011 : Cannot use v7 compatability mode when talking to v6 server.
>
> I can't find this is any of the manuals.
> The connect string has the V1 structure so it should be a straightforward
> V1-V1 connection.
>
> You folks got any clues how to sort this out?
Date: 1995/08/01
Message-ID: <DCn8to.Kq7_at_twisto.eng.hou.compaq.com>#1/1
fallon_at_mee.tcd.ie (Niall Fallon) wrote:
>
> Problem!!
> My server is running Oracle 6.0.33.1 with SQL*Net V1
> The client is V7.0.15.4.0 Oracle with SQL*Net V1 and V2
>
> In SQL*DBA I can connect to the server using the connect string,
> no problem. But when I try to do any SQL statement (in fact, if I try
> to send any statement, even gibberish) I get this error :
>
> ORA 01011 : Cannot use v7 compatability mode when talking to v6 server.
>
> I can't find this is any of the manuals.
> The connect string has the V1 structure so it should be a straightforward
> V1-V1 connection.
>
> You folks got any clues how to sort this out?
From the client V7 database issue this command: SET COMPATIBILITY V6; This will set the sqldba interpreture to V6 mode.
Kim Hughes
DRT Systems International
Houston, TX
Received on Tue Aug 01 1995 - 00:00:00 CEST