Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: *NEWBIE* Help needed for decoding that ...

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

From: mcode <microcode2004_at_hotmail.com>
Date: 22 Feb 2005 05:48:09 -0800
Message-ID: <480bd64a.0502220548.2134aade@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US