监听文件 LISTENER.ORA 各参数意思

监听文件 LISTENER.ORA 各参数意思

The following items are available in the network listener configuration file (listener.ora).
    * Listener Address Section
    * SID_LIST_listener_name Static Service Section
    * Control Parameters

The listener.ora file is located in $ORACLE_HOME/network/admin on UNIX and ORACLE_HOME\network\admin on Windows NT, or in the directory specified by the TNS_ADMIN environment variable or registry value.

1. Listener Address Section

The listener address section of the listener.ora file defines the protocol address(es) of the listener.

DESCRIPTION 

Purpose: Defines listener protocol address(es)
Example: 
listener_name=
(description=
(address=(protocol=ipc)(key=extproc0))
(address=(protocol=tcp)(host=sales-pc)(port=1521)))

ADDRESS 

Purpose: Defines a listener protocol address. This parameter can be embedded under a ADDRESS_LIST or DESCRIPTION.
Example: 
listener_name=
(description=
(address=(protocol=ipc)(key=extproc0))
(address=(protocol=tcp)(host=sales-pc)(port=1521)))

ADDRESS_LIST 

Purpose: 
Defines lists of listener protocol addresses. If there is only one list of addresses, it is not necessary to use this parameter. This parameter can be embedded under a DESCRIPTION. 
Example: 
listener_name=
(description=
(address_list=
   (address=(protocol=ipc)(key=extproc0))
   (address=(protocol=tcp)(host=sales-pc)(port=1521))))

2. SID_LIST_listener_name Static Service Section

You can use the SID_LIST section of the listener.ora to statically configure service information with the listener.
The SID_LIST is required for backward compatibility with Oracle8 or Oracle7 databases, as well as external procedures and heterogeneous services, and some management tools, including Oracle Enterprise Manager.
Oracle8i database information is dynamically registered with the listener during instance startup. Therefore, this information is not required, unless Oracle Enterprise Manager is used to monitor an Oracle8i database.

sid_list_listener_name=
(sid_list= 
   (sid_desc=
    (global_dbname=global_database_name)
    (sid_name=sid)
    (oracle_home=oracle_home)
    (prespawn_max=99) 
    (prespawn_list= 
      (prespawn_desc= 
        (protocol=tcp)
        (pool_size=10)
        (timeout=2))
      (prespawn_desc=...)))
   (sid_desc=...))

SID_LIST contains the following parameters:

GLOBAL_DBNAME 

Purpose: Identifies the global database name of the database, a name comprised of the database name and database domain. You can obtain the GLOBAL_DBNAME value from the SERVICE_NAMES parameter in the initialization parameter file. This parameter must be embedded under SID_DESC and should match the value of the SERVICE_NAMES parameter. 
Example: 
sid_list_listener_name=
(sid_list= 
   (sid_desc=
    (global_dbname=oracle.com)
    (sid_name=orcl)
    (oracle_home=/usr/oracle)))

ORACLE_HOME 

Purpose: Identifies the Oracle home location of the service. This parameter must be embedded under SID_DESC. 
Example: 
sid_list_listener_name=
(sid_list= 
   (sid_desc=
     (sid_name=extproc)
     (oracle_home=/usr/oracle)
     (program=extproc)))

PROGRAM 

Purpose: Identifies the service's executable program name 
Example: 
sid_list_listener_name=
(sid_list= 
   (sid_desc=
     (sid_name=extproc)
     (oracle_home=oracle)
     (program=extproc)))

SID_NAME 

Purpose: Identifies the Oracle System Identifier (SID) of the instance. You can obtain the SID value from the INSTANCE_NAME parameter in the initialization parameter file. This parameter must be embedded under SID_DESC. 
Example: 
sid_list_listener_name=
(sid_list= 
   (sid_desc=
    (global_dbname=oracle.com)
    (sid_name=orcl)
    (oracle_home=/usr/oracle)))

SID_LIST 

Purpose: Identifies a list of SID descriptions 
Example: 
sid_list_listener_name=
(sid_list= 
   (sid_desc=...)
   (sid_desc=...))

SID_DESC 

Purpose: Provides service information for a specific database instance. This parameter can be embedded under SID_LIST. 
Example: 
sid_list_listener_name=
(sid_list= 
   (sid_desc=...)
   (sid_desc=...)) 

PRESPAWN_MAX 

Purpose: Specifies the maximum number of prespawned dedicated server processes the listener creates. This number must be at least as many as the sum of the pool size for each protocol. Set this value to a large number so that prespawned dedicated server processes are always available for new connections. This parameter must be embedded under SID_LIST.
Note: Prespawned dedicated servers cannot be configured on Windows NT. 
Example: 
sid_list_listener_name=
(sid_list= 
   (sid_desc=
    (global_dbname=oracle.com)
    (sid_name=sid)
    (oracle_home=/usr/oracle)
    (prespawn_max=99)))

PRESPAWN_LIST 

Purpose: Specifies a list of prespawnd dedicated server process protocol descriptions. This parameter must be embedded under SID_DESC. 
Example: 
sid_list_listener_name=
(sid_list= 
   (sid_desc=
    (global_dbname=oracle.com)
    (sid_name=sid)
    (oracle_home=/usr/oracle)
    (prespawn_max=99) 
    (prespawn_list= 
      (prespawn_desc= 
        (protocol=tcp)
        (pool_size=10)
        (timeout=2))
        (prespawn_desc=...)))

PRESPAWN_DESC 

Purpose: Defines the protocol on which the listener creates prespawned dedicated server processes, as well as characteristics of the prespawned dedicated server. Each protocol must have its own PRESPAWN_DESC description. This parameter must be embedded under PRESPAWN_LIST.
Example: 
sid_list_listener_name=
(sid_list= 
   (sid_desc=
    (global_dbname=oracle.com)
    (sid_name=sid)
    (oracle_home=/usr/oracle)
    (prespawn_max=99) 
    (prespawn_list= 
      (prespawn_desc= 
        (protocol=tcp)
        (pool_size=10)
        (timeout=2))
        (prespawn_desc=...))))

3. Control Parameters

CONNECT_TIMEOUT_listener_name 

Purpose: Determines the amount of time in seconds the listener waits for a valid connection request after a connection has been started 
Default: 10 seconds 
Example: connect_timeout_listener=12

LOG_DIRECTORY_listener_name 

Purpose: Specifies the destination directory for the listener log file 
Default: $ORACLE_HOME/network/log on UNIX and ORACLE_HOME/network/log on Windows NT 
Example: log_directory_listener=/oracle/network/admin/log

LOG_FILE_listener_name 

Purpose: Specifies the name of the log file for the listener 
Default: listener.log 
Example: log_file_listener=list.log

LOGGING_listener_name 

Purpose: Turns logging on or off 
Default: ON 
Values: ON | OFF 
Example: logging_listener=on

OSS.SOURCE.MY_WALLET 

Purpose: Specifies the location of wallets. Wallets are certificates, keys and trustpoints processed by SSL that allow for secure connections.
Default: None 
Example: 
oss.source.my_wallet= 
   (source=
      (method=file)
      (method_data= 
        (directory=/home/smalladi/oss)))

PASSWORDS_listener_name 

Purpose: Sets an unencrypted password for a listener, so that certain privileges operations, such as SAVE_CONFIG and STOP, used from the LSNRCTL utility are secure. Allows one or more passwords. An encrypted password can set with the LSNRCTL utility's CHANGE_PASSWORD command. 
Default: oracle 
Example: passwords_listener=(oracle8)

SAVE_CONFIG_ON_STOP_listener_name 

Purpose: If set to TRUE, any parameters which were modified through the LSNCRCTL SET command replace prior listener.ora file settings 
Default: FALSE 
Example: save_config_on_stop_listener=true

SSL_CLIENT_AUTHENTICATION 

Purpose: Specifies whether or not a client is authenticated using SSL 
Default: TRUE 
Values: TRUE | FALSE 
Usage Notes: The database authenticates the client. Therefore, this value should be set to FALSE. If this parameter is set to TRUE, the listener attempts to authenticate the client, which can result in a failure.
Example: ssl_cipher_suite=(ssl_dh_dss_with_des_cdc_sha)

STARTUP_WAIT_TIME_listener_name 

Purpose: Sets the number of seconds that the network listener sleeps before responding to the first LSNRCTL STATUS command 
Default: 0 seconds 
Example: startup_wait_time_listener=5

TRACE_DIRECTORY_listener_name 

Purpose: Specifies the destination directory for the listener trace files 
Default: $ORACLE_HOME/network/trace on UNIX and ORACLE_HOME/network/trace on Windows NT 
Example: trace_directory_listener=/oracle/network/admin/trace

TRACE_FILE_listener_name 

Purpose: Specifies the name of the trace file for the listener 
Default: listener.trc 
Example: trace_file_listener=list.trc

TRACE_FILELEN_listener_name 

Purpose: Specifies the size of the listener trace files in kilobytes (KB). When the size is met, the trace information is written to the next file. The number of files is specified with the TRACE_FILENO_listener_name parameter. 
Default: Unlimited 
Example: trace_filelen_listener=100

TRACE_FILENO_listener_name 

Purpose: Specifies the number of trace files for listener tracing. When this parameter is set along with the TRACE_FILEN_listener_name parameter, trace files are used in a cyclical fashion. The first file is filled first, then the second file, and so on. When the last file has been filled, the first file is re-used, and so on. The trace file names are distinguished from one another by their sequence number. For example, if the default trace file of listener.trc is used, and this parameter is set to 3, the trace files would be named listener1.trc, listener2.trc and listener3.trc. In addition, trace events in the trace files are preceded by the sequence number of the file. 
Default: 1 
Example: trace_fileno_listener=3 

TRACE_LEVEL_listener_name 

Purpose: Turns tracing on/off to a certain specified level 
Default: OFF 
Values: 
    * OFF - No trace output
    * USER - User trace information
    * ADMIN - Administration trace information
    * SUPPORT - WorldWide Customer Support trace information
Example: 
trace_level_listener=admin

TRACE_TIMESTAMP_listener_name 

Purpose: Adds a timestamp in form of dd-month-yyyy hh:mm:ss to a trace event in the listener trace file 
Default: OFF 
Values: ON or TRUE | OFF or FALSE 
Example: trace_timestamp_listener=true

USE_PLUG_AND_PLAY_listener_name 

Purpose: Instructs the listener to register database information with an Oracle Names server 
Default: OFF 
Values: ON | OFF 
Example: use_plug_and_play=on

--End--