DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: TNS-03505: Failed to resolve name

  1. #1
    Join Date
    Apr 2001
    Location
    Vadodara, India
    Posts
    249

    TNS-03505: Failed to resolve name

    Dear All,

    I am getting following error while tnsping to my standby database.

    rlsdevraqas 1> tnsping qasst

    TNS Ping Utility for HPUX: Version 10.2.0.2.0 - Production on 29-SEP-2011 18:58: 13

    Copyright (c) 1997, 2005, Oracle. All rights reserved.

    Used parameter files:
    /oracle/QAS/102_64/network/admin/sqlnet.ora

    TNS-03505: Failed to resolve name


    --------------------------------------------------

    My tnsnames.ora file as below :


    --------------------------
    ################
    # Filename......: tnsnames.ora
    # Created.......: created by SAP AG, R/3 Rel. >= 6.10
    # Name..........:
    # Date..........:
    # @(#) $Id: //bc/700-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/TNSNAMES.ORA#4 $
    ################
    QAS.WORLD=
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS =
    (COMMUNITY = SAP.WORLD)
    (PROTOCOL = TCP)
    (HOST = rlsdev)
    (PORT = 1528)
    )
    )
    (CONNECT_DATA =
    (SID = QAS)
    (SERVICE = QAS)
    (GLOBAL_NAME = QAS.WORLD)
    )
    )

    qasst.WORLD =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS =
    (COMMUNITY = SAP.WORLD)
    (PROTOCOL = TCP)
    (HOST = rlsapdr)
    (PORT = 1529)
    )
    )
    (CONNECT_DATA =
    (SID = QAS)
    (SERVICE_NAME = qasst)
    )
    )


    -------------------------

    Regards,

    Nirav

  2. #2
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    did you check the listener? is it up and running and on the same port?

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  3. #3
    Join Date
    Apr 2001
    Location
    Vadodara, India
    Posts
    249
    Thanks for your reply.

    Yes, I have checked listner. It is on the same port 1529 and it is up.

  4. #4
    Join Date
    Jul 2006
    Posts
    195
    I would start with a simpler example (see below) and I would change
    the name of your machine to use an IPC address..

    Test using ping ip_address first to make sure that works.

    QAS.WORLD =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = ipc address here <#.#.#.#>)(PORT = 1528))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = qas)
    )
    )

    Good luck

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    Quote Originally Posted by BeefStu View Post
    I would start with a simpler example (see below) and I would change
    the name of your machine to use an IPC address..

    Test using ping ip_address first to make sure that works.

    QAS.WORLD =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = ipc address here <#.#.#.#>)(PORT = 1528))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = qas)
    )
    )

    Good luck


    well all that is useless as it has nothing to do with the actual error, which is cannot resolve name

    the reason is becuase your are doing a tnsping on qasst but your tnsnames has qasst.world

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