1 2 3 4 Previous Next 52 Replies Latest reply: Feb 13, 2013 12:51 AM by 936666 Go to original post RSS
      • 45. Re: TNS-03505: Failed to resolve name
        sb92075
        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
          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
            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
              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
                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
                  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
                    >
                    <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
                      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