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 -> Connectivity problem : client with NAT 1-1

Connectivity problem : client with NAT 1-1

From: --- YURYSSG --- <yuryssg_at_yahoo.it>
Date: Thu, 1 Aug 2002 09:30:20 +0200
Message-ID: <fy529.16104$C8.13530@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 Thu Aug 01 2002 - 02:30:20 CDT

Original text of this message

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