Re: *NEWBIE* Help needed for decoding that ...

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Mon, 21 Feb 2005 11:54:16 +0100
Message-ID: <cvcegq$7p1$1@news4.zwoll1.ov.home.nl>

mcode wrote:

> ;-)
> From an ethereal capture between oracle mobile server 10g installer
> and oracle 10g database server... all these on windows platforms.
> 
> 
> Holger Baer <holger.baer_at_science-computing.de> wrote in message news:<cv48ce$ks2$2_at_news.BelWue.DE>...
> 

>>mcode wrote:
>>
>>>Could anyone help me understand this :
>>>
>>>.........4.,......O........"......(DESCRIPTION=(CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=oracle)))(ADDRESS=(PROTOCOL=tcp)(HOST=ora10g.melca.xaymaca.com)(PORT=1521))).A.......7(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.10)(PORT=3230))
>>>
>>>What is the port 3230 needed for ?
>>>
>>>Thank you
>>
>>After people have been shooting a lot in the dark, it would help matters
>>no end if you'd care to tell where you got that line from.
>>
>>Cheers,
>>Holger

Well, that's the way Oracle establishes connections: There is a listener (on port 1521 as default), and when a connection is requested, another process is started, and handed off when a connection is established on a random port. The listener is then available for new requests.

If you want a firewall rule, you must check the contents of the packages, and see if there is SQL; if not, drop the packets. This is called a SQL aware firewall, and is available commercially.

The alternative, the use of fixed ports, can be achieved by using the SHARED_SOCKET environment variable, or connection manager.

-- 
Regards,
Frank van Bortel

Received on Mon Feb 21 2005 - 04:54:16 CST