Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

Oracle

Posted Sep 9, 2002

Listen Software's How To: The Listener Server

By David Nishimoto

Configuration Files


Server Client
listener.orasqlnet.ora
names.oratnsnames.ora
sqlnet.oratnsnav.ora
tnsnames.ora


Listener.ora

Includes the service names and addresses of all listeners on a machine, the SIDs for the databases they listen for, and various control parameters used by the listener.


listener_name
Port 1521
Protocols TCPIP and IPC
SID
Hostname
ADDRESS_LIST Contains a block of addresses at which the listener will listen for incoming connections
CONNECT_TIMEOUT_listener_name Number of seconds to get a valid DB query
LISTENER_address
LOG_DIRECTORY_listener_name
LOG_FILE_listener_name
LOGGING_listener_name
PASSWORDS_listener_name
SAVE_CONFIG_ON_STOP_listener_name


Oracle Name Server

Using the Oracle Name server, the clients do not need to know where the database is located. The only requirement is for the client to know the address of the name server. When the user wants a connection, Net 8 connects to the name server, resolves the address, and connects to the address given by the name server.


Connecting to the Server

The client uses both the tnsnames.ora file and the sqlnet.ora file to make a connection with the server. TNSNames contains the names of services on the network; whereas, sqlnet.ora contains client profile information and Oracle Name Servers if used.

The server uses the listener.ora file to create services that listen for connection requests. The listener service responds to incoming requests by routing them to the appropriate instance. The listener server uses the listener.ora file to boot and configure one or more listeners. A listener service after routing the connection is ready to respond to the next request for information (service name to connection descriptor).

The listener spawns a new process or redirects the connection to an existing process. Now the listener is no longer involved.


LSNRCTL


QUIT
RELOAD
SAVE_CONFIG
SERVICES
SET SET CONNECTION_TIMEOUT, SET CURRENT_LISTENER, SET PASSWORD, SET LOG_DIRECTORY, SET LOG_FILE, SET SAVE_CONFIG_ON_STOP, SET STARTUP_WAITTIME
START listener_name
STOP listener_name


Back to the LSS "How To" Series Main Page




Oracle Archives

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




Latest Forum Threads
Oracle Forum
Topic By Replies Updated
Oracle Data Mining: Classification jan.hasller 0 July 5th, 07:19 AM
Find duplicates - Unique IDs Lava 5 July 2nd, 08:30 AM
no matching unique or primary key rcanter 1 April 25th, 12:32 PM
Update values of one table based on condition of values in other table using Trigger Gladiator 3 February 29th, 06:01 PM


















Thanks for your registration, follow us on our social networks to keep up-to-date