Redirection packet contains host name instead of IP address

From: Stano <stanov_at_kgt.com.tw>
Date: 3 Jan 2002 05:20:38 -0800
Message-ID: <c0960e91.0201030520.4dd2fef@posting.google.com>

Hi there,

while establishing the connection with a server (Oracle816), an Oracle Client sends to and receives packet(s) from a listener. There are basically 2 types of connections: bequeathed and redirected.

In case of redirected connection, the client sends the connection request:

...

nscon: doing connect handshake...
nscon: sending NSPTCN packet
nspsend: entry
...

nspsend: 230 bytes to transport
nspsend: packet dump
nspsend: 00 E6 00 00 01 00 00 00  |........|
nspsend: 01 36 01 2C 00 00 08 00  |.6.,....|
nspsend: 7F FF A3 0A 00 00 01 00  |........|
nspsend: 00 AC 00 3A 00 00 02 00  |...:....|
nspsend: 01 01 00 00 00 00 00 00  |........|
nspsend: 00 00 00 00 01 5E 00 00  |.....^..|
nspsend: 00 0B 00 00 00 00 00 00  |........|
nspsend: 00 00 28 44 45 53 43 52  |..(DESCR|
nspsend: 49 50 54 49 4F 4E 3D 28  |IPTION=(|
nspsend: 41 44 44 52 45 53 53 3D  |ADDRESS=|
nspsend: 28 50 52 4F 54 4F 43 4F  |(PROTOCO|
nspsend: 4C 3D 54 43 50 29 28 48  |L=TCP)(H|

...

and the listener replies with a redirection packet:

...

nsprecv: reading from transport...

nttrd: entry
nttrd: socket 112 had bytes read=58
nttrd: exit
nsprecv: 58 bytes from transport
nsprecv: tlen=58, plen=58, type=5
nsprecv: packet dump
nsprecv: 00 3A 00 00 05 00 00 00  |.:......|
nsprecv: 00 30 28 41 44 44 52 45  |.0(ADDRE|
nsprecv: 53 53 3D 28 50 52 4F 54  |SS=(PROT|
nsprecv: 4F 43 4F 4C 3D 74 63 70  |OCOL=tcp|
nsprecv: 29 28 48 4F 53 54 3D 70  |)(HOST=p|
nsprecv: 70 74 65 73 74 29 28 50  |ptest)(P|
nsprecv: 4F 52 54 3D 31 31 37 35  |ORT=1175|

nsprecv: 29 29 00 00 00 00 00 00 |))......| nsprecv: normal exit
nscon: got NSPTRD packet
nscon: got 48 bytes connect data
...

where the PORT is redirected to the pre-spawn server process.

My question is: Is there a way to setup the listener (or Oracle) to send back the IP address of the HOST instead of the host name (in this case "pptest") in the redirection packet (NSPTRD) (using O816)?

I have a problem with connecting to Oracle816. If the listener is setup to pre-spawn some server processes and it receives a connection request, it replies with a redirection package including a host name instead of an IP address. This means that DNS server should be adjusted to resolve this name or the clients should change local host files. This does not happen when no server processes are pre-spawned.

I have searched a lot of resources, but could not find any remarks on this problem.

Thank you a lot for sharing any piece of information,

Stano. Received on Thu Jan 03 2002 - 07:20:38 CST