Database Reference
In-Depth Information
Oracle Net takes care of all different types of Network protocols.
Oracle server knows how to communicate with Oracle Net and
Oracle Net knows all different Network languages/protocols
including world famous TCP/IP. The whole internet runs on
TCP/IP protocol based communication and even in LAN (Local
Area Network), WAN (Wide Area Network) etc. TCP/IP is now
a standard.
Protocol is nothing but the “grammar” e.g. right now I am using
English protocol to speak with you and you are understanding
whatever I am saying since I following English grammar by
default. Imagine if I stop following grammar rules than it would
be really impossible for you to understand what I am saying.
Similarly, when two machines (computers) talks with each other,
both of them needs to know the common language and both of
them have to follow the grammar (protocol) of the language
(TCP/IP).
The way it works is first we create the listener.ora file on the
server then we start the listener. The development of listener.ora
file is actually the configuration of Oracle Net for the server.
Once we have started the listener process, it listens to the users
connection requests. The job of the listener process is to
bequeath the connection to the dispatcher in case the Oracle
server is running under shared server mode or to the dedicated
server process in case Oracle is running under dedicated mode.
On the client side, we have to first install the Oracle Net
software layer. It can be done using the same Oracle installation
CD and selecting the option of “client side installation” in Oracle
Universal Installed. Once done we have to create the
tnsnames.ora file. Creating tnsnames.ora file is actually the
configuration of Oracle Net on the client side.
tnsnames.ora is nothing but contains the resolution of “service
name” or “connect string” that we will use to connect to Oracle
server running on the same machine or on some other machine
located in even different country. All the client side (SQL*Plus)
and remote database administration (Oracle Enterprise Manger)
Search WWH ::




Custom Search