tnsping响应慢，是什么问题？正常情况下不到1s,请大神们看看。。。
TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 26-OCT-2021 15:44:21
Copyright (c) 1997, 2010, Oracle. All rights reserved.
Used parameter files:
D:\app\dwli\product\11.2.0\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.28.2.30)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = szmesp)))
OK (1630 msec)
C:\Users\dwli>tnsping szproddb
TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 26-OCT-2021 15:44:24
Copyright (c) 1997, 2010, Oracle. All rights reserved.
Used parameter files:
D:\app\dwli\product\11.2.0\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.28.2.30)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = szmesp)))
OK (670 msec)
有人说可以，把日志删除，会好点，但解决不了问题。
30 08 1 1 * /export/home/oracle/script/clearLsnLog.sh > /dev/null 2>&1
oracle@CSZS98> more /export/home/oracle/script/clearLsnLog.sh
rq=` date +"%Y%m%d%S" `
mv $ORACLE_HOME/network/log/listener.log $ORACLE_HOME/network/log/listener_$rq.log
lsnrctl set log_status off
cp /dev/null $ORACLE_HOME/network/log/listener.log
lsnrctl set log_status on
不知道大神们有好的方法没？
评论
有用 0
C:\Users\dwli>tnsping szproddb
TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 26-OCT-2021 15:46:12
Copyright (c) 1997, 2010, Oracle. All rights reserved.
Used parameter files:
D:\app\dwli\product\11.2.0\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.28.2.30)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = szmesp)))
OK (3870 msec)
还有4s的。
评论 有用 0有如下现象：
Server CSZS167 is unable to fetch database result from oracle database server.
Error Detected:Exception calling "Open" with "0" argument(s): "ORA-12170: TNS:Connect timeout occurred
"
评论 有用 0
