Call (800) 766-1884 for Oracle support & training
Free Oracle Tips


Oracle Consulting Support
Oracle Upgrades
Use New Oracle Features
Oracle Replication Support
Oracle Training
Remote Oracle DBA
System Documentation
Oracle Tips
Oracle Performance
 

Free Oracle Tips


 

HTML Text

BC Oracle tuning

Oracle training

Oracle support

Remote Oracle

 

Donald K. Burleson

Oracle Utilities Tips


Managing Listeners with lsnrctl


 

$ lsnrctl

 

LSNRCTL for Solaris: Version 9.2.0.1.0 - Production on 30-JAN-2003 11:54:13

 

(c) Copyright 1998 Oracle Corporation.  All rights reserved.

 

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> help

 

The following operations are available

An asterisk (*) denotes a modifier or extended command:

 

start               stop                status

services            version             reload

save_config         trace               spawn

dbsnmp_start        dbsnmp_stop         dbsnmp_status

change_password     quit                exit

set*                show*

 

The following commands are used to manage the listener: 

·     start – Starts the listener with the name specified, otherwise LISTENER will be used.  For Windows systems, the listener can also be started from the Control Panel.

·     stop – Stops the listener.  For Windows systems, the listener can also be stopped from the Control Panel.

·     status – Provides status information about the listener, including start date, uptime, and trace level.

·     services – Displays each service available, along with the connection history.

·     version – Displays the version information of the listener.

·     reload – Forces a read of the configuration file in order for new settings to take effect without stopping and starting the listener.

·     save_config – Creates a backup of the existing listener.ora file and saves changes to the current version.

·     trace – Sets the trace level to one of the following – OFF, USER, ADMIN, or SUPPORT.

·     spawn – Spawns a program that runs with an alias in the listener.ora file.

·     dbsnmp_start – Starts the DBSNMP subagent.

·     dbsnmp_stop – Stops the DBSNMP subagent.

·     dbsnmp_status – Displays the status of the DBSNMP subagent.

·     change_password – Sets a new password for the listener.

·     quit and exit – Exits the utility.

·     set – Changes the value of any parameter.  Everything that can be shown can be set.

show – Displays current parameter settings.


 


To learn more about these techniques, see the book "Advanced Oracle Utilities: The Definitive Reference". 

You can buy it directly from the publisher and get instant access to the code depot of utilities scripts.


 

  ”call


Download your Oracle scripts now:

www.oracle-script.com

The definitive Oracle Script collection for every Oracle professional DBA

  
 

Oracle performance tuning software 
 
 
 
 

Oracle performance tuning book

 

 
 
 
Oracle performance Tuning 10g reference poster
 
 
 
Oracle training in Linux commands
 
Oracle training Excel
 
Oracle training & performance tuning books
 
   

Copyright © 1996 -  2014 by Burleson. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.