Oracle-L: RE: Oracle 9.2 Client/Server cnct to Oracle7 NOT Supported

From: John Weatherman <john.weatherman_at_replacements.com>
Date: Mon, 19 Aug 2002 11:18:24 -0800
Message-ID: <F001.004B93CC.20020819111824@fatcity.com>

Anybody know anything about the reverse? A 7.3 client with a 9.2 server?

TIA, John P Weatherman
Database Administrator
Replacements Ltd.

-----Original Message-----
Sent: Monday, August 19, 2002 9:54 AM
To: Multiple recipients of list ORACLE-L

An Oracle Alert Note 207319.1 has been issued :

Connections from Oracle 9.2 to Oracle7 are Not Supported

This alert documents a restriction introduced in Oracle 9.2.0.1 which was omitted from the
shipped documentation / README files.

Versions Affected

Oracle9i Release 2 (9.2.0.1) onwards is affected.

Platforms Affected

GENERIC , all platforms are affected

Description

Contrary to references in the documentation which may indicate otherwise connections from an
Oracle 9.2 client to any Oracle7 database are NOT supported. This includes any form of Oracle
9.2 client such as:

Client code statically linked with Oracle 9.2 client libraries Dynamically linked client code which uses Oracle 9.2 shared client libraries Database link connections from Oracle 9.2 to any Oracle7 database or gateway

This alert is to warn customers of this restriction. Oracle 9.2 does not report an error at connect
time but subsequent operations may fail with unexpected errors or dumps.

Likelihood of Occurrence

The likelihood of hitting problems depend on the operation being attempted.

Possible Symptoms

There are numerous symptoms which can occur when making a connection from an Oracle 9.2
client to an Oracle7 database. Some of these are shown below in order to aid rediscovery of this
restriction.

SQLPLUS / SQLPLUSW connections may dump / Dr Watson with a call stack like this:
ttccfpg
ttcfour
ttcdrv
nioqwa
xaolog
upirtr
kpudbcx
kpuexInitStmh
kpuexec
OCIStmtExecute

Client SELECT operations may fail with errors such as: ORA-1002 Fetch out of sequence

Operations over database links may fail with errors such as ORA-2063 / ORA-1002 Fetch out of sequence ORA-600 [qerrmOFBu1], [1003]

Workaround

There is no workaround as this is an unsupported combination. Either upgrade the Oracle7
database or use a lower version client.

Patches

The fix under <Bug:2308496> will cause client connections to report a connect time error
(ORA-24439) on an attempt to connect to Oracle7 from an Oracle 9.2 client. This fix will be
included in the 9.2.0.2 Patch Set.

There will be no patches produced to allow Oracle 9.2 to connect to Oracle7 as such
connections are not supported.

References

Documentation Bug for incorrect information about 9.2 -> 7 <Bug:2477736> Report a connect time error for 9.2 -> 7 connect attempts <Bug:2308496>

Hemant K Chitale
Now using Eudora Email. Try it !

My home page is : http://hkchital.tripod.com

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Hemant K Chitale
INET: hkchital_at_singnet.com.sg

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: John Weatherman
INET: john.weatherman_at_replacements.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------