To be useful, a database must be accessible from computers other than the one on which the database resides.
Oracle supplies
Oracle Net Services for this purpose. Oracle Net consists of a
- listener and
- a set of network adaptors
that allow client software to communicate with Oracle databases using a standard networking protocol such as
TCP/IP .
Oracle Net exists to provide a common interface to client applications that need to connect to an Oracle database.
Applications are written to use Oracle Net, and Oracle Net takes care of dealing with the underlying network protocols that are being used.
Thus, the same client application that runs in a TCP/IP environment can run in an
SPX/IPX environment, in an
LU6.2 environment, and so forth.
This module will show you how to configure Oracle Net so that you can connect to your COIN instance from any computer with
Oracle client software installed.
You will learn about the three key Oracle Net configuration files:
- listener.ora,
- tnsnames.ora, and
- sqlnet.ora.