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

Connecting with an earlier release client may work. But 9i has new character set (AL16UTF16, for example). Earlier release client will not understand the new character set. There are patches for some of the earlier clients, if you can't upgrade client. Check Metalink.

HTH,
Gerardo

-----Original Message-----
Sent: Tuesday, August 20, 2002 9:03 AM
To: Multiple recipients of list ORACLE-L

7.3 clients to 9.2 server should still be supported.

The section "Running Multiple Oracle Releases" in Chapter 1 "Introduction" of the 9.2 Migration Manual had this :

Install Databases in Multiple Oracle Homes on the Same Computer

You can install Oracle7, Oracle8, Oracle8i, and Oracle9i databases in multiple (separate) Oracle homes on the same computer and have Oracle7, Oracle8, Oracle8i, and Oracle9i clients connecting to any or all of the databases.

Install Databases in Multiple Oracle Homes on Separate Computers

You can install Oracle7, Oracle8, Oracle8i, and Oracle9i databases in multiple (separate) Oracle homes on separate computers and have Oracle7, Oracle8, Oracle8i, and Oracle9i clients connecting to any or all of the databases.

Upgrade a Database to the Current Release

You can upgrade an Oracle7, Oracle8, Oracle8i, or Oracle9i database to the current Oracle9i release and have Oracle7, Oracle8, Oracle8i, and Oracle9i clients connecting to the upgraded database. You cannot upgrade the database in the same Oracle home.

Upgrade Clients to the Current Release

You can upgrade any or all of your Oracle7, Oracle8, Oracle8i, or Oracle9i clients to the current Oracle9i release. You can also upgrade your Oracle7, Oracle8, Oracle8i, or Oracle9i database to the current Oracle9i release at a later date.

I guess they will now update it to exclude connections from 9i database and client to an Oracle7 database but I still don't see why Oracle7 clients cannot connect to an Oracle9.2 database. Hemant

At 11:18 AM 19-08-02 -0800, you wrote:
>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
>--------------------------------------------------------------------
>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).

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: Molina, Gerardo
  INET: Gerardo.Molina_at_schwab.com

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).