I ran into this same issue and found a metalink article to get arount it.
You must apply the 8.1.7.4 patch and then set a registry or environment
variable USE_SHARED_SOCKETS = TRUE. This will force oracle to use the same
port (1521) when your users / processes connect.

Hope this helps.
Will

----- Original Message -----
From: "Jerome LeBoz "
<oracledba-ezmlmshield-x10539661.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Friday, July 16, 2004 6:08 AM
Subject: Firewall and dblink


> Hello,
>
> I've got 2 DBs. DB1 has a product table with a trigger on insert. When the
> trigger is fired, the data is inserted in product table in DB2. It works
now
> as the 2 DBs are inside the same firewall.
> Now I need to "separate" my DBs i.e. set them inside 2 different
firewalls.
>
> I'm using 1521 for the listener and a Dedicated Server Mode (running
> 8.1.7.0). But once connected using the listener I guess the port used to
> communicate is dynamically given by the listener to the user (DB1)
> connected.
>
> Given that which port should I open on the firewalls so the dblink is
still
> working ?
>
> Any help is greatly appreciated.
> Regards,
> Jerome.
>
> _________________________________________________________________
> Dialoguez en direct et gratuitement avec vos amis sur
> http://g.msn.fr/FR1001/866 MSN Messenger !
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
terms:http://www.lazydba.com/legal.html
>


Oracle LazyDBA home page