Conection failure - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 19 of 19

Thread: Conection failure

  1. #11
    Join Date
    Dec 2000
    Location
    Brazil / São Paulo
    Posts
    97
    Quote 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

  2. #12
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    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.

  3. #13
    Join Date
    Dec 2000
    Location
    Brazil / São Paulo
    Posts
    97

    Smile

    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

  4. #14
    Join Date
    Dec 2000
    Location
    Brazil / São Paulo
    Posts
    97
    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

  5. #15
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    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.

  6. #16
    Join Date
    Aug 2007
    Posts
    1
    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

  7. #17
    Join Date
    Sep 2000
    Location
    Sao Paulo,SP,Brazil, Earth, Milky Way
    Posts
    350
    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

  8. #18
    Join Date
    Apr 2001
    Location
    Vadodara, India
    Posts
    249
    Problem is related to network.

    If your internal network is OK.

    VPN broad band service provider will better understood this problem.

  9. #19
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Quote 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
  •  



Click Here to Expand Forum to Full Width