listener trace的一些设置
TRACE_LEVEL_ = 16
TRACE_FILE_ = listener
TRACE_DIRECTORY_ =
TRACE_TIMESTAMP_ = ON
TRACE_FILELEN_listenername = 102400
TRACE_FILENO_listenername = 2
TRACE_LEVEL_LISTENER_SERVER1 = 16
TRACE_FILE_LISTENER_SERVER1 = LISTENER_SERVER1.trc
TRACE_DIRECTORY_LISTENER_SERVER1 = /oracle/app/oracle/product/10.2.0/db_1/network/log/
TRACE_TIMESTAMP_LISTENER_SERVER1 = ON
TRACE_FILELEN_LISTENER_SERVER1 = 102400
TRACE_FILENO_LISTENER_SERVER1 = 2
LSNRCTL> set current_listener LISTENER_SERVER1
Current Listener is LISTENER_SERVER1
LSNRCTL> show trc_directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=server1-vip)(PORT=1522)(IP=FIRST)))
LISTENER_SERVER1 parameter "trc_directory" set to /oracle/app/oracle/product/10.2.0/db_1/network/trace/
The command completed successfully
LSNRCTL> show trc_level
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=server1-vip)(PORT=1522)(IP=FIRST)))
LISTENER_SERVER1 parameter "trc_level" set to off
The command completed successfully
LSNRCTL> set trc_level admin
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=server1-vip)(PORT=1522)(IP=FIRST)))
LISTENER_SERVER1 parameter "trc_level" set to admin
The command completed successfully
[oracle@server1 log]$ ls -ltr
total 23928
-rw-r----- 1 oracle dba 3406 Apr 23 2009 sqlnet.log
-rw-r----- 1 oracle dba 0 Jan 6 04:53 listener_server12.trc
-rw-r----- 1 oracle dba 21348136 Jan 6 04:56 listener_server11.trc
-rw-r----- 1 oracle dba 3113840 Jan 6 04:56 listener_server1.log
[@more@]er
TRACE_FILE_
TRACE_DIRECTORY_
TRACE_TIMESTAMP_
TRACE_FILELEN_listenername = 102400
TRACE_FILENO_listenername = 2
TRACE_LEVEL_LISTENER_SERVER1 = 16
TRACE_FILE_LISTENER_SERVER1 = LISTENER_SERVER1.trc
TRACE_DIRECTORY_LISTENER_SERVER1 = /oracle/app/oracle/product/10.2.0/db_1/network/log/
TRACE_TIMESTAMP_LISTENER_SERVER1 = ON
TRACE_FILELEN_LISTENER_SERVER1 = 102400
TRACE_FILENO_LISTENER_SERVER1 = 2
LSNRCTL> set current_listener LISTENER_SERVER1
Current Listener is LISTENER_SERVER1
LSNRCTL> show trc_directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=server1-vip)(PORT=1522)(IP=FIRST)))
LISTENER_SERVER1 parameter "trc_directory" set to /oracle/app/oracle/product/10.2.0/db_1/network/trace/
The command completed successfully
LSNRCTL> show trc_level
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=server1-vip)(PORT=1522)(IP=FIRST)))
LISTENER_SERVER1 parameter "trc_level" set to off
The command completed successfully
LSNRCTL> set trc_level admin
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=server1-vip)(PORT=1522)(IP=FIRST)))
LISTENER_SERVER1 parameter "trc_level" set to admin
The command completed successfully
[oracle@server1 log]$ ls -ltr
total 23928
-rw-r----- 1 oracle dba 3406 Apr 23 2009 sqlnet.log
-rw-r----- 1 oracle dba 0 Jan 6 04:53 listener_server12.trc
-rw-r----- 1 oracle dba 21348136 Jan 6 04:56 listener_server11.trc
-rw-r----- 1 oracle dba 3113840 Jan 6 04:56 listener_server1.log
[@more@]er
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/48010/viewspace-1030494/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
字符集合转换问题
下一篇：
pga使用的一些资料
请登录后发表评论
登录
全部评论
