This discussion is archived
1 2 3 4 Previous Next 52 Replies Latest reply: Feb 12, 2013 10:51 PM by 936666 Go to original post RSS
  • 45. Re: TNS-03505: Failed to resolve name
    sb92075 Guru
    Currently Being Moderated
    933663 wrote:
    I could not find any difference after making
    set oracle_sid=TestDB or
    set ORACLE_SID=TESTDB
    still same issue. :(
    the value of ORACLE_SID is 100% irrelevant when SQL*Net ( @TNS_ALIAS) is used.

    you can lead some folks to knowledge, but you can't make them think.
  • 46. Re: TNS-03505: Failed to resolve name
    936666 Newbie
    Currently Being Moderated
    The Problem is with the space in-front of the SID name

    The old one
         TESTDB =
                (DESCRIPTION =
                 (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
                  (CONNECT_DATA =
                    (SERVER = DEDICATED)
                   (SERVICE_NAME = TESTDB)
                   )
             )
    The new one which is correct by removing the space in the front
    TESTDB =
      (DESCRIPTION =
        (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
        (CONNECT_DATA =
          (SERVER = DEDICATED)
          (SERVICE_NAME = TESTDB)
        )
    )
    Thanks a lot!
  • 47. Re: TNS-03505: Failed to resolve name
    sb92075 Guru
    Currently Being Moderated
    933663 wrote:
    The Problem is with the space in-front of the SID name
    since SID name does NOT exist below, to what exactly do you refer?


    >
    The old one
    TESTDB =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = TESTDB)
    )
    )
    The new one which is correct by removing the space in the front
    TESTDB =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = TESTDB)
    )
    )
    Thanks a lot!
  • 48. Re: TNS-03505: Failed to resolve name
    936666 Newbie
    Currently Being Moderated
    Referring SID as TESTDB

    TESTDB =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = TESTDB)
    )
    )
  • 49. Re: TNS-03505: Failed to resolve name
    sb92075 Guru
    Currently Being Moderated
    933663 wrote:
    Referring SID as TESTDB
    words matters.
    in this case "TESTTDB" is a TNS_ALIAS; which can be entirely different to ORACLE_SID it accesses.
    BTW, spaces in tnsnames.ora are not material & don't matter.
    >
    TESTDB =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = TESTDB)
    )
    )
    below is valid tnsnames.ora entry

    COMDB01=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST = comdb01.example.com)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=comdb01.example.com)))
  • 50. Re: TNS-03505: Failed to resolve name
    936666 Newbie
    Currently Being Moderated
    sb92075 wrote:
    BTW, spaces in tnsnames.ora are not material & don't matter.
    No please try it yourself and see, since after removing the empty space before the Oracle_SID it has worked for me.

    TESTDB =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = TESTDB)
    )
    )

    Thanks!
  • 51. Re: TNS-03505: Failed to resolve name
    yoonas Expert
    Currently Being Moderated
    >
    <font color="red">TESTDB</font> =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = <font color="green">TESTDB</font>)
    )
    )
    >


    When you say oracle_sid which one do you mean green or red from above

    Space infront of TNS alias does matter(red color) it seems

    Version
    >
    BANNER
    ----------------------------------------------------------------------
    Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production
    PL/SQL Release 11.2.0.2.0 - Production
    CORE 11.2.0.2.0 Production
    TNS for 32-bit Windows: Version 11.2.0.2.0 - Production
    NLSRTL Version 11.2.0.2.0 - Production
    >

    Tns entry with space infront of alias
    >
    " XE =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = oracle-rndvm)(PORT = 1522))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = XE)
    )
    )">

    tnsping resulted in TNS-03505: Failed to resolve name

    Tns entry without space infront of alias
    >
    "XE =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = oracle-rndvm)(PORT = 1522))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = XE)
    )
    )"
    >

    Edited by: yoonus on Feb 12, 2013 10:12 PM

    Edited by: yoonus on Feb 12, 2013 10:13 PM
  • 52. Re: TNS-03505: Failed to resolve name
    936666 Newbie
    Currently Being Moderated
    Yes exactly the same thing for me
    " XE =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = oracle-rndvm)(PORT = 1522))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = XE)
    )
    )"
    does not work for me and was resulting TNS-03505: Failed to resolve name
    "XE =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = oracle-rndvm)(PORT = 1522))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = XE)
    )
    )"
    Solves the problem after removing the space like you.
    Thanks!
1 2 3 4 Previous Next

Legend

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