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


6 comments:

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

    ReplyDelete
  2. 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. can u gime how to set host credentiol in 10g

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

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

    ReplyDelete