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!
Oracle DatabaseDatabasesWindows OS
Last Comment
slightwv (䄆 Netminder)
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
tracert 170.10.10.20
Check the network cables.