Re: sql net v1 vs. v2

andre_do_at_gmx.net (Andre Doehn) wrote in message news:<87782861.0203260732.45ac35e9_at_posting.google.com>...
> hi,
> can anybody tell me what exactly is the difference between sql net v1
> and sql net v2?
>
> i know that sql net v2 uses a second data connection like ftp, right?
> ...and v1 does´nt?!
>
> thank you!
> bye
> andre

The real difference is that you need a separate driver for each protocol in V1 and you don't in V2. Hence V2 supports multiprotocol interchange: you can have SPX on one side and TCP/IP on the other side.
Also V2 supports Oracle Names, a DNS facility for Oracle databases, and encryption using the Kerberos and other security protocols. Sqlnet, running tcp/ip, uses one port to communicate from client to server, and another one to communicate from server to client. The need for this has been taken away in the sucessor of sqlnet v2, net8.

As all versions of Oracle running sqlnet v1 and v2 have been desupported, the only supported version of sqlnet is currently net8.

Hth

Sybrand Bakker,
Senior Oracle DBA Received on Tue Mar 26 2002 - 18:51:37 CET