cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle Wire Protocol

SOLVED
Go to solution
Shivkumar
Super Advisor

Oracle Wire Protocol

what is the use of wire protocol ? Does it run over tcp/ip ?
7 REPLIES
Chan 007
Honored Contributor

Re: Oracle Wire Protocol

I seen web based programmers used to tell SAs this thing.

Yes u r right, it binds to the TCP/IP suite
via http.

For more details

http://java.sun.com/j2se/1.4.2/docs/guide/jpda/jdwp-spec.html

Chan
Indira Aramandla
Honored Contributor
Solution

Re: Oracle Wire Protocol

Hi Shivkumar,


A DBMS is written using an application programming interface (API), which is specific to that database. For example, an Oracle 9i database has its own version of the API specification (called Net9), which must run on each client application.

Developers write applications compliant to the ODBC specification and use ODBC drivers to access the database. The ODBC driver communicates with the vendor's native API. Then, the native API passes instructions to another vendor-specific low-level API. Finally the wire protocol API communicates with the database

The wire protocol architecture eliminates the need for the database's native API (for example, Net9), so the driver communicates directly to the database through the database's own wire level protocol. This effectively removes an entire communication layer



Indira A
Never give up, Keep Trying
Arunvijai_4
Honored Contributor

Re: Oracle Wire Protocol

Hi Shiv,

Some links that should shed light for you,

http://media.datadirect.com/download/docs/odbc/odbcref/oracle.html
http://forums.datadirect.com/ddforums/thread.jspa?messageID=3663

-Arun
"A ship in the harbor is safe, but that is not what ships are built for"
Steven E. Protter
Exalted Contributor

Re: Oracle Wire Protocol

Shalom Shiv,

The articles above define this as ODBC access. This is the least desireable of the possible Oracle access methods. ODBC is more likely to have support and performance issues than oracle client for example.

Yes, it runs TCP/IP.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Arunvijai_4
Honored Contributor

Re: Oracle Wire Protocol

Hi Shiv,

SOAP is also a wire protocol like IIOP for CORBA, ORPC for DCOM, or Java Remote Method Protocol (JRMP) for Java Remote Method Invocation (RMI). I think, Oracle uses SOAP and XML in 9i. It runs on TCP/IP Layer.

http://www.javaworld.com/javaworld/jw-03-2001/jw-0330-soap.html

-Arun
"A ship in the harbor is safe, but that is not what ships are built for"
Shivkumar
Super Advisor

Re: Oracle Wire Protocol

What is the word "wire" stands for with respect to this technologies ? Thanks.
Yogeeraj_1
Honored Contributor

Re: Oracle Wire Protocol

hi shiv,

In fact, Wire refers to the IP protocol.

When referring to data path over WAN, IP, the protocol that is actually on the wire, does not care which path the PDU takes, nor does it care what order the PDUs arrive. With multiple paths to it's destination, a TCP/IP "conversation" may use all the paths at once,
and the client will have to reassemble that "conversation." This will add to the delay.

the above is an extract from metalink note:
Note:1005123.6 - Tuning SQL*Net for better performance


hope this helps!

kind regards
yogeeraj


No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)