-
Originally Posted by PAVB
you have to answer my questions yet... patience is growing thin
I'm sorry
All the servers are in one date to center 100km of this place. Conection VPN broad band .
Code:
tnsping grp3 10
TNS Ping Utility for Linux: Version 10.2.0.3.0 - Production on 26-JUL-2007 09:34:36
Copyright (c) 1997, 2006, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (LOAD_BALANCE = yes) (ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = xxxx)) (ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = xxxx)) (CONNECT_DATA = (SERVICE_NAME = GRP3) (server=dedicated) (FAILOVER_MODE = (TYPE = session) (METHOD = basic) (RETRIES = 180) (DELAY = 50))))
OK (30 msec)
OK (20 msec)
OK (3020 msec)
OK (20 msec)
OK (20 msec)
OK (20 msec)
OK (20 msec)
OK (20 msec)
OK (3020 msec)
OK (20 msec)
Code:
tnsping grp2 10
TNS Ping Utility for Linux: Version 10.2.0.3.0 - Production on 26-JUL-2007 09:36:51
Copyright (c) 1997, 2006, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (LOAD_BALANCE = yes) (ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = xxxx)) (ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = xxxx)) (CONNECT_DATA = (SERVICE_NAME = GRP2) (server=dedicated) (FAILOVER_MODE = (TYPE = session) (METHOD = basic) (RETRIES = 180) (DELAY = 50))))
OK (20 msec)
OK (20 msec)
OK (20 msec)
OK (20 msec)
OK (230 msec)
OK (230 msec)
OK (20 msec)
OK (20 msec)
OK (20 msec)
OK (20 msec)
Code:
tnsping grp1 10
TNS Ping Utility for Linux: Version 10.2.0.3.0 - Production on 26-JUL-2007 09:37:28
Copyright (c) 1997, 2006, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (LOAD_BALANCE = yes) (ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = xxxx)) (ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = xxxx)) (CONNECT_DATA = (SERVICE_NAME = GRP1) (SERVER=DEDICATED) (FAILOVER_MODE = (TYPE = session) (METHOD = basic) (RETRIES = 180) (DELAY = 50))))
OK (20 msec)
OK (20 msec)
OK (20 msec)
OK (230 msec)
OK (20 msec)
OK (20 msec)
OK (40 msec)
OK (70 msec)
OK (20 msec)
OK (30 msec)
Márcio de Souza Almeida
DBA Oracle / SQLServer / PostgreSQL
Rua Cupa, 139 Apto 85 A
Penha - São Paulo - SP
03640-000 - Brasil
http://www.directory.com.br
-
Look at your elapsed times during ping... you have serious network issues, very little you can do from the database side.
Take the logs with you and ask network guys to fix it; be pushy, claim production environment is in jeopardy and, network is going to get the blame.
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
The two local servers are in the same net have access it the same remote servers, however only one presents problems.
I will be seeing with my staff of net.
Márcio de Souza Almeida
DBA Oracle / SQLServer / PostgreSQL
Rua Cupa, 139 Apto 85 A
Penha - São Paulo - SP
03640-000 - Brasil
http://www.directory.com.br
-
Exists some another test that I can make? The net staff did not obtain to identify the problem.
Márcio de Souza Almeida
DBA Oracle / SQLServer / PostgreSQL
Rua Cupa, 139 Apto 85 A
Penha - São Paulo - SP
03640-000 - Brasil
http://www.directory.com.br
-
Ask network guys to do ping and tracert from end to end
You can also find in the internet sites that allows you to ping/tracert from locations all around the world.
IF your local ping/tracert is bad and
remote ping/tracert is good
then issue is more likely in your source end.
IF your local ping/tracert is bad and
remote ping/tracert is bad too
then issue is more likely in your target end.
Your initial test showed a very unreliable network you cannot go from 20ms to 3020ms in back to back pings and have network guys telling you nothing bad is happening.
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
Cause:
Oracle suggest that this error indicates that the address specified (in the alias definition) is not valid.
Possible Remedies:
Oracle suggest ensuring that the ADDRESS parameters (in the TNSNAMES.ORA file) have been entered correctly; the most likely incorrect parameter is the node name.
Ensure that the executable for the server exists (perhaps "oracle" is missing.)
If the protocol is TCP/IP, edit the TNSNAMES.ORA file to change the host name to a numeric IP address and try again.
It could be a network connectivity problem. Try pinging the host. This error has been observed on a laptop when the database was local, TCP/IP protocol used but the network card had been removed.
Last edited by davey23uk; 08-03-2007 at 10:39 AM.
Reason: dont use stupid colours
-
Yes, net fluctuations like that are NEVER a sign of any good... Marcio, another thing to do to is give more info to your net staff , TRACEing your connections, if you are using direct sql*net connection : in your client machine´s \oracle_home\network\admin\sqlnet.ora file add lines like :
TRACE_FILE_CLIENT=arq_trace
TRACE_DIRECTORY_CLIENT=desiredpath
TRACE_LEVEL_CLIENT=16
LOG_DIRECTORY_CLIENT=desiredpath
LOG_FILE_CLIENT=sql_log
with this, the specified trace/log files will be generated with packet dumps and other good stuff, useful for net guys....
Regards,
Chiappa
-
Problem is related to network.
If your internal network is OK.
VPN broad band service provider will better understood this problem.
-
Originally Posted by bhattnirav
Problem is related to network
Thanks God you settled such a controversial point
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|