Oracle 9.2 Client/Server cnct to Oracle7 NOT Supported

From: Hemant K Chitale <hkchital_nospam_at_singnet_nospam.com.sg>
Date: Mon, 19 Aug 2002 20:51:52 +0800
Message-ID: <3D60E9E8.429CABE9@singnet_nospam.com.sg>

Be aware of Note 207319.1 :

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>
Received on Mon Aug 19 2002 - 07:51:52 CDT