CMAN and NAT. What's wrong?

From: Dim Gool <moution_at_rambler.ru>
Date: Fri, 19 Sep 2003 15:21:36 +0300
Message-ID: <bkeos4$mlli$1@ID-206880.news.uni-berlin.de>

Kindly people!

Well, I has launch CMAN at Oracle9, and I expect that decision can to solve problem
with connection through NAT to Oracle 7.2 servers(in MTS mode). It work correctly in internal network.
But when I try to connect via CMAN from external IP with CMAN, connection can't be establish.
In trace file I found:
...

nridst: exit
nric2a: This is a local community access
nric2a: exit

nricall: Got routable address information nricall: Making call with following address information: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=150.1.1.2)(PORT=1521))(CONNECT_DAT A=(SID=A)(SOURCE_ROUTE=YES)(CID=(PROGRAM=PLUS33.exe)(HOST=host1)(USER=user1) ))(ADDRESS=(PROTOCOL=TCP)(HOST=10.17.2.71)(PORT=1630))) nricdt: entry
nricdt: Calling with outgoing connect data (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.17.2.71)(PORT=1630))(ADDRESS=(P ROTOCOL=TCP)(HOST=150.1.1.2)(PORT=1521))(CONNECT_DATA=(SID=A)(SOURCE_ROUTE=Y ES)(CID=(PROGRAM=PLUS33.exe)(HOST=host1)(USER=user1)))) nscall: entry
nscall: connecting...
nsc2addr: entry
nsc2addr:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=150.1.1.2)(PORT=1521))(CONNECT_DAT A=(SID=A)(SOURCE_ROUTE=YES)(CID=(PROGRAM=PLUS33.exe)(HOST=host1)(USER=user1) ))(ADDRESS=(PROTOCOL=TCP)(HOST=10.17.2.71)(PORT=1630))) nttbnd2addr: entry

attention! here is an internal network IP.

nttbnd2addr: port resolved to 1521
nttbnd2addr: using host IP address: 150.1.1.2
nttbnd2addr: exit

nsc2addr: normal exit
nsopen: entry

nsmal: entry
nsmal: 452 bytes at 0x647db0
nsmal: normal exit
nsopen: opening transport...
nttcon: entry
nttcon: toc = 1
nttcnp: entry
ntvlin: entry
ntvllt: entry
ntvllt: No PROTOCOL.ORA file is found
ntvllt: exit
ntvlin: exit
nttcnp: Validnode Table IN use; err 0x0
nttcnp: creating a socket.
nttcnp: exit

nttcni: entry
nttcni: trying to connect to socket 444. ntt2err: entry
-<ERROR>- ntt2err: soc 444 error - operation=1, ntresnt[0]=511, ntresnt[1]=61, ntresnt[2]=0
ntt2err: exit
nttcni: exit
nttcon: exit
nserror: entry
-<ERROR>- nserror: nsres: id=0, op=65, ns=12541, ns2=12560; nt[0]=511, nt[1]=61, nt[2]=0
-<ERROR>- nsopen: unable to open transport

nsmfr: entry
nsmfr: 452 bytes at 0x647db0
nsmfr: normal exit
nsopen: error exit

nscall: error exit
nricdt: Call failed...
...
But I suppouse, that the CMAN make connection itself, and itself interact with listener on destination server,
and I will interact only with CMAN, not with destination server directly. Is it wrong?

Here is my TNSNAMES:

SUN=
  (DESCRIPTION=
  (ADDRESS=
(PROTOCOL=TCP)
(HOST=10.17.2.71)
(PORT=1630)

  )
  (ADDRESS=(PROTOCOL=TCP)
(HOST=150.1.1.2)
(PORT=1521)

  )
(CONNECT_DATA=(SID=A)
(SOURCE_ROUTE=YES)

   )

When I check for listener with tnsping directly to destination server using NAT , all right.

Thank you for help! Received on Fri Sep 19 2003 - 07:21:36 CDT