Re: Secure SQL*Net or Advanced Network Services

We are interested in any information regarding Oracle Advanced network Option aka Secure Network Services.
Currently we are running Oracle 7.3.2.3 and in the ANO documentation states that we need to be at sql net v.2.3.3 on the server and the client which we are not. We are planning on installing oracle 7.3.4. soon so that should get us the right sql net version. I would like to know how easy it is to selectively turn on the security and the encryption on some of the clients but not all of them. Any other comments are also welcome.

Kyler Laird wrote:
>
> cjc_at_interport.net (Cheng-Jih Chen) writes:
>
> > ssh -L 1521:<db_server>:1521 -l oracle <db_server>
>
> I do essentially this. I don't do it for the encryption,
> though. It was just a handy way to "move" the Oracle
> server to an HTTP server that serves an app that uses
> JDBC.
>
> >One major question would be performance. I'm not sure what kind of
> >performance you'd get out of ssh tunnelling.
>
> I suspect that over "slow" links with "fast" computers,
> you'll be able to get better performance with ssh thanks
> to the compression.
>
> --kyler
 

-- 
Thanks ..
=========================
Pinchas  Nisenson 
Data Base Manager 
University (of Calgary) Computing Services 
E-mail: nisenson_at_acs.ucalgary.ca 
Phone:  (403) 220-4447 
Fax:    (403) 282-9361