Description of Oracle communication protocol TNS

Http://forums.oracle.com/forums/thread.jspa? Threadid = 613450

 

If the communication protocol TNS of Oracle is not completely disclosed to the outside world, it can be used only when it becomes an Oracle Partner and pays a certain fee to Oracle.

 

Jonah H. Harris has made an in-depth research on the Oracle communication protocol, and is committed to parsing the Oracle Communication Protocol to implement its own Oracle driver.

He is on his personal site



Http://www.oracle-internals.com
I have published some articles.

 

The author understands the TNS protocol through packet capture analysis.

 

--------------------------------

 

Oracle's wire-level protocol is proprietary and not publicly encrypted ented. the only way to get a hold of the official specification is to become a partner and pay (what I 've heard is) about $100 K us for access to it. if you want to research the Protocol yourself, there are several online sources of information if you can get the Google keywords just right.

If you're looking for starting information, you can find basic protocol information inDavid Litchfield's Oracle hacker's Handbook

. If you're looking for a bit more detailed code, you can find dissectors for Oracle's protocol fromWireshark

Project (formerly Ethereal):

For TNS (Transparent Network Substrate ):
Http://anonsvn.wireshark.org/wireshark/trunk/epan/dissectors/packet-tns.c

Http://anonsvn.wireshark.org/wireshark/trunk/epan/dissectors/packet-tns.h

For TTI (two-task interface ):
Http://anonsvn.wireshark.org/wireshark/trunk/epan/dissectors/packet-sqloracle.c

Http://anonsvn.wireshark.org/wireshark/trunk/epan/dissectors/packet-sqloracle.h

The wireshark TNS dissector is fairly complete, but the TTI one is far from it.

FYI, I started researching the Oracle protocol in 2001 and now know enough about it to write my own wire-level driver. while I won't release the code to it, in the next couple months you can visit my soon-to-be-fixed website (http://www.oracle-internals.com/
) For more information on the basic protocol.

Also, if you happen to attend ioug's collaborate 08, I'm actually presenting on this topic in particle. The session information resides below:

---

381: listening in: passive capture and analysis of Oracle network traffic
Http://iougew.prod.web.sba.com/displaymod/detailevent.cfm? Conference_id = 52 & event_id = 1666

In this presentation we will discuss and demonstrate the methods for passively capturing, analyzing, and reporting the details of Oracle network traffic in Real-Time for use in end-to-end Oracle tuning and troubleshooting scenarios.

In cases where very short response time requirements must be met, or where sporadic spikes in response time occur, the most reliable way to tune and troubleshoot them is by capturing Oracle's Ethernet traffic, analyzing it, and reporting on various aspects of it. throughout this session we will demonstrate the passive capture of SQL statements, their frequency, time spent in execution, number of roundtrips, and all relevant response times.

Using the data from these reports can not only assist DBAs in diagnosing network-related issues and in tuning Oracle's network settings, but also ensure that application developers are writing tables t, network-friendly database access code.