listener trace的一些設定

blueocean926發表於2010-01-12
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

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/48010/viewspace-1030494/,如需轉載,請註明出處,否則將追究法律責任。

相關文章