troubleshooting时需要查询listener的日记,突然发现监听日记好几个月没有写日记了,如下:
[oracle@rac2 log]$ ls -ltrh
total 2.1G
-rw-r----- 1 oracle oinstall 546M Jan 9 2014 listener_rac2_20140109.log
-rw-r----- 1 oracle oinstall 425M Feb 11 2014 listener_rac2_20140211.log
-rw-r----- 1 oracle oinstall 636M Mar 11 2014 listener_rac2_20140311.log
-rw-r----- 1 oracle oinstall 370M Mar 24 17:50 listener_rac2_20140430.log
-rw-r----- 1 oracle oinstall 17M May 1 09:19 listener_rac2.log
-rw-r----- 1 oracle oinstall 116M Sep 17 16:33 sqlnet_20140917.log
-rw-r----- 1 oracle oinstall 8.8K Sep 17 16:48 sqlnet.log
解决办法:
LSNRCTL> show log_status
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
LISTENER parameter "log_status" set to OFF
The command completed successfully
LSNRCTL> set log_status on
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
LISTENER parameter "log_status" set to ON
The command completed successfully
[oracle@rac2 log]$ ls -ltrh
total 2.1G
-rw-r----- 1 oracle oinstall 546M Jan 9 2014 listener_rac2_20140109.log
-rw-r----- 1 oracle oinstall 425M Feb 11 2014 listener_rac2_20140211.log
-rw-r----- 1 oracle oinstall 636M Mar 11 2014 listener_rac2_20140311.log
-rw-r----- 1 oracle oinstall 370M Mar 24 17:50 listener_rac2_20140430.log
-rw-r----- 1 oracle oinstall 116M Sep 17 16:33 sqlnet_20140917.log
-rw-r----- 1 oracle oinstall 8.8K Sep 17 16:48 sqlnet.log
-rw-r----- 1 oracle oinstall 17M Sep 17 17:04 listener_rac2.log