对oracle监听做trace

参考：http://docs.oracle.com/cd/B19306_01/network.102/b14212/troublestng.htm#sthref1710

SQL> select * from V$version;


BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Prod
PL/SQL Release 10.2.0.2.0 - Production
CORE    10.2.0.2.0      Production
TNS for Linux: Version 10.2.0.2.0 - Production
NLSRTL Version 10.2.0.2.0 - Production


[oracle@ocm54m5 trace]$ pwd
/u01/app/oracle/product/10.2.0/db_1/network/trace


[oracle@ocm54m5 trace]$ ls

方法一：通过命令实现

对默认监听listener做trace


命令： lsnrctl trace listener_name level


level可以是数字也可以是下面的值
off (equivalent to 0) provides no tracing
user (equivalent to 4) traces to identify user-induced error conditions
admin (equivalent to 6) traces to identify installation-specific problems
support (equivalent to 16) provides trace information for troubleshooting information for Oracle Support Services


可选的数字从0到16
The trace level value can either be a value within the range of 0 (zero) to 16 (where 0 is no tracing and 16 represents the maximum amount of tracing) or a value of off, admin, user, or support.

如下：
[oracle@ocm54m5 trace]$ lsnrctl trace listener admin


LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 13-FEB-2014 16:00:23


Copyright (c) 1991, 2005, Oracle.  All rights reserved.


Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ocm54m5)(PORT=1521)))
Opened trace file: /u01/app/oracle/product/10.2.0/db_1/network/trace/listener.trc
The command completed successfully
[oracle@ocm54m5 trace]$ ls
listener.trc

方法二：通过listener.ora中参数实现

新增以下参数，取值和方法1一样。
TRACE_LEVEL_listener_name

LSNR2=
  (DESCRIPTION=
    (ADDRESS_LIST=
      (ADDRESS=(PROTOCOL=tcp)(HOST=ocm54m5)(PORT=1526))
      (ADDRESS=(PROTOCOL=ipc)(KEY=extproc1))))


trace_level_lsnr2=support

然后再重启下监听 ，可以看到trace文件生成了：
[oracle@ocm54m5 trace]$ ls
lsnr2.trc
[oracle@ocm54m5 trace]$ 

格式化输出

[oracle@ocm54m5 trace]$ trcasst lsnr2.trc > aa.txt


[oracle@ocm54m5 trace]$  ls
aa.txt  lsnr2.trc