Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: *NEWBIE* Help needed for decoding that ...
Thank you it's ok now but my server and client are very non-stable...
I have to reboot my server many times... Once a client is connected
then if I need another client to connect then sometimes it works fine
but sometimes everything seems blocked...
Anyway, this may be a network problem on my environment.
I'll let you here now how my investigation goes ... ;-)
I'm actually working on a (free) PDF paper explaining all these details around Oracle Lite 9/10 for students...
Frank van Bortel <fvanbortel_at_netscape.net> wrote in message news:<cvcegq$7p1$1_at_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.
Received on Tue Feb 22 2005 - 07:48:09 CST