Re: Client-Server Protocol

From: Mark Bole <makbo_at_pacbell.net>
Date: Thu, 13 May 2004 00:48:11 GMT
Message-ID: <fBzoc.66627$m13.66058@newssvr25.news.prodigy.com>

Sayoni wrote:

> When a client talks to the Oracle server, eg. 'select * from table1'
> what can i see on the wire? is this client-server protocol published?
> if so where can i find more info on it?

It's called Oracle Net (or Net8 or SQL*Net or some other Oracle marketing term). It's built on TNS (transparent network substrate) which is proprietary and subject to change without notice and so there's no point in sniffing it at the TCP/IP level (or whatever network protocol you run).

If security is a concern, the network traffic may well even be encrypted.

If you're trying to avoid using Oracle client software (which is "free" at http://otn.oracle.com), try the JDBC thin client which works with Java.

--Mark Bole Received on Wed May 12 2004 - 19:48:11 CDT