Control parameters allow you to specify various aspects of listener behavior. For example, you can control the directories and filenames used for log files and trace files. Most of these parameters are simple name /value pairs, and they are listed here in alphabetical order.
CONNECT_TIMEOUT_listener_name |
CONNECT_TIMEOUT_ listener_name = seconds |
Specifies the number of seconds that the listener waits once a connection request has been started. This wait usually involves the time needed to redirect the client's connection to a different port. If the redirect fails for some reason, the timeout causes the connect operation to terminate. The default value is 10 seconds. A value of 0 specifies an infinite timeout.
Example
CONNECT_TIMEOUT_PRODLISTENER = 10
LOG_DIRECTORY_listener_name |
LOG_DIRECTORY_ listener_name = directory_path |
Specifies the directory to which the listener's log file should be written. The default log directory is $ORACLE_HOME /network /log .
Examples
LOG_DIRECTORY_PRODLISTENER = /s01/app/oracle/product/8.1.5/network/log LOG_DIRECTORY_PRODLISTENER = E:\Oracle\Ora81\NETWORK\LOG
LOG_FILE_ listener_name = directory_path |
Specifies the name to use for the listener's log file. The default filename is listener.log .
Examples
LOG_FILE_PRODLISTENER = PRODLISTENER.LOG LOG_FILE_DEVLISTENER = DEVLISTENER.LOG
LOGGING_ listener_name = {ON OFF} |
Controls whether or not a listener even generates a log file. The default value is ON.
Examples
LOGGING_PRODLISTENER = ON LOGGIN_DEVLISTENER = OFF
PASSWORDS _listener_name = (password [,password...]) |
Specifies one or more passwords for a listener. The passwords are not encrypted. All passwords are equally usefulany one may be used to control the listener. See Chapter 4 for detailed information on password protecting a listener.
| If you are specifying just one password, you can omit the parentheses. | |
Examples
PASSWORDS_PRODLISTENER = (MYPASSWORD, YOURPASSWORD, THEIRPASSWORD) PASSWORDS_DEVLISTENER = ONLYONEPASSWORD
SAVE_CONFIG_ON_STOP_listener_name |
SAVE_CONFIG_ON_STOP_ listener_name = {TRUE FALSE} |
Specifies whether or not a listener should save its current configuration back to the listener.ora file when you use the Listener Control utility's STOP command to stop the listener. The default value is FALSE. Use TRUE if you do want the configuration to be saved automatically.
| Be aware that there are cases where SAVE_CONFIG_ON_STOP does not work. If the listener is killed from the operating-system prompt, or if you stop a Windows NT listener by shutting down its associated Windows NT service, the configuration is not saved. See Chapter 4 for more information on this feature. | |
Examples
SAVE_CONFIG_ON_STOP_PRODLISTENER = TRUE SAVE_CONFIG_ON_STOP_DEVLISTENER = FALSE
STARTUP_WAIT_TIME_listener_name |
STARTUP_WAIT_TIME_ listener_name = seconds |
Allows you to specify a delay, in seconds, between the time that a listener starts and the time at which it begins accepting connection requests . Normally, you should leave the delay at the default, which is seconds. However, you may find that when you boot your server, your listener starts before your database instances start. If, for some reason, that results in a problem, you can specify a delay long enough to cover the time needed for your database instances to start first.
Examples
STARTUP_WAIT_TIME_PRODLISTENER = 30 STARTUP_WAIT_TIME_DEVLISTENER = 0
TRACE_DIRECTORY_listener_name |
TRACE_DIRECTORY_ listener_name = directory_ path |
Specifies the directory to which any listener trace files should be written. The default trace directory is $ORACLE_HOME /network /trace .
Examples
TRACE_DIRECTORY_PRODLISTENER = /s01/app/oracle/product/8.1.5/network/trace TRACE_DIRECTORY_PRODLISTENER = E:\Oracle\Ora81\NETWORK\TRACE
TRACE_FILE_ listener_name = directory_path |
Specifies the name to use for the listener's trace file. The default filename is listener.trc .
Examples
TRACE_FILE_PRODLISTENER = PRODLISTENER.TRC TRACE_FILE_DEVLISTENER = DEVLISTENER.TRC
TRACE_FILELEN_listener_name (new in Oracle8 i ) |
TRACE_FILELEN_ listener_name = kilobytes |
Allows you to specify a maximum size, in kilobytes, for a listener trace file. The default is to place no limit on trace file size . If tracing is enabled, and the current trace file reaches the specified limit, the listener closes the current trace file and opens a new one. The filenames are numbered in sequence. The TRACE_FILENO parameter controls the maximum number of trace files that the listener is allowed to generate.
| In order for TRACE_FILELEN to have any effect, you must set TRACE_FILENO to a value other than 1. If you don't, this parameter is ignored. The two parameters must be used together, or not at all. | |
Examples
TRACE_FILELEN_PRODLISTENER = 1000 TRACE_FILENO_PRODLISTENER = 5 TRACE_FILELEN_DEVLISTENER = 10 TRACE_FILENO_PRODLISTENER = 50
TRACE_FILENO_listener_name (new in Oracle8 i ) |
TRACE_FILENO_ listener_name = number |
Specifies the maximum number of listener trace files to generate and use in a cyclical pattern. This parameter must be used in conjunction with the TRACE_FILELEN parameter. As each trace file reaches its size limit, a new file is opened. Sequence numbers are appended to the filenames in order to differentiate them. The TRACE_FILENO parameter specifies the maximum sequence number that may be used. When that file fills, the listener wraps around to the first trace file and reuses all the files in sequence.
| Sequence numbers are only appended to trace files when the TRACE_FILENO and TRACE_FILELEN parameters are being used. | |
Examples
TRACE_FILELEN_PRODLISTENER = 1000 TRACE_FILENO_PRODLISTENER = 5 TRACE_FILELEN_DEVLISTENER = 10 TRACE_FILENO_PRODLISTENER = 50
TRACE_LEVEL_listener_name |
TRACE_LEVEL_ listener_name = { level_name level_number } |
Allows you to specify the listener trace level. The amount of information written to the trace file and the level of detail represented by that information are controlled by this parameter. The default value is OFF, which means that no trace information is generated.
You may specify trace levels by name or by number. The following names are valid (their corresponding numeric values are enclosed within parentheses):
- OFF (0)
-
No trace output is generated.
- USER (4)
-
User-level trace information is generated.
- ADMIN (6)
-
Administrative-level trace information is generated.
- SUPPORT (16)
-
Support-level trace information is generated.
| When you use the SUPPORT trace level, your trace files get very large very quickly. SUPPORT is best used for a short period of time while you focus on a specific problem. | |
Examples
TRACE_LEVEL_PRODLISTENER = ADMIN TRACE_LEVEL_DEVLISTENER = 16
TRACE_TIMESTAMP_listener_name (new in Oracle8 i ) |
TRACE_TIMESTAMP_ listener_name = {{ON TRUE} {OFF FALSE}} | |
Allows you to specify that a timestamp (in the form dd-Month-yyyy hh:mi:ss) be added to each event logged in a listener's trace file. The default value is OFF, which means that no timestamp is generated. FALSE is the same as OFF. ON or TRUE cause timestamps to be written to the trace file.
USE_PLUG_AND_PLAY_listener_name | |
USE_PLUG_AND_PLAY_ listener_name = {ON OFF} | |
Specifies whether or not a listener should automatically register database information with available Oracle Names servers. The default value is OFF. Use ON if you want automatic registration to occur.
Examples
USE_PLUG_AND_PLAY_PRODLISTENER = ON USE_PLUG_AND_PLAY_DEVLISTENER = OFF