tnsping本机 延迟能到 7220 msec,什么原因呢,大虾门能给个建议吗?拜托了,先谢谢各位了
具体内容如下:
Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.
C:\Documents and Settings\Administrator>tnsping bda
TNS Ping Utility for 32-bit Windows: Version 11.1.0.7.0 - Production on 05-SEP-2
012 17:52:09
Copyright (c) 1997, 2008, Oracle. All rights reserved.
Used parameter files:
G:\app\Administrator\product\11.1.0\db_1\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS=(PROTOCOL=TCP)(HOST=vbprolims.VBPR
O.vitalbridge.com.cn)(PORT=1522)) (CONNECT_DATA= (SERVER=DEDICATED) (SERVICE_NAM
E=BDA)))
OK (20 msec)
C:\Documents and Settings\Administrator>tnsping bda
TNS Ping Utility for 32-bit Windows: Version 11.1.0.7.0 - Production on 05-SEP-2
012 17:52:12
Copyright (c) 1997, 2008, Oracle. All rights reserved.
Used parameter files:
G:\app\Administrator\product\11.1.0\db_1\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS=(PROTOCOL=TCP)(HOST=vbprolims.VBPR
O.vitalbridge.com.cn)(PORT=1522)) (CONNECT_DATA= (SERVER=DEDICATED) (SERVICE_NAM
E=BDA)))
OK (6660 msec)
C:\Documents and Settings\Administrator>tnsping bda
TNS Ping Utility for 32-bit Windows: Version 11.1.0.7.0 - Production on 05-SEP-2
012 17:52:22
Copyright (c) 1997, 2008, Oracle. All rights reserved.
Used parameter files:
G:\app\Administrator\product\11.1.0\db_1\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS=(PROTOCOL=TCP)(HOST=vbprolims.VBPR
O.vitalbridge.com.cn)(PORT=1522)) (CONNECT_DATA= (SERVER=DEDICATED) (SERVICE_NAM
E=BDA)))
OK (7220 msec)
C:\Documents and Settings\Administrator>tnsping bda
TNS Ping Utility for 32-bit Windows: Version 11.1.0.7.0 - Production on 05-SEP-2
012 17:52:33
Copyright (c) 1997, 2008, Oracle. All rights reserved.
Used parameter files:
G:\app\Administrator\product\11.1.0\db_1\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS=(PROTOCOL=TCP)(HOST=vbprolims.VBPR
O.vitalbridge.com.cn)(PORT=1522)) (CONNECT_DATA= (SERVER=DEDICATED) (SERVICE_NAM
E=BDA)))
OK (6610 msec)
C:\Documents and Settings\Administrator>lsnrctl
LSNRCTL for 32-bit Windows: Version 11.1.0.7.0 - Production on 05-SEP-2012 18:00
:52
Copyright (c) 1991, 2008, Oracle. All rights reserved.
Welcome to LSNRCTL, type "help" for information.
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1522)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 11.1.0.7.0 - Produ
ction
Start Date 05-SEP-2012 17:42:24
Uptime 0 days 0 hr. 19 min. 27 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File G:\app\Administrator\product\11.1.0\db_1\network\admin
\listener.ora
Listener Log File g:\app\administrator\diag\tnslsnr\vbprolims\listener\a
lert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1522ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=vbprolims.VBPRO.vitalbridge.com.cn)(
PORT=1522)))
Services Summary...
Service "BDA" has 1 instance(s).
Instance "BDA", status UNKNOWN, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "WATPRO" has 1 instance(s).
Instance "WATPRO", status UNKNOWN, has 1 handler(s) for this service...
Service "WATSON" has 1 instance(s).
Instance "WATSON", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL>