TNSPING over router with NAT

From: Alex <alex_at_solnet.ch>
Date: Mon, 20 Jun 2005 20:17:00 +0200
Message-ID: <u81eb1tmjq231i4rajvfkjvorj6de42d2r@4ax.com>

Our Oracle server has the address 192.168.10.60. The remote client is on another subnet and sees the Oracle server on the NATed address 192.168.15.60. The router does not filter ports.

Now, the TNSPING from the remote client gives:

ORA-12560: TNS:protocol adapter error

Please help.

Here is the detailed tracing:

===========Tracing=============
TNS Ping Utility for 32-bit Windows: Version 10.1.0.2.0 - Production on 10-JUN-2005 08:36:46

Copyright (c) 1997, 2003, Oracle. All rights reserved.

• TRACE CONFIGURATION INFORMATION FOLLOWS --- New trace stream is C:\Programme\Oracle\tnsping.trc New trace level is 6
• TRACE CONFIGURATION INFORMATION ENDS ---
• PARAMETER SOURCE INFORMATION FOLLOWS --- Attempted load of system pfile source C:\Programme\Oracle\sqlnet.ora Parameter source loaded successfully

 -> PARAMETER TABLE LOAD RESULTS FOLLOW <- Successful parameter table load
 -> PARAMETER TABLE HAS THE FOLLOWING CONTENTS <-   TNSPING.TRACE_LEVEL = admin
  NAME.DEFAULT_ZONE = world
  TRACE_LEVEL_CLIENT = ADMIN
  NAMES.DIRECTORY_PATH = (TNSNAMES)
  TNSPING.TRACE_DIRECTORY = C:\Programme\Oracle   NAMES.DEFAULT_DOMAIN = world
--- PARAMETER SOURCE INFORMATION ENDS ---

• LOG CONFIGURATION INFORMATION FOLLOWS --- Log stream will be "standard output" Log stream validation not requested
• LOG CONFIGURATION INFORMATION ENDS ---

nnfun2awanm: entry
nnfgiinit: entry
nncpcin_maybe_init: first request sent to name server will have ID 0 nncpcin_maybe_init: initial retry timeout for all name servers is 1500 csecs

nncpcin_maybe_init: max request retries per name server is 1
nngsini_init_streams: initializing stream subsystem, cache size is 10
nngtini_init_msg: initializing PDU subsystem, initial pool size is 2
nncpcin_maybe_init: default name server domain is world

nnfgiinit: Installing read path
nnfgsrsp: entry
nnfgsrsp: Obtaining path parameter from names.directory_path or native_names.directory_path

nnfgsrdp: entry
nnfgsrdp: Setting path:
nnfgsrdp: checking element TNSNAMES
nnfgsrdp: Path set

nnfun2a: entry
nlolgobj: entry

nnfgrne: entry
nnfgrne: Going though read path adapters
nnfgrne: Switching to TNSNAMES adapter
nnftboot: entry

nlpaxini: entry
nlpaxini: exit

nnftmlf_make_local_addrfile: entry
nnftmlf_make_local_addrfile: construction of local names file failed
nnftmlf_make_local_addrfile: exit

nlpaxini: entry
nlpaxini: exit
nnftmlf_make_system_addrfile: entry
nnftmlf_make_system_addrfile: system names file is C:\Programme\Oracle\tnsnames.ora
nnftmlf_make_system_addrfile: exit
nnftboot: exit
nnftrne: entry
nnftrne: Original name: prod
nnfttran: entry
nnfttran: exit
nnftrne: Using tnsnames.ora address (DESCRIPTION = (ADDRESS_LIST = (ADDRESS
= (COMMUNITY = tcp.world)(PROTOCOL = TCP)(Host = 192.168.15.60)(Port = 1521))) (CONNECT_DATA = (SID = PROD))) for name prod.world nnftrne: exit
nnfgrne: exit
nlolgserv: entry

nnfggav: entry
nnftgav: entry
nnftgav: exit
nnfgfrm: entry
nnftfrm: entry
nnftfrm: exit
nnfgfrm: exit

nlolgserv: exit

nlolgobj: exit
nlolfmem: entry
nlolfmem: exit
nnfun2awanm: Getting the path of sqlnet.ora

nnfun2awanm: Getting the adapter name
nnfun2awanm: exit
nsmal: 212 bytes at 0xd87fb0
nscall: connecting...

nladini: entry
nladini: exit
nladget: entry
nladget: exit

nsc2addr:
(DESCRIPTION=(ADDRESS=(COMMUNITY=tcp.world)(PROTOCOL=TCP)(Host=192.168.15.60 )(Port=1521))(CONNECT_DATA=(SID=PROD)))
nttbnd2addr: entry

nttgetport: entry
nttgetport: port resolved to 1521
nttgetport: exit

nttbnd2addr: using host IP address: 192.168.15.60 nttbnd2addr: exit

nsmal: 536 bytes at 0xd88a60
nsmal: 1632 bytes at 0xd88c80
nsmal: 84 bytes at 0xd88990
nsopen: opening transport...
nttcon: entry
nttcon: toc = 1
nttcnp: entry
ntvlin: entry
ntvllt: entry
ntvllt: tcp.validnode_checking not turned on
ntvllt: exit
ntvlin: exit
nttcnp: Validnode Table IN use; err 0x0
nttcnp: exit

nttcni: entry
nttcni: trying to connect to socket 1868. ntt2err: entry
ntt2err: soc 1868 error - operation=1, ntresnt[0]=530, ntresnt[1]=54, ntresnt[2]=0
ntt2err: exit
nttcni: exit
nttcon: exit
nserror: nsres: id=0, op=65, ns=12560, ns2=0; nt[0]=530, nt[1]=54, nt[2]=0;
ora[0]=0, ora[1]=0, ora[2]=0
nsopen: unable to open transport
nsmfr: 1632 bytes at 0xd88c80
nsmfr: 536 bytes at 0xd88a60
nscall: connecting...
nladget: entry
nladget: exit
nsmfr: 212 bytes at 0xd87fb0
nladtrm: entry
nladtrm: exit
nlse_term_audit: entry
nlse_term_audit: exit
============End of tracing==========

TIA Alex
Swiss Red Cross Received on Mon Jun 20 2005 - 13:17:00 CDT