[Oracle] Oracle11g listener.log清除步驟

Oracle listener.log超過4G之後就不回再往裡面寫資料，所以需要定期備份和清除listener.log中的資料.

如下為oracle11g listener.log清除步驟

1. ps -ef | grep tns   檢視DB是否使用了多個listener.

2. lsnrctl status listenerx  檢視listener.log在哪個位置(路徑)

3. lsnrctl

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

LSNRCTL> set current_listener {listener_name}            #由於DB可能使用了多個listener，需要指定具體的listener

LSNRCTL> set log_status off

LSNRCTL> exit

4. mv listener.log listener.log.xxxxxxxx

5. lsnrctl

LSNRCTL> set log_status on

LSNRCTL> exit


6. tar&gzip 壓縮 listener.log.xxxxxxxx