LISTNER STUFF commands (lsnrctl)

By
=======================
LISTNER commands (lsnrctl)
========================

First try to use help for all commands

$ lsnrctl

-------------some un wanted lines skip-- to minimize size--

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           quit            exit            set*
show*

LSNRCTL>

--let`s try one by one (direct os/listenr cmd level)

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

--listenr cmd level i will show one example all similar just skip lsnrctl 
start  
LSNRCTL>start [listener_name]   

---------cmd level more you can do with commands show/set  


LSNRCTL> show
The following operations are available after show
An asterisk (*) denotes a modifier or extended command:

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                valid_node_checking_registration
registration_invited_nodes           registration_excluded_nodes
remote_registration_address
LSNRCTL> show [above_modifier name]

========================
LSNRCTL> set
The following operations are available after set
An asterisk (*) denotes a modifier or extended command:

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                valid_node_checking_registration
registration_invited_nodes           registration_excluded_nodes
----------if you want to set use like below 
LSNRCTL> set [above_modifier name ]

Comments

Post a Comment

Popular posts from this blog

SQL Tuning Task Creation ORA-13780: SQL statement does not exist.

By
SQL Tuning Task Creation ORA-13780: SQL statement does not exist. ================================================= example:- declare  l_sql_tune_task_id  varchar2(100); begin  l_sql_tune_task_id := dbms_sqltune.create_tuning_task (         sql_id      => 'your sql_id',         scope       => dbms_sqltune.scope_comprehensive,         time_limit  => 10800,         task_name   => 'tuning task name',         description => 'tuning task description');  dbms_output.put_line('l_sql_tune_task_id: ' || l_sql_tune_task_id); end; / declare * ERROR at line 1: ORA-13780: SQL statement does not exist. ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79 ORA-06512: at "SYS.PRVT_SQLADV_INFRA", line 125 ORA-06512: at "SYS.DBMS_SQLTUNE", line 655 solution :----  SELECT SNAP_ID FROM DBA_HIST_...
Read more

Shareplex some commands

By
Shareplex some commands i will post here and update in this post with more commands later, if i provide with example so post become lengthy so please to understand. =====================================================================   sp_ctrl  :- Shareplex provides a command line utility called    'sp_ctrl'   this  sp_ctl located in  <product_directory>/bin  ($SP_HOME/bin)  , if you set profile in os level you easy redirect location. Below i will give commands run under  sp_ctrl  sp_ctrl (xxx)>   show config   ==> To check the active configuration (source side). sp_ctrl (xxx)>   show log reverse  ==> To check the log file sp_ctrl (xxx)>  show  ==>   command to displays status of the replication processes (Capture, Read, Export, Import and Post) . sp_ctrl (xxx)>  status  ==> command from sp_ctrl utility...
Read more

ORA-1092 : opitsk aborting process

By
sharing This error shown when load high from database and unix server(as we have unix type veritas cluster ) detect hang and db failover to another node. even in alertlog show only one errror and no other info(no trace file generation) trace cause so  in this case below is help to trace(generate trace file immediate when impact time by using below mentod) and raise case to vedor and upload trace file(even if you can able to trace cause from file as you can) Hanganalyze need to be collected when the situation occurs, below are the steps to perform such task.  Hanganalyze  sqlplus '/ as sysdba'  oradebug setmypid  oradebug unlimit  oradebug hanganalyze 3  -- Wait one minute before getting the second hanganalyze  oradebug hanganalyze 3  oradebug tracefile_name  exit  Thanks for the visit !  Any doubts or correction/suggestions, please comment below it helps me to improve in further posts.
Read more