Re: Problem connecting via Firewall utilizing CMAN

Hi,

   I think that the problem could split in two different ones 1) the firewall must open the port 1610 between DMZ and LAN 2) oracle on windows by default does not use port sharing, so it will dynamically allocate a new tcp port for the connection making hard to establish connection. Did to try the parameter USE_SHARED_SOCKET=TRUE? You can find more details on metalink note 124140.1. Hope it helps
Giovanni

> Hi all
>
> SERVER 1 (LAN)
> - Windows 2003 Server
> - Oracle 9.2.0.6
> - CMAN 9.2.0.1 (on port 1610)
>
> SERVER 2 (LAN)
> - Windows 2000 Server
> - Client Oracle 9.2.0.1
>
> SERVER 3 (DMZ)
> - Windows 2000 Server
> - Client Oracle 9.2.0.1
>
> CONNECTION 2 to 1 : everytime OK
>
> CONNECTION 3 to 1 via Firewall (port 1610 and 1521 open) : sometimes OK,
> sometimes NOT
>
> Why when I connect from 3 to 1 sometimes works and sometimes (after reboot)
> doesn't work?
>
> When it doesn't work:
> - TNSPING work
> - TELNET on 1610 work
> - Entry in listener.ora : 28-SEP-2005 14:24:55 * (CONNECT_DATA=
> (SERVER=DEDICATED)(SID=TSIPACK)(CID=(PROGRAM=D:\oracle\ora92\bin\sqlplus.exe)
> (HOST=XLIPACK)(USER=ebs4))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.0.0.254)
> (PORT=7399)) * establish * TSIPACK * 0
>
> cman.ora
> CMAN =
> (ADDRESS = (PROTOCOL = TCP)(HOST = 10.3.0.3)(PORT = 1610))
>
> CMAN_PROFILE = (PARAMETER_LIST=
> (MAXIMUM_RELAYS=128)
> (LOG_LEVEL=2)
> (TRACING=no)
> (RELAY_STATISTICS=no)
> (REMOTE_ADMIN=no)
> (SHOW_TNS_INFO=no)
> (USE_ASYNC_CALL=yes)
>
> )
>
> Thanks
>
> Fudo
Received on Wed Sep 28 2005 - 07:57:42 CDT