Detailed description of lsnrctl parameters and query status of the Oracle listener service

Detailed description of lsnrctl parameters and query status of the Oracle listener lsnrctl command common parameters: lsnrctlstart starts the specified listener stop to close the specified listener status to display the listener status. The status command shows whether the listener is active, the location of logs and trace files, how long the listener has been running, and the tasks monitored by the listener. Services lists listener service information, such as whether these services have any dedicated pre-generated server processes or related scheduling processes, and how many connections of each service are accepted or rejected. This method is used to check whether a listener is listening for a specified service. Lists A summary table of a service and the number of connections established and rejected by each protocol service handler. The Version displays the Version of the oracle net software and protocol adapter. Reload the listener and read the listener. ora file again without closing the listener. If the file changes, refresh the listener. Save_config when the listener. ora file is modified from the lsnrctl tool, copy a file named listener. ora of listener. bak. Trace enables the tracing feature of the listener. Change_password allows you to change the password required to close the listener. Example: LSNRCTL> change_passwordOld password: New password: Reenter new password: connecting to (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = lymighty-PC) (PORT = 1521) the LISTENER password has been changed. The command is successfully executed. quit exits the lsnrctl tool. Exit to exit the lsnrctl tool. Set * asterisk (*) indicates the modifier or extension command: password rawmodedisplaymode trc_filetrc_directory trc_levellog_file log_directorylog_status variable password specifies the password required to execute management tasks in the lsnrctl command line tool. Example: LSNRCTL> set passwordPassword: The command is successfully executed. rawmodedisplaymodetrc_file specifies the location of the listener trace information. The default value is $ ORACLE_HOMEnetworktracelistener.trc trc_directorytrc_level Trace Level OFF-the trace function is not enabled. OFF is the default setting. USER-set the trail to the corresponding level of the USER. Trace to identify error conditions caused by users. ADMIN-set the trail to the corresponding level of the database administrator. Trace to identify specific installation problems. SUPPORT-set the trail to the appropriate level of customer SUPPORT personnel. The trace file may become large. Oracle Corporation recommends that the tracking function be disabled when no network problem diagnosis is performed. Log_file specifies where a listener will write the log information. This parameter is ON by default and is % oracle_home % networkloglistener. log log_directorylog_statuscurrent_listenerinbound_connect_timeout by default, which defines the effective response time that the listener will wait for when a session is started. The default value is 10 seconds. Startup_waittime defines how long the listener will wait before responding to a status command in the lsnrctl command line tool. Save_config_on_stop specifies whether the changes made during the lsnrctl session period should be saved upon exit. Show * rawmode displays more detailed information about status and service (when they are set to on) values: ON or OFF. Displaymode sets the display mode of lsnrctl to raw, compact, normal, or verbose. The display mode is NORMAL rulestrc_file, which specifies the location of the listener trace information. The default value is $ ORACLE_HOMEnetworktracelistener.trc current_listener. The current listener is listener2inbound_connect_timeout, which defines the effective response time that the listener will wait for when a session is started. The default value is 10 seconds. Startup_waittime defines how long the listener will wait before responding to a status command in the lsnrctl command line tool. Snmp_visiblesave_config_on_stop specifies whether the changes made during an lsnrctl session should be saved at exit. Details about the lsnrctl query status: LSNRCTL> statusConnecting to (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = ocm1.oracle. domain) (PORT = 1521) STATUS of the LISTENER -------- Alias LISTENERVersion TNSLSNR for Linux: Version 10.2.0.1.0-ProductionStart Date 17-MAY-2011 21: 03: 40 Uptime 0 days 0 hr. 2 min. 49 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFFListener Parameter File/u01/app/oracle/product/10.2.1/ Db/network/admin/listener. oraListener Log File/u01/app/oracle/product/10.2.1/db/network/log/listener. logListening Endpoints Summary... (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = ocm1.oracle. domain) (PORT = 1521) (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = ocm1.oracle. domain) (PORT = 1522) (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = ocm1.oracle. domain) (PORT = 1600) Services Summary... Service "POD" has 1 instance (s). Instance "POD", status READY, has 1 handler (s) for this service... Service "POD1" has 1 instance (s). Instance "POD", status UNKNOWN, has 1 handler (s) for this service... Service "PODS" has 1 instance (s). Instance "POD", status READY, has 2 handler (s) for this service... Service "pod_XPT" has 1 instance (s). Instance "POD", status READY, has 1 handler (s) for this service... Service "repos" has 2 instance (s). Instance "repos", status UNKNOWN, has 1 handler (s) for this service... Instance "repos", status READY, has 1 handler (s) for this service... Service "repos_XPT" has 1 instance (s). Instance "repos", status READY, has 1 handler (s) for this service... The command completed successfully status Details Listening Endpoints Summary... (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = ocm1.oracle. domain) (PORT = 1521) (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = ocm1.oracle. domain) (PORT = 1522) (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = ocm1.oracle. domain) (PORT = 1600) # The host address is ocm1.oracle. domain. The enabled listening ports include 1600, Services Summary... Service "POD" has 1 instance (s). Instance "POD", status READY, has 1 handler (s) for this service... # Here, a Service named POD is provided. The database instance named POD and the status READY indicates that it is currently dynamically registered Service "POD1" has 1 instance (s ). instance "POD", status UNKNOWN, has 1 handler (s) for this service... # Here, there is a Service named POD1, the database instance named POD, and the status UNKNOWN indicates that it is currently statically registered Service "PODS" has 1 instance (s ). instance "POD", status READY, has 2 handler (s) for this service... # Here, there is a Service named PODS, the database instance named POD, and the status ready indicates that it is dynamically registered Service "repos" has 2 instance (s ). instance "repos", status UNKNOWN, has 1 handler (s) for this service... Instance "repos", status READY, has 1 handler (s) for this service... The command completed successfully # Here It indicates that there is a service named repos, The corresponding database instance is repos, UNKNOWN, READY status indicates that it currently has a static registration and a dynamic registration LSNRCTL> servicesConnecting to (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = ocm1.oracle. domain) (PORT = 1521) Services Summary... Service "POD" has 1 instance (s). Instance "POD", status READY, has 1 handler (s) for this service... Handler (s): "DEDICATED" established: 0 refused: 0 state: readyLOCAL SERVERService "POD1" has 1 instance (s ). instance "POD", status UNKNOWN, has 1 handler (s) for this service... Handler (s): "DEDICATED" established: 0 refused: 0 LOCAL SERVERService "PODS" has 1 instance (s ). instance "POD", status READY, has 2 handler (s) for this service... Handler (s): "D001" established: 0 refused: 0 current: 0 max: 1022 state: readyDISPATCHER (ADDRESS = (PROTOCOL = tcp) (HOST = ocm1.oracle. domain) (PORT = 37290) "D000" established: 0 refused: 0 current: 0 max: 1022 state: readyDISPATCHER (ADDRESS = (PROTOCOL = tcp) (HOST = ocm1.oracle. domain) (PORT = 37288) Service "pod_XPT" has 1 instance (s ). instance "POD", status READY, has 1 handler (s) for this service... Handler (s): "DEDICATED" established: 0 refused: 0 state: readyLOCAL SERVERService "repos" has 2 instance (s ). instance "repos", status UNKNOWN, has 1 handler (s) for this service... Handler (s): "DEDICATED" established: 0 refused: 0 LOCAL SERVERInstance "repos", status READY, has 1 handler (s) for this service... Handler (s): "DEDICATED" established: 0 refused: 0 state: readyLOCAL SERVERService "repos_XPT" has 1 instance (s ). instance "repos", status READY, has 1 handler (s) for this service... Handler (s): "DEDICATED" established: 0 refused: 0 state: readyLOCAL SERVERThe command completed successfully service detailed description of Service "POD" has 1 instance (s ). instance "POD", status READY, has 1 handler (s) for this service... Handler (s): "DEDICATED" established: 0 refused: 0 state: readyLOCAL SERVER # The service named POD. The corresponding database instance is POD, the status READY indicates that it is in the Dynamic Registration DEDICATED "established: 0 refused: 0 state: ready indicates that it is a proprietary connection, and the number of connections is 0 and the rejection is 0. The status: dynamic Service "POD1" has 1 instance (s ). instance "POD", status UNKNOWN, has 1 handler (s) for this service... Handler (s): "DEDICATED" established: 0 refused: 0 local server # The service named POD1. The corresponding database instance is POD. The state of UNKNOWN indicates that it is in the static registration DEDICATED "established: 2 refused: 0 indicates a private connection. The number of connections is 2. The number of denied requests is 0. Service "PODS" has 1 instance (s ). instance "POD", status READY, has 2 handler (s) for this service... Handler (s): "D001" established: 0 refused: 0 current: 0 max: 1022 state: readyDISPATCHER (ADDRESS = (PROTOCOL = tcp) (HOST = ocm1.oracle. domain) (PORT = 37290) "D000" established: 0 refused: 0 current: 0 max: 1022 state: readyDISPATCHER (ADDRESS = (PROTOCOL = tcp) (HOST = ocm1.oracle. domain) (PORT = 37288) # The service named PODS corresponds to the database instance named POD. The READY status indicates that it dynamically registers "D001" established: 0 refused: 0 current: 0 max: 1022 state: ready "D000" established: 0 refused: 0 current: 0 max: 1022 state: ready it is the share mode. Currently, both dispatcher instances are connected to 0, and the reject value is 0. The maximum value is 1022, the status is dynamic registration of the corresponding SQL query SQL> show parameter dispatchers NAME TYPE VALUE ------------ ---- ---------- dispatchers stringmax_dispatchers integerSQL> alter system set dispatchers = '(protocol = tcp) (dispatchers = 2) '; System altered. SQL> show parameter dispatchersNAME T Ype value ------------ ---- ---------- dispatchers string (protocol = tcp) (dispatchers = 2) max_dispatchers integerSQL> select name, network, paddr, status from v $ dispatcher; name network paddr status -- ------------------------- --- ------ D000 (ADDRESS = (PROTOCOL = tcp) (HOST = seagull) (PORT = 37288) 2A220390 WAITD001 (ADDRESS = (PROTOCOL = tcp) (HOST = seagull) (PORT = 37290) 2A220948 WAIT ------------------------------ ------------------------ Service "repos" has 2 instance (s). Instance "repos", status UNKNOWN, has 1 handler (s) for this service... Handler (s): "DEDICATED" established: 0 refused: 0 LOCAL SERVERInstance "repos", status READY, has 1 handler (s) for this service... Handler (s): "DEDICATED" established: 0 refused: 0 state: readyLOCAL SERVER # There are two instances for the repos service, but both are instance repos and one is static UNKNOWN, one is dynamic READY, the current number of connections is 0, and the rejection is also 0The command completed successfully