220 likes | 478 Views
Configuring the Listener. Configuration Overview (1/2). 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, listener.ora.
E N D
Configuration Overview (1/2) • 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, listener.ora. • Service information may or may not be configured in the listener.ora file: • An Oracle release 8.1 does not require configuration in the listener.ora file. • If you use Oracle Enterprise Manager to manage an Oracle8i database, service configuration is required in the listener.ora file. • Other services, including an Oracle7 or Oracle8 release 8.0 database and the Oracle Enterprise Manager management tools, require service configuration in the listener.ora file.
Configuration Overview (2/2) • Once the listener is configured, the listener may be managed with the Listener Control Utility (LSNRCTL).
Default Listening Protocol Addresses • The listener has a default name of LISTENER and is configured to listen on the following default protocol addresses: • TCP/IP protocol on port 1521 • (address=(protocol=tcp)(host=host_name)(port=1521)) • IPC protocol • (address=(protocol=ipc)(key=PNPKEY))
Configuration During Installation • After a Typical or Minimal installation on the server, Net8 Configuration Assistant automatically configures a listener with a name of LISTENER for an Oracle8i database using the TCP/IP protocol. • After a Custom installation, Net8 Configuration Assistant prompts you to configure a listener name and a protocol address of your choice. • Additionally, a listening address for external procedures using the IPC protocol is automatically configured, regardless of the installation type. • Net8 Configuration Assistant also automatically configures service information for the Oracle8i database and the external procedures in the listener.ora file.
Re-Starting the Listener After a listener.ora File Modification • Anytime the listener.ora is modified, the listener must be stopped and re-started with the LSNRCTL utility. • To start or stop the listener: • LSNRCTL • LSNRCTL> start|stop [listener_name] • listener_name is the name of the listener defined in the listener.ora file. • It is not necessary to identify the listener if you are using the default listener, named LISTENER.
Configuring Listener Protocol Addresses (1/2) • Start Net8 Assistant • In the navigator pane, expand Local > Listeners. • Select a listener. • If a listener has never been created: • Click "+" from the toolbar or select Create from the Edit menu. • Enter a unique listener name in the Choose Listener Name dialog box.
Configuring Listener Protocol Addresses (2/2) • From the list in the right pane, select Listening Locations. • Click Add Address. A new address tab appears. • Select a protocol and enter the appropriate protocol parameter information for the selected protocol. • When configuring the listener to listen on TCP/IP, you should choose the default port or 1521. If you do not, you must configure the LOCAL_LISTENER parameter in the initialization parameter file and resolve the listener name through a naming method. • If your machine has more than one IP address and you want the listener to listen on all available IP addresses, configure TCP/IP or TCP/IP with SSL and enter the host name of the machine in the Host field. • Choose File > Save Network Configuration.
Configuring Listening Addresses for Oracle8i JServer • Start Net8 Assistant: • In the navigator pane, expand Local > Listeners. • Select a listener. • From the list in the right pane, select Listening Locations. • Click Add Address. A new address tab appears. • Select the TCP/IP or TCP/IP with SSL protocol from the Protocol list. • Enter the host name of the database in the Host field. • Enter port 2481 if the chosen protocol is TCP/IP in the Port field, or enter port 2482 if the chosen protocol is TCP/IP with SSL in the Port field. • Click "Dedicate this endpoint to IIOP connections". • Choose File > Save Network Configuration.
Configuring a Listener that Uses a Non-Default Address • By default, the PMON process registers with the local listener on the default local address of TCP/IP on a port 1521. • If you want to register information with another listener, you must configure the LOCAL_LISTENER parameter in the initialization parameter file in order for PMON to register information with it. • The value for LOCAL_LISTENER must then be resolved with a net service name entry in the tnsnames.ora file or an Oracle Names server.
Configuring the LOCAL_LISTENER Parameter • The LOCAL_LISTENER parameter should be configured as follows in the initialization parameter file: • local_listener=listener_name_alias
Configuring a Naming Method • tnsnames.ora File • A net service name entry should be created for the listener address without the CONNECT_DATA portion of the connect descriptor. • Net8 Assistant does not enable you to configure a tnsnames.ora file without the CONNECT_DATA information. • Therefore, Oracle Corporation recommends that you modify the tnsnames.ora file manually. • For example, if LOCAL_LISTENER is set to LISTENER1 and LISTENER1 uses TCP/IP on port 1421, the entry in the tnsnames.ora file would look like: • listener1= (address=(protocol= tcp)(host= sales-server)(port= 1421))
Handling Large Volumes of Connection Requests (1/2) • If you expect the listener to handle large volumes of connection requests, you may specify a queue for the process. • To specify a queue size for a listener, enter a value to the QUEUESIZE parameter at the end of any listening address: • listener= (address= (protocol= tcp) (host= sales-server) (port= 1521) (queuesize=20))
Handling Large Volumes of Connection Requests (2/2) • Currently, you can configure only the queue size for listeners operating on TCP/IP and DECnet. • The default queue size is system specific. • On Solaris, the default queue size is set to 5. • The queue size is 5 for Windows NT 4.0 Workstation and 50 for Windows NT 4.0 Server.
Configuring Static Service Information • Start Net8 Assistant • In the navigator pane, expand Local > Listeners. • Select a listener. • From the list in the right pane, select Database Services. • Click Add Database. A new database tab appears. • Enter the global database name, location of the Oracle home directory, and the Oracle System Identifier (SID) of the instance in the appropriate fields. • Choose File > Save Network Configuration.
Configuring Prespawned Dedicated Servers • Oracle Corporation recommends that you use MTS rather than prespawned dedicated server to solve performance and scaleability problems. • Prespawned dedicates servers are not available for Windows NT.