Oracle TNS Packet Decode, Oracle TNS Packet Decode Options

[Maloy Kundu]

Hi All,

First I would like to thak this Burleson Consulting for providing valueable documents and information on Oracle internals .

I am working on Oracle Packet Parsing. I am stuck when I am tring to understand the Packets of TNS Type ID =6 TTI ID = 0x02(Exchange of Data type representations)

I am not able to decode the Data Packet.

0.437308 192.168.1.108 192.168.1.102 TCP kwdb-commn > iax
[PSH, ACK] Seq=823 Ack=589 Win=64947 Len=67
0000 00 0c 29 0c 9a c7 00 0c 29 fd 07 3d 08 00 45 00 ..).....)..=..E.
0010 00 6b 05 15 40 00 80 06 71 55 c0 a8 01 6c c0 a8 .k..@...qU...l..
0020 01 66 04 67 11 d9 0e a7 cd b9 b6 88 7c 6e 50 18 .f.g........|nP.
0030 fd b3 81 e2 00 00 00 43 00 00 06 04 00 00 00 00 .......C........
0040 02 b2 00 b2 00 52 21 06 01 01 01 0d 01 01 04 01 .....R!.........
0050 01 01 01 01 01 01 ff ff 03 08 03 00 01 00 3f 01 ..............?.
0060 07 3f 01 01 01 01 03 01 05 02 01 00 00 18 80 00 .?..............
0070 00 00 3c 3c 3c 80 00 00 00 ..<<<....

Can anyone share me the knowledge.? It would be a great help for me. My need is very urgent..Thanks in advance.

Regards
Maloy Kundu
India

[burleson]

Hi Maloy,

You can reverse-engineer the TNS with a packey sniffer, but beware not to publish it, as it is an Oracle "secret". Besides, the minute you figure it out, it ewill changhe oin the nest release!

In a nutshell, TNS only relates to"

1 - packet_size: This is SDU, TDU, MTU, &v Please read: http://www.dba-oracle.com/art_builder_sqlnet.htm

2 - packet shipment delay! At a look at tcp.nodelay: http://www.dba-oracle.com/oracle10g_tuning/t_tcp_nodelay.htm

*********************************
>> My need is very urgent..

Oh! Call 800-223-1711 IMMEDIATELY.

Urgent calls get top priority.

Oracle is not going to give your their source code, why can this be urgemnt?

How many lives at at stake, and why?

Let us know what Oracle says . . .

[Maloy Kundu]

Hi Maloy,

You can reverse-engineer the TNS with a packey sniffer, but beware not to publish it, as it is an Oracle "secret". Besides, the minute you figure it out, it ewill changhe oin the nest release!

In a nutshell, TNS only relates to"

1 - packet_size: This is SDU, TDU, MTU, &v Please read: http://www.dba-oracle.com/art_builder_sqlnet.htm

2 - packet shipment delay! At a look at tcp.nodelay: http://www.dba-oracle.com/oracle10g_tuning/t_tcp_nodelay.htm

*********************************
>> My need is very urgent..

Oh! Call 800-223-1711 IMMEDIATELY.

Urgent calls get top priority.

Oracle is not going to give your their source code, why can this be urgemnt?

How many lives at at stake, and why?

Let us know what Oracle says . . .

Hi,

Thanks ..You've considered and replied my query with importance. I am using Packet Analyzer and I have understanding of SDU, TDU. I've gone through lot of information on that. It's really very helpful.
But I don't understand how to parse the TNS Packet of type=6(DATA) and TTI ID =0x02. It handles the character set differences (NLS). Could you share bit of clue on that. I will be a great help.

Thanks & Regards
Maloy Kundu
Inddia

[Maloy Kundu]

Hi,

Thanks ..You've considered and replied my query with importance. I am using Packet Analyzer and I have understanding of SDU, TDU. I've gone through lot of information on that. It's really very helpful.
But I don't understand how to parse the TNS Packet of type=6(DATA) and TTI ID =0x02. It is difficult for me to get how the client and server exchange information by looking at the packet. However I am able to get Authentication information exchange by analysing the packet. I've another question on ANO packet. I've no clue, how to parse the byte after the code 0x deadbeef It handles the character set differences (NLS). Could you share bit of clue on that. I will be a great help.

Thanks & Regards
Maloy Kundu
Inddia

[burleson]

Hi Maloy,

Wireshark TNS dissector source code:http://anonsvn.wireshark.org/wireshark/tru...rs/packet-tns.c

http://anonsvn.wireshark.org/wireshark/tru...rs/packet-tns.h


*********************************************************
>> I've no clue, how to parse the byte after the code 0x deadbeef

Deadbeef? Is that one of those sacred cow things?

Again, Oracled DOES NOT PUBLISH THE INTERNALS!

It would contact Oracle technical suport and see if they will share the packet DSECTs:

http://support.oracle.com

[Maloy Kundu]

Hi Maloy,

Wireshark TNS dissector source code:http://anonsvn.wireshark.org/wireshark/tru...rs/packet-tns.c

http://anonsvn.wireshark.org/wireshark/tru...rs/packet-tns.h


*********************************************************
>> I've no clue, how to parse the byte after the code 0x deadbeef

Deadbeef? Is that one of those sacred cow things?

Again, Oracled DOES NOT PUBLISH THE INTERNALS!

It would contact Oracle technical suport and see if they will share the packet DSECTs:

http://support.oracle.com

Hi Mr.Burleson,

I've already gone through the TNS Dissect Code that you mentioned. But it is of little help.

Thanks for your reply. Thanks once again ...The site contains lot of information on Oracle Internals.



Regards
Maloy Kundu
email: maloy.kundu@gmail.com
India