If you want to manage (start, shut down, etc.) the Monitoring service of Oracle database, you can do it through the Lsnrctl command on the Windows/linux platform, below
We mainly talk about how to use the LSNRCTL command to manage the monitoring service (I am in two databases (different platforms, different versions) operation, for the moment called Server A,
Server B):
1: View detailed help for the Service Listener command
Server a:red Hat Enterprise Linux Server Release 6.0 (Santiago) ORACLE 10
[Email protected] ~]$ Lsnrctl
Lsnrctl for linux:version 10.2.0.1.0-production on 04-jul-2012 12:10:13
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Welcome to Lsnrctl, type ' help ' for information.
Lsnrctl> Help
The following operations is available
An asterisk (*) denotes a modifier or extended command:
Start Stop status
Services version Reload
Save_config Trace Spawn
Change_password quit exit
set* show*
Server B:window Platform ORACLE 11
Lsnrctl> Help
The following actions are available
An asterisk (*) indicates a modifier or an extended command:
Start Stop status
Services version Reload
Save_config Trace Change_password
Quit Exit set*
show*
Compare 10g and 11g, you can find 11g less spawn command
Parameters |
Parameter function description |
Start |
Start the specified monitoring service: start [<listener_name>]: Start listener |
Stop |
Stop the specified listening service: stop [<listener_name>]: Stop Listener |
Status |
View the specified listening service status: status [<listener_name>]: Get the status of listener |
Services |
Lists a summary table of services and the number of connection information created and rejected for each protocol service handler : Service [<listener_name>]: Get the service information of the listener |
Version |
View Monitoring Service Version information: version [<listener_name>]: Get the version information of the listener |
Reload |
Restart monitoring service: reload [<listener_name>]: Reload the parameter files and SIDs |
Save_config |
Save the information to modify the listener configuration to the parameter file: Save_config [<listener_name>]: Saves configuration changes to parameter file |
Trace |
Turn on trace feature for listener: Trace OFF | USER | ADMIN | support [<listener_name>]: Set tracing to the specified level |
Spawn |
Produces a program that runs as an alias in the Listener.ora file: Spawn [<listener_name>] <spawn_alias> [< (arguments= ' arg0, arg1,... ');] |
Change_password |
Modify the secret of shutting down the listening service: Change_password [<listener_name>]: Changes the password of the listener |
Quit |
Exit Tnsrctl command: Quit | Exit:exit Lsnrctl |
Exit |
Exit Tnsrctl command: Quit | Exit:exit Lsnrctl |
Set |
Setting the configuration of the listening service |
Show |
Display some parameter configuration information |
2: Start the specified listening service
Server A:
lsnrctl> Start LISTENER
Starting/database/product/dbhome_1/bin/tnslsnr:please wait ...
Tnslsnr for Linux:version 10.2.0.1.0-production
System parameter File Is/database/product/dbhome_1/network/admin/listener.ora
Log messages Written To/database/product/dbhome_1/network/log/listener.log
Listening on: (Description= (Address= (PROTOCOL=IPC) (Key=extproc1)))
Listening on: (Description= (Address= (protocol=tcp) (Host=db-server) (port=1521)))
Connecting to (Description= (address= (PROTOCOL=IPC) (Key=extproc1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version Tnslsnr for Linux:version 10.2.0.1.0-production
Start Date 05-jul-2012 10:38:14
Uptime 0 days 0 hr. 0 min. 0 sec
Trace level off
Security on:local OS Authentication
SNMP OFF
Listener Parameter File/database/product/dbhome_1/network/admin/listener.ora
Listener Log File/database/product/dbhome_1/network/log/listener.log
Listening Endpoints Summary ...
(Description= (address= (PROTOCOL=IPC) (Key=extproc1)))
(Description= (address= (protocol=tcp) (Host=db-server) (port=1521)))
Services Summary ...
Service "Plsextproc" has 1 instance (s).
Instance "Plsextproc", status UNKNOWN, have 1 handler (s) for the This service ...
Service "Wgods" has 1 instance (s).
Instance "Wgods", status UNKNOWN, have 1 handler (s) for the This service ...
The command completed successfully
Server B:
lsnrctl> Start LISTENER
Start Tnslsnr: Please wait ...
Tnslsnr for 32-bit windows:version 11.2.0.1.0-production
System parameter file is E:\app\kerry\product\11.2.0\dbhome_1\network\admin\listener.ora
Log information written to E:\app\kerry\diag\tnslsnr\kerry-PC\listener\alert\log.xml
Monitoring: (Description= (Address= (protocol=tcp) (host=127.0.0.1) (port=1521)))
Connecting to (Description= (address= (protocol=tcp) (host=127.0.0.1) (port=1521))
The STATUS of LISTENER
------------------------
Alias LISTENER
Version Tnslsnr for 32-bit windows:version 11.2.0.1.0-production
Start Date May-July-2012 10:37:49
Uptime 0 days 0 hours 0 minutes 5 seconds
Trace level off
Security On:local OS Authentication
SNMP OFF
Listener parameter File E:\app\kerry\product\11.2.0\dbhome_1\network\admin\listener.ora
Listener log File E:\app\kerry\diag\tnslsnr\kerry-PC\listener\alert\log.xml
Listener Endpoint Summary ...
(Description= (address= (protocol=tcp) (host=127.0.0.1) (port=1521)))
Service Summary:
The service "Clrextproc" consists of 1 instances.
The instance "Clrextproc", State UNKNOWN, contains 1 handlers for this service ...
The service "orcl.20.32.106" consists of 1 instances.
The instance "ORCL", State UNKNOWN, contains 1 handlers for this service ...
Command execution succeeded
Lsnrctl> Top
NL-00853: the command "Top" is not defined. Please try "help"
3: Stop monitoring Service
Server A:
Lsnrctl> stop
Connecting to (Description= (address= (PROTOCOL=IPC) (Key=extproc1)))
The command completed successfully
Server B:
Lsnrctl> stop
Connecting to (Description= (address= (protocol=tcp) (host=127.0.0.1) (port=1521))
Command execution succeeded
4: View Monitoring Service status
Server A:
Server B:
5: View the Listening service version
Server A:
Lsnrctl> version
Connecting to (Address= (PROTOCOL=TCP) (Host=db-server) (port=1521))
Tnslsnr for Linux:version 10.2.0.1.0-production
TNS for Linux:version 10.2.0.1.0-production
Unix Domain Socket IPC NT Protocol Adaptor for Linux:version 10.2.0.1.0-production
Oracle bequeath NT Protocol Adapter for Linux:version 10.2.0.1.0-production
TCP/IP NT Protocol Adapter for Linux:version 10.2.0.1.0-production,
The command completed successfully
Server B:
Connecting to (Description= (address= (protocol=tcp) (host=127.0.0.1) (port=1521))
Tnslsnr for 32-bit windows:version 11.2.0.1.0-production
TNS for 32-bit windows:version 11.2.0.1.0-production
Oracle bequeath NT Protocol Adapter for 32-bit windows:version 11.2.0.1.0-production
Windows NT Named Pipes NT Protocol Adapter for 32-bit windows:version 11.2.0.1.0-production
Windows NT TCP/IP NT Protocol Adapter for 32-bit windows:version 11.2.0.1.0-production,
Command execution succeeded
6: View Monitoring Service information
Server A:
Lsnrctl> Service
Connecting to (Description= (address= (PROTOCOL=IPC) (Key=extproc1)))
Services Summary ...
Service "Plsextproc" has 1 instance (s).
Instance "Plsextproc", status UNKNOWN, have 1 handler (s) for the This service ...
Handler (s):
"Dedicated" established:0 refused:0
LOCAL SERVER
Service "Wgods" has 2 instance (s).
Instance "Wgods", status UNKNOWN, have 1 handler (s) for the This service ...
Handler (s):
"Dedicated" established:0 refused:0
LOCAL SERVER
Instance "Wgods", status ready, have 1 handler (s) for the This service ...
Handler (s):
"Dedicated" Established:1 refused:0 State:ready
LOCAL SERVER
Service "Wgodsxdb" has 1 instance (s).
Instance "Wgods", status ready, have 1 handler (s) for the This service ...
Handler (s):
"D000" established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER <machine:db-server, pid:31049>
(Address= (PROTOCOL=TCP) (Host=db-server) (port=34792))
Service "WGODS_XPT" has 1 instance (s).
Instance "Wgods", status ready, have 1 handler (s) for the This service ...
Handler (s):
"Dedicated" Established:1 refused:0 State:ready
LOCAL SERVER
The command completed successfully
Server B:
Lsnrctl> Services
Connecting to (Description= (address= (protocol=tcp) (host=127.0.0.1) (port=1521))
Service Summary:
The service "Clrextproc" consists of 1 instances.
The instance "Clrextproc", State UNKNOWN, contains 1 handlers for this service ...
Handlers:
"Dedicated" established: 0 has been rejected: 0
LOCAL SERVER
The service "orcl.20.32.106" consists of 1 instances.
The instance "ORCL", State UNKNOWN, contains 1 handlers for this service ...
Handlers:
"Dedicated" established: 0 has been rejected: 0
LOCAL SERVER
Command execution succeeded
7: Restart the Monitoring service: This command can replace Lsnrctl stop and Lsnrctl start, which can be restarted without shutting down the Listening service command.
Read Listener.ora configuration, suitable for use after modifying the listening service file.
Server A:
Lsnrctl> Reload
Connecting to (Description= (address= (PROTOCOL=IPC) (Key=extproc1)))
The command completed successfully
Server B:
Lsnrctl> Reload
Connecting to (Description= (address= (protocol=tcp) (host=127.0.0.1) (port=1521))
Command execution succeeded
8: Modify, set the listening service password
If the listening service password is not set, the default password is blank.
Lsnrctl> Change_password
Old Password:
New Password: ******
Reenter new password: ******
Connecting to (Description= (address= (protocol=tcp) (host=127.0.0.1) (port=1521))
The password for the listener has changed
Command execution succeeded
Lsnrctl> Change_password
Old Password:
New Password:
Reenter New password:
Connecting to (Description= (address= (PROTOCOL=IPC) (Key=extproc1)))
Password changed for LISTENER
The command completed successfully
Lsnrctl> Set Password
Password:
The command completed successfully
Lsnrctl> Save_config
Connecting to (Description= (address= (PROTOCOL=IPC) (Key=extproc1)))
Saved LISTENER configuration parameters.
Listener Parameter File/database/product/dbhome_1/network/admin/listener.ora
Old Parameter File/database/product/dbhome_1/network/admin/listener.bak
The command completed successfully
At this point, you check the Listener.ora, you will find that the file is more encrypted under the password
After the deletion of the item, save the Listener.ora file, you can cancel the Lsnrctl encryption password;
#----ADDED by Tnslsnr 18-dec-2012 17:28:17---
Passwords_listener = 1baf8fabbd6810d3
#--------------------------------------------
This setting is valid in the Oracle 9i version, and in the 10g version, even after the password is set, it is possible to stop the monitoring service without entering the password because in Oracle, the Tnslistener are secure out of the box and there sh Ould not is a need to set a listener password as in older versions of the Oracle listener.
After oracle10g, setting the listener password is not necessary for security checks, because the default in 10g in addition to the user to start monitoring, other users can not stop listener (there are some other LSNRCTL commands are also banned, such as trace , reload, etc.), even if listener does not have a password set. By default, start listener or use the LSNRCTL Status command to view the listening status as you can see: Security On:password or Local OS Authentication This indicates that the listener security mechanism uses the password mode or the local OS authentication mode, in this state, even if the monitoring password is set, for the user to start monitoring, It is still possible to stop listening without any password.
If you want to remove this security mechanism, you can add Local_os_authentication_[listener under Listener.ora name]=off
[Email protected] admin]$ VI Listener.ora
Sid_list_listener =
(Sid_list =
(Sid_desc =
(Sid_name = Plsextproc)
(Oracle_home =/database/product/dbhome_1)
(program = Extproc)
)
(Sid_desc =
(Sid_name = wgods)
(Oracle_home =/database/product/dbhome_1)
(Sid_name = wgods)
)
)
LISTENER =
(Description_list =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP) (HOST = db-server) (PORT = 1521))
)
)
Local_os_authentication_listener=off
#----ADDED by Tnslsnr 18-dec-2012 17:28:17---
Passwords_listener = 1baf8fabbd6810d3
"Listener.ora" 33L, 779C written
[Email protected] admin]$ Lsnrctl
Lsnrctl for linux:version 10.2.0.1.0-production on 19-dec-2012 18:40:19
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Welcome to Lsnrctl, type ' help ' for information.
Lsnrctl> Reload
Connecting to (Description= (address= (PROTOCOL=IPC) (Key=extproc1)))
The command completed successfully
Lsnrctl> stop
Connecting to (Description= (address= (PROTOCOL=IPC) (Key=extproc1)))
Tns-01169:the Listener have not recognized the password
Lsnrctl> Set Password--Enter the password to stop the monitoring service
Password:
The command completed successfully
Lsnrctl> stop
Connecting to (Description= (address= (PROTOCOL=IPC) (Key=extproc1)))
The command completed successfully
9:set command Configuration
Parameters |
Description |
Set Password |
|
Set Rawmode |
Set Rawmode |
Set DisplayMode |
Set the display mode of the Lsnrctl tool to Raw, COMPACT, normal, or verbose |
Set Trc_file |
Set the name of the listener trace file |
Set Trc_directory |
Set the name of the Listener trace directory |
Set Trc_level |
Set the trace level to off, USER, ADMIN, support mode |
Set Log_file |
Display or set the log file |
Set Log_directory |
Set the log directory location |
Set Log_status |
Set whether log attributes are turned on for this listener |
Set Current_listener |
Sets the current listener as the specified listener |
Set Inbound_connect_timeout |
Setting the parameter specifies the time, in a few seconds, for the client to complete the network connection after it has been established, its connection request is monitored |
Set Startup_waittime |
Set the length of time a listener waits for a status command in a response lsnrctl command-line tool |
Set Save_config_on_stop |
Save changes to the Listener.ora file when you exit the Lsnrctl tool |
Set Dynamic_registration |
Use the Dynamic_registration_listener_name parameter to enable or disable dynamic registration. When set to ON, the listener accepts dynamic registrations, and when set to off, the listener refuses to register dynamically. Static registration is not affected |
Set Enable_global_dynamic_endpoint |
|
Lsnrctl> Set
The following operations is available after set
An asterisk (*) denotes a modifier or extended command:
Password Rawmode
DisplayMode Trc_file
Trc_directory Trc_level
Log_file Log_directory
Log_status Current_listener
Inbound_connect_timeout Startup_waittime
Save_config_on_stop
lsnrctl> Help Set Password
Set Password:set the password for subsequent calls
Lsnrctl> Help Set Current_listener
Set|show Current_listener [<listener_name>]: sets|shows Current listener
9: Save configuration information: After modifying some configurations, you can save to the configuration file by Save_config
Lsnrctl> Save_config
Connecting to (Description= (address= (protocol=tcp) (host=127.0.0.1) (port=1521))
Save the Listener configuration parameters.
Listener parameter File E:\app\kerry\product\11.2.0\dbhome_1\network\admin\listener.ora
Old parameter file E:\app\kerry\product\11.2.0\dbhome_1\network\admin\listener.bak
Command execution succeeded
Lsnrctl>
10: Setting the Listening level
11:spawn
12: Exit the Listen server command
Lsnrctl> exit
Lsnrctl> quit
13: Display some parameter configuration information
Parameters |
Description |
Show Rawmode |
Display RAW mode information: Displays more detailed information about status and services (when they are set to ON). Value: On or off |
Show DisplayMode |
Display mode information |
Show rules |
Display Filter Rule information |
Show Trc_file |
Display trace File information |
Show Trc_directory |
Display trace file directory information |
Show Trc_level |
Show trace Levels |
Show Log_file |
Viewing log file information |
Show Log_direcotory |
Displaying log file directory information |
Show Log_status |
Show Log Status |
Show Current_listener |
Displays the current listening service name |
Show Inbound_connect_timeout |
Displays the parameters specified by the time, in a few seconds for the client to complete the network connection has been established after the monitoring of its connection request, |
Show Startup_waitetime |
Displays the length of time that the listener waits for a status command in the response Lsnrctl command-line tool |
Show Snmp_visible |
|
Show Save_config_on_stop |
Displays whether changes to the Listener.ora file are saved when exiting the Lsnrctl tool |
Show Dynamic_registration |
Show whether dynamic registration is enabled or disabled |
Show Enable_global_dynamic_endpoint |
|
Show Oracle_home |
Display Oracle Home directory information |
Show PID |
Show Oracle Listener Process ID |
Resources:
Http://www.eygle.com/archives/2007/11/listener_security.html
Http://www.cnblogs.com/kerrycode/archive/2012/12/19/2825377.html
Monitoring service Management (RPM)