oracle监听延迟,求教,tnsping本机延迟非常大,求解决思路

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>

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值