Listener Configuration

Network Configuration
Listener Configuration:
The listener is a separate process that resides on the server. It receives incoming client connection requests and manages the traffic of these requests to the server. A listener is configured with one or more listening protocol addresses and service information about the destination service.
Protocol addresses are configured in the listener configuration file, $ORACLE_HOME/network/admin/listener.ora.
The sample listener configuration is

LIWIPVA2 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = cof1s071)(PORT = 1546))
(ADDRESS = (PROTOCOL = TCP) (HOST = 10.153.231.90) (PORT = 1546))
)
)
SID_LIST_LIWIPVA2 =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = WIPVA2)
(ORACLE_HOME = /pkg/COBL/COBLpo05/home/oracle/product/10.2.0/Db_1)
(SID_NAME = WIPVA2)
)
)
SUBSCRIBE_FOR_NODE_DOWN_EVENT_LIWIPVA2=OFF


TNSNAMES Configuration:

The tnsnames.ora file contains client side network configuration parameters. It can be found in the ORACLE_HOME/network/admin or ORACLE_HOME/net80/admin directory on the client.
Here is an example of a tnsnames.ora file

WIPVA2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = cof1s071)(PORT = 1546))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = WIPVA2)
)
)

Sqlnet.ora Configuration:

The sqlnet.ora file contains client side network configuration parameters. It can be found in the ORACLE_HOME/network/admin or ORACLE_HOME/net80/admin directory on the client. This file will also be present on the server if client style connections are used on the server itself.
Here is an example of an sqlnet.ora file

# SQLNET.ORA Network Configuration File: C:\Oracle\817\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
NAMES.DEFAULT_DOMAIN = WORLD