This discussion is archived
3 Replies Latest reply: Nov 17, 2009 5:09 AM by EdStevens RSS

TNS-03505: Failed to resolve name

Raman Newbie
Currently Being Moderated
hi,

actually silly...fighting for some hours now...

i am adding the service names in tnsnames.ora but not pinging getting the below error

TNS-03505: Failed to resolve name

i am using ibm aix
verified
case, TCP,servername , port and service name..

i just copied from the existing tag and edited in the same file...

other name already in there is pinging...anything i am missing here

SERVICE1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =<server name in lower case>)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = DBID1)
)
)

SERVICE2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = <server name in lower>)(PORT = 1523))
)
(CONNECT_DATA =
(SERVICE_NAME = DBID2)
)
)
  • 1. Re: TNS-03505: Failed to resolve name
    asifkabirdba Guru
    Currently Being Moderated
    TESTDB =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.234.4.42)(PORT = 1521))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = testdb)
    )
    )

    Maintain the syntax as mentioned above. Edit the above one according to your need and paste it to your tnsnames.ora file and retry.

    Regards
    Asif Kabir
  • 2. Re: TNS-03505: Failed to resolve name
    Azar Pro
    Currently Being Moderated
    Raman wrote:
    hi,

    actually silly...fighting for some hours now...
    SERVICE2 =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = <server name in lower>)(PORT = 1523))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = DBID2)
    )
    )
    orcl =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS =
    (COMMUNITY = tcp.world)
    (PROTOCOL = TCP)
    (Host = 129.1.1.128)
    (Port = 1521)
    )
    )
    (CONNECT_DATA = (SID = orcl)
    )
    )



    Host name may be your computername or your ip address..


    Regards

    Azar
    DBA
  • 3. Re: TNS-03505: Failed to resolve name
    EdStevens Guru
    Currently Being Moderated
    Raman wrote:
    hi,

    actually silly...fighting for some hours now...

    i am adding the service names in tnsnames.ora but not pinging getting the below error

    TNS-03505: Failed to resolve name

    i am using ibm aix
    verified
    case, TCP,servername , port and service name..

    i just copied from the existing tag and edited in the same file...

    other name already in there is pinging...anything i am missing here

    SERVICE1 =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST =<server name in lower case>)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = DBID1)
    )
    )

    SERVICE2 =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = <server name in lower>)(PORT = 1523))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = DBID2)
    )
    )
    TNS-3505 means it couldn't even find the entry in tnsnames.ora. Monkeyinig around with how that name would be resolved (host=, port=, service_name=) is premature.

    SHOW us your full command line and result when you try to tnsping the entry.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points