Re: SQLNet v1 and 7.3 any work arounds?

From: Chris Hamilton <toneczar_at_erols.com>
Date: 23 Apr 1998 12:48:01 GMT
Message-ID: <01bd6eb6$03775f60$73344b9b@chrish.hq.usace.army.mil>

Spilsbury, Mark <MSpilsbury_at_Westrail.wa.gov.au> wrote ...

> Has anybody got any good work arounds for connecting
> to a 7.3 database via SQLNet v1?

> We have a SQL Windows application that only works
> with SQLNet v1 and we would like to move the database
> from 7.1.6 to 7.3.3.

A work-around that I've used is:

Install a 7.3 database in a separate ORACLE_HOME (or on a separate server), with SQL*Net v2.
Keep your existing 7.1 database in a separate ORACLE_HOME (or separate server). Install SQL*Net v1 and v2.
Create a set of synonyms and a database link in the 7.1 database, pointing to objects in the 7.3 database. Since it has both v1 and v2 of SQL*Net, it can take client requests from v1 and access objects in the 7.3 database via v2.

The layout looks something like this (view with fixed-pitch font):

CLIENT PC                  SERVER                    SERVER
                                  Oracle 7.1                   Oracle 7.3
                                  SQL*Net 2  <----------->  SQL*Net 2
SQL*Net 1     <------->  SQL*Net 1

SQLWindows

Performance may be a problem for some statements. Like I said, this is a just a workaround.

Chris

Chris Hamilton
christopher.h.hamilton_at_usace.army.mil
US Army Corps of Engineers
http://www.serve.com/cowpb/chamilton.html Received on Thu Apr 23 1998 - 07:48:01 CDT