配置SQLNET.ORA檔案跟蹤客戶端連線
在$ORACLE_HOME/network/admin/sqlnet.ora檔案新增如下跟蹤引數:
TRACE_LEVEL_CLIENT=16
TRACE_FILE_CLIENT=CLIENT
TRACE_TIMESTAMP_CLIENT=ON
trace_directory_client=/home/oracle
[oracle@xuh ~]$ pwd
/home/oracle
[oracle@xuh ~]$ ls -l client*
-rw-r----- 1 oracle oinstall 130488 Jan 11 20:29 client_6966.trc
-rw-r----- 1 oracle oinstall 28096 Jan 11 20:51 client_7065.trc
-rw-r----- 1 oracle oinstall 28118 Jan 11 20:51 client_7068.trc
-rw-r----- 1 oracle oinstall 11956846 Jan 11 20:53 client_7098.trc
-rw-r----- 1 oracle oinstall 142884 Jan 11 20:57 client_7115.trc
-rw-r----- 1 oracle oinstall 142884 Jan 11 20:57 client_7120.trc
-rw-r----- 1 oracle oinstall 147248 Jan 11 21:20 client_7190.trc
[oracle@xuh admin]$ sqlplus system/oracle@mrhua #客戶端發起一次連線,就會產生一個跟蹤檔案
SQL*Plus: Release 10.2.0.5.0 - Production on Mon Jan 11 20:29:34 2016
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
ERROR:
ORA-12537: TNS:connection closed
Enter user-name:
[oracle@xuh ~]$ more client_6966.trc
...skipping
[11-JAN-2016 20:29:17:908] niomapnserror: entry
[11-JAN-2016 20:29:17:908] niqme: entry
[11-JAN-2016 20:29:17:908] niqme: reporting NS-12537 error as ORA-12537
[11-JAN-2016 20:29:17:908] niqme: exit
[11-JAN-2016 20:29:17:908] niomapnserror: exit
[11-JAN-2016 20:29:17:908] niotns: Couldn't connect, returning 12537
[11-JAN-2016 20:29:17:909] niotns: exit
[11-JAN-2016 20:29:17:909] nigcui: entry
[11-JAN-2016 20:29:17:909] nigcui: Clr User Interrupt: hdl=1, prc=0x8c044618, ctx=0x5994870.
[11-JAN-2016 20:29:17:909] nigcui: exit (0)
[11-JAN-2016 20:29:17:909] nsbfrfl: entry
[11-JAN-2016 20:29:17:909] nsbrfr: entry
[11-JAN-2016 20:29:17:909] nsbrfr: nsbfs at 0x59abf20, data at 0x59abfd0.
[11-JAN-2016 20:29:17:909] nsbrfr: normal exit
[11-JAN-2016 20:29:17:909] nsbrfr: entry
[11-JAN-2016 20:29:17:909] nsbrfr: nsbfs at 0x59ac7f0, data at 0x59ac8a0.
[11-JAN-2016 20:29:17:909] nsbrfr: normal exit
[11-JAN-2016 20:29:17:909] nsbrfr: entry
[11-JAN-2016 20:29:17:909] nsbrfr: nsbfs at 0x59a80d0, data at 0x59a8180.
[11-JAN-2016 20:29:17:909] nsbrfr: normal exit
[11-JAN-2016 20:29:17:909] nsbfrfl: normal exit
[11-JAN-2016 20:29:17:909] nttdisc: entry
[11-JAN-2016 20:29:17:909] nttdisc: Closed socket 8
[11-JAN-2016 20:29:17:909] nttdisc: exit
[11-JAN-2016 20:29:17:909] nigtrm: Count in the NI global area is now 1
[11-JAN-2016 20:29:17:909] nigtrm: Count in the NL global area is now 1
[11-JAN-2016 20:29:19:235] nigini: entry
[11-JAN-2016 20:29:19:235] nigini: Count in the NL global area is now 2
[11-JAN-2016 20:29:19:235] nigini: Count in NI global area now: 2
[11-JAN-2016 20:29:19:235] nigini: exit
[11-JAN-2016 20:29:19:235] nigconcbs: entry
[11-JAN-2016 20:29:19:235] nigconcbs: exit
[11-JAN-2016 20:29:19:235] niotns: entry
[11-JAN-2016 20:29:19:235] niotns: niotns: setting up interrupt handler...
[11-JAN-2016 20:29:19:235] nigsui: entry
--More--(21%)
透過分析跟蹤檔案,以便我們更好的鎖定問題、分析問題、解決問題!
TRACE_LEVEL_CLIENT=16
TRACE_FILE_CLIENT=CLIENT
TRACE_TIMESTAMP_CLIENT=ON
trace_directory_client=/home/oracle
[oracle@xuh ~]$ pwd
/home/oracle
[oracle@xuh ~]$ ls -l client*
-rw-r----- 1 oracle oinstall 130488 Jan 11 20:29 client_6966.trc
-rw-r----- 1 oracle oinstall 28096 Jan 11 20:51 client_7065.trc
-rw-r----- 1 oracle oinstall 28118 Jan 11 20:51 client_7068.trc
-rw-r----- 1 oracle oinstall 11956846 Jan 11 20:53 client_7098.trc
-rw-r----- 1 oracle oinstall 142884 Jan 11 20:57 client_7115.trc
-rw-r----- 1 oracle oinstall 142884 Jan 11 20:57 client_7120.trc
-rw-r----- 1 oracle oinstall 147248 Jan 11 21:20 client_7190.trc
[oracle@xuh admin]$ sqlplus system/oracle@mrhua #客戶端發起一次連線,就會產生一個跟蹤檔案
SQL*Plus: Release 10.2.0.5.0 - Production on Mon Jan 11 20:29:34 2016
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
ERROR:
ORA-12537: TNS:connection closed
Enter user-name:
[oracle@xuh ~]$ more client_6966.trc
...skipping
[11-JAN-2016 20:29:17:908] niomapnserror: entry
[11-JAN-2016 20:29:17:908] niqme: entry
[11-JAN-2016 20:29:17:908] niqme: reporting NS-12537 error as ORA-12537
[11-JAN-2016 20:29:17:908] niqme: exit
[11-JAN-2016 20:29:17:908] niomapnserror: exit
[11-JAN-2016 20:29:17:908] niotns: Couldn't connect, returning 12537
[11-JAN-2016 20:29:17:909] niotns: exit
[11-JAN-2016 20:29:17:909] nigcui: entry
[11-JAN-2016 20:29:17:909] nigcui: Clr User Interrupt: hdl=1, prc=0x8c044618, ctx=0x5994870.
[11-JAN-2016 20:29:17:909] nigcui: exit (0)
[11-JAN-2016 20:29:17:909] nsbfrfl: entry
[11-JAN-2016 20:29:17:909] nsbrfr: entry
[11-JAN-2016 20:29:17:909] nsbrfr: nsbfs at 0x59abf20, data at 0x59abfd0.
[11-JAN-2016 20:29:17:909] nsbrfr: normal exit
[11-JAN-2016 20:29:17:909] nsbrfr: entry
[11-JAN-2016 20:29:17:909] nsbrfr: nsbfs at 0x59ac7f0, data at 0x59ac8a0.
[11-JAN-2016 20:29:17:909] nsbrfr: normal exit
[11-JAN-2016 20:29:17:909] nsbrfr: entry
[11-JAN-2016 20:29:17:909] nsbrfr: nsbfs at 0x59a80d0, data at 0x59a8180.
[11-JAN-2016 20:29:17:909] nsbrfr: normal exit
[11-JAN-2016 20:29:17:909] nsbfrfl: normal exit
[11-JAN-2016 20:29:17:909] nttdisc: entry
[11-JAN-2016 20:29:17:909] nttdisc: Closed socket 8
[11-JAN-2016 20:29:17:909] nttdisc: exit
[11-JAN-2016 20:29:17:909] nigtrm: Count in the NI global area is now 1
[11-JAN-2016 20:29:17:909] nigtrm: Count in the NL global area is now 1
[11-JAN-2016 20:29:19:235] nigini: entry
[11-JAN-2016 20:29:19:235] nigini: Count in the NL global area is now 2
[11-JAN-2016 20:29:19:235] nigini: Count in NI global area now: 2
[11-JAN-2016 20:29:19:235] nigini: exit
[11-JAN-2016 20:29:19:235] nigconcbs: entry
[11-JAN-2016 20:29:19:235] nigconcbs: exit
[11-JAN-2016 20:29:19:235] niotns: entry
[11-JAN-2016 20:29:19:235] niotns: niotns: setting up interrupt handler...
[11-JAN-2016 20:29:19:235] nigsui: entry
--More--(21%)
透過分析跟蹤檔案,以便我們更好的鎖定問題、分析問題、解決問題!
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/30310891/viewspace-1974811/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Trace the connections being made to the Oracle database-客戶端跟蹤連線OracleDatabase客戶端
- 跟蹤客戶端執行的SQL客戶端SQL
- impala客戶端連線客戶端
- Redis客戶端連線Redis客戶端
- 客戶端配置檔案tnsname.ora客戶端
- 配置ORACLE 客戶端連線到資料庫Oracle客戶端資料庫
- 配置TimesTen客戶端連線[TimesTen運維]客戶端運維
- PL/SQL developer 遠端連線資料庫 客戶端配置SQLDeveloper資料庫客戶端
- Oracle 11g DRCP連線跟蹤配置Oracle
- mysql、redis 客戶端連線池MySqlRedis客戶端
- vncserver建立與客戶端連線VNCServer客戶端
- 檔案-跟蹤檔案
- Tivoli AIX客戶端配置檔案的設定AI客戶端
- Redis客戶端連線數DevOpsRedis客戶端dev
- 從客戶端連線ASM例項客戶端ASM
- [zt] oracle跟蹤檔案與跟蹤事件Oracle事件
- oracle跟蹤檔案與跟蹤事件(zt)Oracle事件
- oracle跟蹤檔案和跟蹤事件(zt)Oracle事件
- 配置tnsping跟蹤來診斷Oracle Net連線Oracle
- Oracle跟蹤檔案Oracle
- [20171106]配置客戶端連線注意.txt客戶端
- RAC 11.2.0.3 客戶端軟體Toad連線配置 -- Mac版本客戶端Mac
- 如何配置oracle客戶端連線10g rac 資料庫Oracle客戶端資料庫
- Java 客戶端 Jedis和JedisPool 連線池Java客戶端
- Oracle客戶端連線伺服器教程Oracle客戶端伺服器
- 客戶端連線資料庫的方法客戶端資料庫
- 客戶端連線故障檢查流程手段客戶端
- Oracle跟蹤檔案trace檔案Oracle
- Oracle 19c中連線RMAN客戶端的連線方法Oracle客戶端
- 解析listener跟蹤檔案
- git 忽略跟蹤檔案Git
- 尋找跟蹤檔案
- 控制檔案的跟蹤檔案全文
- 使用 WebSocket 客戶端連線 MQTT 伺服器Web客戶端MQQT伺服器
- 客戶端怎麼連線到伺服器?客戶端伺服器
- MySQL client客戶端的四種連線方式MySqlclient客戶端
- linux之客戶端連線數統計Linux客戶端
- 如何配置WSUS客戶端客戶端