Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> Oracle TNS Packet Decode, Oracle TNS Packet Decode
Maloy Kundu
post Jan 23 2012, 06:35 AM
Post #1


Newbie
*

Group: Members
Posts: 4
Joined: 23-January 12
Member No.: 46,636



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
Go to the top of the page
 
+Quote Post
burleson
post Jan 23 2012, 07:18 AM
Post #2


Advanced Member
***

Group: Members
Posts: 11,634
Joined: 26-January 04
Member No.: 13



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


--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post
Maloy Kundu
post Jan 24 2012, 06:18 AM
Post #3


Newbie
*

Group: Members
Posts: 4
Joined: 23-January 12
Member No.: 46,636



QUOTE (burleson @ Jan 23 2012, 07:18 AM) *
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
Go to the top of the page
 
+Quote Post
Maloy Kundu
post Jan 24 2012, 06:20 AM
Post #4


Newbie
*

Group: Members
Posts: 4
Joined: 23-January 12
Member No.: 46,636



QUOTE (Maloy Kundu @ Jan 24 2012, 06:18 AM) *
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
Go to the top of the page
 
+Quote Post
burleson
post Jan 24 2012, 11:31 AM
Post #5


Advanced Member
***

Group: Members
Posts: 11,634
Joined: 26-January 04
Member No.: 13



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





--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post
Maloy Kundu
post Jan 25 2012, 11:31 PM
Post #6


Newbie
*

Group: Members
Posts: 4
Joined: 23-January 12
Member No.: 46,636



QUOTE (burleson @ Jan 24 2012, 11:31 AM) *
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
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 31st October 2014 - 08:28 AM