ralph_rea
asked on
Oracle tnsping slow
Hi experts,
I've Oracle 11.2.0.4.0 running on windows server 2003 64-bit but when I tried to ping the listener with tnsping it is quite long time to give a responce. The network seems ok, below the response times client side and server side:
CLIENT SIDE
C:\>tnsping ORCL_PROD 5
TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 03-APR-2015 10:45:24
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
C:\oracle\product\10.2.0\c
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION= (ADDRESS_LIST= (ADDRESS= (PROTOCOL=TCP) (Host=170.10.10.20) (Port=1521))) (CONNECT_DATA= (SERVICE_NAME=ORCL)))
OK (3140 msec)
OK (2150 msec)
OK (540 msec)
OK (850 msec)
OK (2100 msec)
SERVER SIDE
C:\>tnsping ORCL_PROD 5
OK (0 msec)
OK (10 msec)
OK (10 msec)
OK (0 msec)
OK (0 msec)
What may be the problem?
What Can I check?
Thanks in advance!
I've Oracle 11.2.0.4.0 running on windows server 2003 64-bit but when I tried to ping the listener with tnsping it is quite long time to give a responce. The network seems ok, below the response times client side and server side:
CLIENT SIDE
C:\>tnsping ORCL_PROD 5
TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 03-APR-2015 10:45:24
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
C:\oracle\product\10.2.0\c
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION= (ADDRESS_LIST= (ADDRESS= (PROTOCOL=TCP) (Host=170.10.10.20) (Port=1521))) (CONNECT_DATA= (SERVICE_NAME=ORCL)))
OK (3140 msec)
OK (2150 msec)
OK (540 msec)
OK (850 msec)
OK (2100 msec)
SERVER SIDE
C:\>tnsping ORCL_PROD 5
OK (0 msec)
OK (10 msec)
OK (10 msec)
OK (0 msec)
OK (0 msec)
What may be the problem?
What Can I check?
Thanks in advance!
SOLUTION
![Avatar of Guy Hengel [angelIII / a3]](https://filedb.experts-exchange.com/files/public/2013/11/25/ddbe0ea6-aa6e-4279-b781-57b735dd3ea0.jpeg){kind=small}
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
CLIENT SIDE:
C:\>tracert 170.10.10.20
Tracing route to ORCL [170.10.10.20]
over a maximum of 30 hops:
1 33 ms 31 ms 33 ms 10.10.11.1
2 75 ms 392 ms 60 ms 190.100.200.110
3 365 ms 37 ms 45 ms ORCL [170.10.10.20]
SERVER SIDE:
C:\>tracert 170.10.10.20
Tracing route to ORCL [170.10.10.20]
over a maximum of 30 hops:
1 <1 ms <1 ms <1 ms ORCL [170.10.10.20]
Trace complete.
Any idea??
C:\>tracert 170.10.10.20
Tracing route to ORCL [170.10.10.20]
over a maximum of 30 hops:
1 33 ms 31 ms 33 ms 10.10.11.1
2 75 ms 392 ms 60 ms 190.100.200.110
3 365 ms 37 ms 45 ms ORCL [170.10.10.20]
SERVER SIDE:
C:\>tracert 170.10.10.20
Tracing route to ORCL [170.10.10.20]
over a maximum of 30 hops:
1 <1 ms <1 ms <1 ms ORCL [170.10.10.20]
Trace complete.
Any idea??
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
tracert 170.10.10.20
Check the network cables.