Re: Client and Server Versions

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Wed, 27 Mar 2002 06:01:30 +1100
Message-ID: <a7qgkd$lrd$1@lust.ihug.co.nz>

I can't point you to a good document, I'm afraid, though I'm writing one myself at the moment. But yes, you can use 8i clients to access a 9i server, not a problem. There's not even any special tweaking involved if all you're using is SQL Plus (God knows what specific client applications might want, though):

C:\Documents and Settings\Administrator>sqlplus /nolog

SQL*Plus: Release 8.1.7.0.0 - Production on Wed Mar 27 05:58:12 2002

(Note the version of SQL Plus)

SQL> connect system/manager_at_db9
Connected.
SQL> select * from v$version;

BANNER

Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production PL/SQL Release 9.0.1.1.1 - Production
CORE 9.0.1.1.1 Production
TNS for 32-bit Windows: Version 9.0.1.1.0 - Production NLSRTL Version 9.0.1.1.1 - Production

The only 9i-specific thing I can think of is that 9i databases must be serviced by a 9i Listener -an 8i one won't do.

Regards
HJR

--
------------------------------------------
Resources for Oracle : www.hjrdba.com
============================


"HRM" <hrm_at_dontsendmemail.com> wrote in message
news:a7qe2p$nm0$1_at_canopus.cc.umanitoba.ca...


> Can anyone point me to a good document regarding running different

versions


> of Oracle Server and Clients at the same time?  We're new to oracle and

> aren't sure if we can be running Oracle 9 Server with an 8 client.

>

> Thanks.

>

>

>

Received on Tue Mar 26 2002 - 13:01:30 CST