January 8, 2019

lsnrctl commands in Oracle

How to start/stop Listener in Oracle ?
What are listener commands in Oracle ?

 $ lsnrctl start [listener_name]
$ lsnrctl stop [listener_name]
$ lsnrctl status [listener_name]
$ lsnrctl reload [listener_name]
$ lsnrctl services [listener_name]

LSNRCTL> help
LSNRCTL> version [listener_name]    -- get the version information of the listener

LSNRCTL> start [listener_name]   -- starts the listener
LSNRCTL> stop [listener_name]    -- stops the listener
LSNRCTL> status [listener_name]   -- get the status of listener
LSNRCTL> services [listener_name]   -- get the service information of the listener
LSNRCTL> servacls [listener_name]  - ACLs
LSNRCTL> reload [listener_name]    -- reload the parameter files and SIDs

LSNRCTL> save_config [listener_name]    -- saves configuration changes to parameter file
LSNRCTL> trace OFF | USER | ADMIN | SUPPORT [listener_name]    -- set tracing to the specified level
LSNRCTL> spawn [listener_name] spawn_alias [(ARGUMENTS='arg0, arg1,...')]
LSNRCTL> change_password [listener_name]   -- changes the password of the listener

LSNRCTL> set [below_modifier]
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                dynamic_registration               
enable_global_dynamic_endpoint     connection_rate_limit 

 LSNRCTL> show [below_modifier]
rawmode                            displaymode                        
rules                               trc_file                           
trc_directory                      trc_level                          
log_file                            log_directory                      
log_status                         current_listener                   
inbound_connect_timeout            startup_waittime                   
snmp_visible                       save_config_on_stop                
dynamic_registration               enable_global_dynamic_endpoint     
oracle_home                        pid                                
connection_rate_limit

LSNRCTL> quit
LSNRCTL> exit

default listener_name is LISTENER
Other Oracle Articles:  SQL*Loader    emca commands

Labels:

6 comments:

  1. shaileshNovember 21, 2010 at 10:41 AM

    hi sir thank for all of this practiacl this is very important to me

    ReplyDelete
  2. shaileshNovember 21, 2010 at 12:11 PM

    can you give me discription and practical this


    Database Diagnostics Pack

    * Automatic Workload Repository
    * ADDM (Automated Database Diagnostic Monitor)
    * Performance Monitoring (Database and Host)
    * Event Notifications: Notification Methods, Rules and Schedules
    * Event history/metric history (Database and Host)
    * Blackouts
    * Dynamic metric baselines
    * Memory performance monitoring

    Database Tuning Pack

    * SQL Access Advisor
    * SQL Tuning Advisor
    * SQL Tuning Sets
    * Reorganize Objects

    Configuration Management Pack

    * Database and Host Configuration
    * Deployments
    * Patch Database and View Patch Cache
    * Patch staging
    * Clone Database
    * Clone Oracle Home
    * Search configuration
    * Compare configuration
    * Policies

    ReplyDelete
  3. shaileshNovember 26, 2010 at 2:01 PM

    can u gime how to set host credentiol in 10g

    ReplyDelete
  4. Satya ThirumaniMay 12, 2012 at 4:28 PM

    Thank Shailesh...

    ReplyDelete
  5. RajaAugust 22, 2012 at 12:18 AM

    can u plz describe the concepts LISTENER and TNS not command .i want concept

    ReplyDelete
  6. RajaAugust 22, 2012 at 12:19 AM

    this is raja .i want full details about listner and tns

    ReplyDelete

Subscribe to: Post Comments (Atom)