Re[2]: using Net8 through NAT router

From: <Kim_Thompson_at_ci.sf.ca.us>
Date: Fri, 14 Dec 2001 16:55:22 -0800
Message-ID: <F001.003DD1A4.20011214161018@fatcity.com>

     
     
     
     

     I would suggest you put on a client trace to see what's getting passed 
     back.  We've had this problem and there's a couple of things that 
     could be happening:
     
     1) A hostname is getting passed back and the client does not know how 
     to interpret the name.  Or the IP address gets translated and passed 
     back to the client, and the client is not able to access that IP 
     address (this happened to us due to changes made to our firewall). 
     (This could show up to the client as a connection time-out ORA-12535, 
     but the client trace would show the underlying error to be ORA-12545 
     'target host or object does not exist').
     
     2) On Windows platforms or if using Oracle MTS, the port gets 
     redirected and that port is blocked.
     
     See Metalink notes 1077367.6, 91554.1, 21479.1, 105713.1, 119706.1, and 
     68652.1.
     
     The trace will show you what's getting passed back to client.  See 
     note 1030488.6 for information on setting up NET8 trace parameters.
     
     Hope this helps,
     
     Kim Thompson
     City and County of San Francisco  
     
     
______________________________ Reply Separator _________________________________

Author: Oliver Artelt <oli_at_md.transnet.de> at ~ctl-internet-po Date: 12/14/01 9:05 AM

     
     
Hi,
     

I'm using a mts-server through an openbsd-firewall (and also nat'ing into the dmz-subnet) without cmgr. There's no problem with that. You should test if your router is proper configured. Check the logfiles or if other services work correctly. Have you bound the public ip of the database server onto the internet-nic of the router or redirect the 1521 onto the machine correctly?      

oli

On Thu, 2001-12-13 at 23:41, dcowles_at_i84.net wrote:
> I am trying to connect to a database on the "inside" of a NAT.
> I get a tns connection time-out error. According to Oracle, I have to use
> Connection Manager. I find this a little hard to believe. I would think a
> CISCO router doing NAT would be smart enough to translate Net8 packet headers
> for me.
>
> Anyone?
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Doug C
> INET: dcowles_at_i84.net
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

Received on Fri Dec 14 2001 - 18:55:22 CST