Oracle資料庫監聽非常慢，基本hang住故障處理

Oracle資料庫監聽非常慢，基本hang住故障處理

測試人員郵件反饋：
 訂購資料庫的串連非常慢，甚至是無法串連，想要我檢查看看。

經查看：
 Oracle@wdatest11:~/app/admin/wdadb/adump> lsnrctl status

LSNRCTL for Linux: Version 11.1.0.7.0 - Production on 17-JUN-2014 18:15:47

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=wdatest11)(PORT=1521)))  ## 到這裡，hang住了，一直沒有響應

從其他主機做了個tnsping測試：
 oracle@IBlvs02:/u01/app/oracle/11.2/db_1/network/admin> tnsping wdatest
 

TNS Ping Utility for Linux: Version 11.2.0.3.0 - Production on 17-JUN-2014 17:53:20
 

Copyright (c) 1997, 2011, Oracle.  All rights reserved.

Used parameter files:
 

Used TNSNAMES adapter to resolve the alias
 Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.121.134)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = wdadb)))
 OK (14760 msec)    ## 可見響應也是非常慢的。
 

oracle@IBlvs02:/u01/app/oracle/11.2/db_1/network/admin> tnsping wdatest
 

TNS Ping Utility for Linux: Version 11.2.0.3.0 - Production on 17-JUN-2014 17:54:20
 

Copyright (c) 1997, 2011, Oracle.  All rights reserved.
 

Used parameter files:
 

Used TNSNAMES adapter to resolve the alias
 
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.121.134)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = wdadb)))    ## 這裡也是hang住，一直沒有響應

最後檢查DNS配置時，發現有：
 wdatest11:~ # cat /etc/resolv.conf
 nameserver 211.141.90.68
 系統配置有DNS，這是內網主機，根本用不到DNS，所以把這個DNS去掉後恢複正常。
 其實可以考慮開啟listener的trace進行查看的。

--------------------------------------------------------------------------------

Linux-6-64下安裝Oracle 12C筆記

在CentOS 6.4下安裝Oracle 11gR2(x64)

Oracle 11gR2 在VMWare虛擬機器中安裝步驟

Debian 下 安裝 Oracle 11g XE R2

如何診斷Oracle資料庫運行緩慢或hang住的問題 

--------------------------------------------------------------------------------