Re: Redirection packet contains host name instead of IP address

On 3 Jan 2002 05:20:38 -0800, stanov_at_kgt.com.tw (Stano) wrote:

>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.

You shouldn't use IP adresses. The IP-address is resolved by Oracle *only once*, and there is no way to setup the listener to send back ip addresses.
I would concentrate on getting DNS correct instead of trying to find a hack.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Jan 03 2002 - 11:48:12 CST