Re: Connectivity problem : client with NAT 1-1

You are going to have to use Oracle Connection manager. Look up Note 90707.1 on Metalink. It can handle the address translation.

"--- YURYSSG ---" <yuryssg_at_yahoo.it> wrote in message news:<fy529.16106$C8.13436_at_tornado.fastwebnet.it>...
> I have a PC in a 'Housing farm' with a Client Oracle 8.17, this PC has a NAT
> 1-1 (on Internet is seen as x.x.x.x, in internal 'housing farm' net as
> y.y.y.y). The Oracle 8.17 server (placed in my company) has a NAT 1-1 (on
> Internet a.a.a.a, in my company internal net b.b.b.b)
>
> I am not able to have Client/server communicated ... and I have never had
> problems with other 'Housing farm' without NAT 1-1
>
> The Client signals me ORA-12535 (Connect Timeout), on the Log of the Server
> Listener for every attempt I find a TNS-12502 series (No Connect_data Was
> Passed To The Listener).
>
> Client TNSnames.ora and Server Listener.ora seems OK (see below),
> suggestions ?
>
>
>
> ======TNSnames.ora (client) ==============
> orcl =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = a.a.a.a (PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = orcl)
> )
> )
> ==============================
>
>
> =======listener.ora (server) ===============
> LISTENER =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
> )
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = b.b.b.b )(PORT = 1521))
> )
> )
> (DESCRIPTION =
> (PROTOCOL_STACK =
> (PRESENTATION = GIOP)
> (SESSION = RAW)
> )
> (ADDRESS = (PROTOCOL = TCP)(HOST = b.b.b.b )(PORT = 2481))
> )
> )
>
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = PLSExtProc)
> (ORACLE_HOME = D:\new817)
> (PROGRAM = extproc)
> )
> (SID_DESC =
> (GLOBAL_DBNAME = orcl)
> (ORACLE_HOME = D:\new817)
> (SID_NAME = orcl)
> )
> )
> =======================
>
> --
Received on Wed Aug 21 2002 - 20:37:27 CEST