Oracle on LINUX: MTS connection impossible?

From: <rtgraf_at_sintec.de>
Date: Mon, 18 May 1998 12:30:15 GMT
Message-ID: <6jp9kn$u67$1@nnrp1.dejanews.com>

Hi,

we are using RedHat Linux 5.0 w/Kernel 2.0.31 and Oracle7 Server Version 7.3.2 for SCO Unix.

We would like to connect via SQL*Net V2.3 and want to use the Mulithreaded Server configuration. Our config files seem to be ok, we tested everything under Oracle 7.3 and Sun SOLARIS where everything worked fine.

The Listener responds fine to TNSPING and we can connect with SERVER=DEDICATED. If we try to connect via MTS, we get an ORA-12203 "Unable to connect to destination" Tracing reveals:

[SNIP]
Making call with following address information: (DESCRIPTION=(CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=PLUS33.EXE)(HOST=Windows NT PC)(USER=jhkoza)))(ADDRESS=(COMMUNITY=tcp.world)(PROTOCOL=TCP)(Host=192.168.2. 67)(Port=1526)))
Calling with outgoing connect data
(DESCRIPTION=(CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=PLUS33.EXE)(HOST=Windows NT PC)(USER=jhkoza)))(ADDRESS_LIST=(ADDRESS=(COMMUNITY=tcp.world)(PROTOCOL=TCP)(H ost=192.168.2.67)(Port=1526))))
connecting...
(DESCRIPTION=(CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=PLUS33.EXE)(HOST=Windows NT PC)(USER=jhkoza)))(ADDRESS=(COMMUNITY=tcp.world)(PROTOCOL=TCP)(Host=192.168.2. 67)(Port=1526)))
port resolved to 1526
using host IP address: 192.168.2.67
opening transport...
[SNIP]
doing connect handshake...
sending NSPTCN packet
238 bytes to transport
68 bytes from transport
got NSPTRD packet
redirected
no timer allocated
closing transport
global context check-out (from slot 0) complete connecting...
(ADDRESS=(PROTOCOL=tcp)(DEV=9)(HOST=127.0.0.1)(PORT=1116)) port resolved to 1116
using host IP address: 127.0.0.1
opening transport...
trying to connect to socket 144.
-<ERROR>- soc 144 error - operation=1, ntresnt[0]=511, ntresnt[1]=61,
ntresnt[2]=0
-<ERROR>- nsres: id=0, op=65, ns=12541, ns2=12560; nt[0]=511, nt[1]=61,
nt[2]=0
-<ERROR>- unable to open transport

Call failed...
Call made to destination
Processing address list so continuing
Getting local community information
Looking for local addresses setup by nrigla No addresses in the preferred address list TNSNAV.ORA is not present. No local communities entry. Getting local address information
Address list being processed...
Processed all addresses in address list. Failed to make contact.

Result descriptor: 12203,12541,511,61
Result descriptor: 12224,12541,511,61 from Interchange:
Result descriptor: 12222,12538,508,0 from Interchange:

Exiting NRICALL with following termination result -1
-<ERROR>- error from nricall
-<ERROR>- nr err code: 12203
-<ERROR>- ns main err code: 12541
-<ERROR>- ns (2) err code: 12560
-<ERROR>- nt main err code: 511
-<ERROR>- nt (2) err code: 61
-<ERROR>- nt OS err code: 0
-<ERROR>- Couldn't connect, returning 12203
[End of Trace File]

My interpretation is: When redirecting the incoming request to the MTS-Server, the listener uses the wrong IP-Adress (127.0.0.1), the Client tries to connect to his *own* IP-Adress, where he surely can't find a Listener (TNS-12541: "No Listener")

Another strange phenomenon: If the listener runs a few minutes, even the connection via Dedicated server won't work. We also experience similar problems under S.u.S.E Linux 5.0 w/Kernel 2.0.32.

Can anybody help? (Oracle won't, as we all know :`-O ).

Thanx, rgw

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Mon May 18 1998 - 07:30:15 CDT