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部落格 ” ,連結:http://blog.itpub.net/48010/viewspace-1030494/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 設定listener的安全性
- 設定listener的安全機制
- 設定listener 的安全機制
- 為listener設定口令!
- 設定 oracle event traceOracle
- 設定會話TRACE的方法(二)會話
- 設定會話TRACE的方法(一)會話
- oracle Database Event trace 設定OracleDatabase
- How to Run and View a Listener Trace. [ID 147446.1]View
- 關於listener.ora中的HOST設定
- Oracle(listener.sqlnet.tnsnames)設定OracleSQL
- ORACLE listener監聽設定密碼Oracle密碼
- 設定Event事件來追蹤Trace事件
- 建立定期清理listener,trace檔案的shell指令碼指令碼
- Oracle清理trace、alert、aud、listener.log檔案Oracle
- oracle清理trace、alert、aud、listener等日誌檔案Oracle
- 設定 Oracle 監聽器密碼(LISTENER)Oracle密碼
- Oracle Listener設定密碼示例說明Oracle密碼
- oracle Database Event trace 設定【Blog 搬家】OracleDatabase
- 【TRACE】SQL*Net trace 通過windows客戶端設定,你不得不防SQLWindows客戶端
- listener start fail TNS-12555 利用trace找到問題AI
- Oracle Net的Trace追蹤(包括listener.ora和sqlnet.ora的配置)OracleSQL
- pl/sql developer的一些設定SQLDeveloper
- 關於文字特性的一些設定
- Data Guard相關的一些設定
- 定時刪除bdump裡的trace檔案
- 定時刪除udump裡的trace檔案
- 一個確定trace檔案的指令碼指令碼
- 【TRACE】如何設定或動態跟蹤Oracle net偵聽器Oracle
- scrapy 一些設定和問題
- 【BASIS】關於Hana的一些資源設定
- JVM引數設定的一些參考方法JVM
- Windows Server 2008的一些安全設定WindowsServer
- local_listener ,remote_listener 的配置REM
- oracle listener 靜態監聽與動態監聽的一些小事Oracle
- oracle 9i、10g、11g資料庫設定listener密碼的方法Oracle資料庫密碼
- 客戶端設定了load balance , Server端就不用remote_listener了吧?客戶端ServerREM
- RAC 11GR3雙網段設定兩套VIP SCAN IP以及LISTENER