Re: tcp ip oracle port(s)

Cippalippa99 wrote:

> Hello.
>
> First: sorry for bad english
>
> I have a asp application in a network at address 192.168.1.1 /
> 255.255.255.0 and a oracle server in 192.168.2.1 / 255.255.255.0
>
> A linux firewall in middle whit iptables.
>
> If firewall is down the application run, if firewall is up the
> application don't work.
>
> I have open 1521 and related port but it's not sufficent.
>
> Can you help me ?? Which tcp / udp port i've forgot ??
>
> Many tanks
>

Hi

You forgot to mention Oracle version + Operating system make/version. If your Oracle server is a windows NT/2000, then oracle listener resolves the client connection back to client to run on random port above ~1000. If your firewall is only open on port 1521 - you get ora-03113 end of communication or similar error, because the connection is redirected to any port (-1521) above 1000 on listener ip address (192.168.2.1 in your case).
Solve this by setting USE_SHARED_SOCKET as system environment variable or in the registry (check metalink - search use_shared...). Restart the windows server. Do not rely on the address/port shown in the listener.log, if shared socket is in use the port number doesn't apply! That is the address the listener *would* use, but the client thread to be spawned 'sees' the use_shared_socket environment variable and uses listener port address (1521 in your case). Try netstat from command prompt or similar.

rgds Received on Wed Aug 07 2002 - 14:05:01 CDT