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.
|Protocols||TCPIP and IPC|
|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|
Oracle Name ServerUsing 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 ServerThe 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.
|SET||SET CONNECTION_TIMEOUT, SET CURRENT_LISTENER, SET PASSWORD, SET LOG_DIRECTORY, SET LOG_FILE, SET SAVE_CONFIG_ON_STOP, SET STARTUP_WAITTIME|
Back to the LSS "How To" Series Main Page