1 2 3 4 Previous Next 52 Replies Latest reply: Feb 13, 2013 12:51 AM by 936666 RSS

    TNS-03505: Failed to resolve name

    936666
      sqlnet.ora
      SQLNET.AUTHENTICATION_SERVICES= (NTS)
      
      NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
      tnsnames.ora
        TESTDB =
        (DESCRIPTION =
          (ADDRESS = (PROTOCOL = TCP)(HOST = *******************)(PORT = 1521))
          (CONNECT_DATA =
            (SERVER = DEDICATED)
            (SERVICE_NAME = TESTDB)
          )
        )
      Listener.ora
      SID_LIST_LISTENER =
        (SID_LIST =
          (SID_DESC =
            (SID_NAME = orcl)
            (ORACLE_HOME = E:\app\usernameproduct\11.2.0\dbhome_1)
               )
      )
      
      
      LISTENER =
        (DESCRIPTION_LIST =
          (DESCRIPTION =
            (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))
            (ADDRESS = (PROTOCOL = TCP)(HOST = ********************)(PORT = 1521))
          )
        )
      Tnsping Testdb
      TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 07-FEB-2013 20:58:25
      
      Copyright (c) 1997, 2010, Oracle.  All rights reserved.
      
      Used parameter files:
      
      C:\oracle\sqlnet.ora
      
      TNS-03505: Failed to resolve name
      how to resolve
      TNS-03505: Failed to resolve name

      checked this site
      http://edstevensdba.wordpress.com/2011/02/26/ora-12154tns-03505/

      I checked all the options but couldn't find what is missing
      where as for
      Tnsping orcl i am able to ping
        • 1. Re: TNS-03505: Failed to resolve name
          sb92075
          933663 wrote:
          sqlnet.ora
          SQLNET.AUTHENTICATION_SERVICES= (NTS)
          
          NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
          tnsnames.ora
          TESTDB =
          (DESCRIPTION =
          (ADDRESS = (PROTOCOL = TCP)(HOST = *******************)(PORT = 1521))
          (CONNECT_DATA =
          (SERVER = DEDICATED)
          (SERVICE_NAME = TESTDB)
          )
          )
          Listener.ora
          SID_LIST_LISTENER =
          (SID_LIST =
          (SID_DESC =
          (SID_NAME = orcl)
          (ORACLE_HOME = E:\app\usernameproduct\11.2.0\dbhome_1)
          )
          )
          
          
          LISTENER =
          (DESCRIPTION_LIST =
          (DESCRIPTION =
          (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))
          (ADDRESS = (PROTOCOL = TCP)(HOST = ********************)(PORT = 1521))
          )
          )
          Tnsping Testdb
          TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 07-FEB-2013 20:58:25
          
          Copyright (c) 1997, 2010, Oracle.  All rights reserved.
          
          Used parameter files:
          
          C:\oracle\sqlnet.ora
          
          TNS-03505: Failed to resolve name
          how to resolve
          TNS-03505: Failed to resolve name

          checked this site
          http://edstevensdba.wordpress.com/2011/02/26/ora-12154tns-03505/

          I checked all the options but couldn't find what is missing
          where as for
          Tnsping orcl i am able to ping
          ORA-12154 ALWAYS only occurs on SQL Client & no SQL*Net packets ever leave client system
          ORA-12154 NEVER involves the listener, the database itself or anything on the DB Server.
          ORA-12154 occurs when client requests a connection to some DB server system using some connection string.
          TNS-03505 is thrown by tnsping & is same error as ORA-12154 thrown by sqlplus or others.
          The lookup operation fails because the name provided can NOT be resolved to any remote DB.
          The analogous operation would be when you wanted to call somebody, but could not find their name in any phonebook.
          The most frequent cause for the ORA-12154 error is when the connection alias can not be found in tnsnames.ora.
          The lookup operation of the alias can be impacted by the contents of the sqlnet.ora file; specifically DOMAIN entry.
          TROUBLESHOOTING GUIDE: ORA-12154 & TNS-12154 TNS:could not resolve service name [ID 114085.1]
          http://edstevensdba.wordpress.com/2011/02/26/ora-12154tns-03505/
          • 2. Re: TNS-03505: Failed to resolve name
            936666
            Thanks for the link but i have already checked but it does not resolves the problem.thats why i posted here.
            • 3. Re: TNS-03505: Failed to resolve name
              EdStevens
              sb92075 wrote:
              933663 wrote:
              sqlnet.ora
              SQLNET.AUTHENTICATION_SERVICES= (NTS)
              
              NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
              tnsnames.ora
              TESTDB =
              (DESCRIPTION =
              (ADDRESS = (PROTOCOL = TCP)(HOST = *******************)(PORT = 1521))
              (CONNECT_DATA =
              (SERVER = DEDICATED)
              (SERVICE_NAME = TESTDB)
              )
              )
              Listener.ora
              SID_LIST_LISTENER =
              (SID_LIST =
              (SID_DESC =
              (SID_NAME = orcl)
              (ORACLE_HOME = E:\app\usernameproduct\11.2.0\dbhome_1)
              )
              )
              
              
              LISTENER =
              (DESCRIPTION_LIST =
              (DESCRIPTION =
              (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))
              (ADDRESS = (PROTOCOL = TCP)(HOST = ********************)(PORT = 1521))
              )
              )
              Tnsping Testdb
              TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 07-FEB-2013 20:58:25
              
              Copyright (c) 1997, 2010, Oracle.  All rights reserved.
              
              Used parameter files:
              
              C:\oracle\sqlnet.ora
              
              TNS-03505: Failed to resolve name
              how to resolve
              TNS-03505: Failed to resolve name

              checked this site
              http://edstevensdba.wordpress.com/2011/02/26/ora-12154tns-03505/

              I checked all the options but couldn't find what is missing
              where as for
              Tnsping orcl i am able to ping
              Then you have not shown us all of the relevant information. There was no entry for 'orcl' in the tnsnames.ora you showed us.

              Show us the entire contents of C:\oracle\sqlnet.ora
              Show us the entire contents of C:\oracle\tnsnames.ora

              Why am I asking for those files? Because your output of tnsping indicates it found sqlnet.ora at C:\oracle. Which, btw, is a very unusual place to find it. It looks like you over-rode some defaults (like SOFTWARE INSTALLATION DIRECTORY) when you installed oracle on this box. Which leaves the possibility of a lot of other things not being default, so we have to throw out almost all assumptions.



              >
              >
              ORA-12154 ALWAYS only occurs on SQL Client & no SQL*Net packets ever leave client system
              ORA-12154 NEVER involves the listener, the database itself or anything on the DB Server.
              ORA-12154 occurs when client requests a connection to some DB server system using some connection string.
              TNS-03505 is thrown by tnsping & is same error as ORA-12154 thrown by sqlplus or others.
              The lookup operation fails because the name provided can NOT be resolved to any remote DB.
              The analogous operation would be when you wanted to call somebody, but could not find their name in any phonebook.
              The most frequent cause for the ORA-12154 error is when the connection alias can not be found in tnsnames.ora.
              The lookup operation of the alias can be impacted by the contents of the sqlnet.ora file; specifically DOMAIN entry.
              TROUBLESHOOTING GUIDE: ORA-12154 & TNS-12154 TNS:could not resolve service name [ID 114085.1]
              http://edstevensdba.wordpress.com/2011/02/26/ora-12154tns-03505/
              • 4. Re: TNS-03505: Failed to resolve name
                sb92075
                933663 wrote:
                Thanks for the link but i have already checked but it does not resolves the problem.thats why i posted here.
                The lookup operation of the alias can be impacted by the contents of the sqlnet.ora file; specifically DOMAIN entry.
                • 5. Re: TNS-03505: Failed to resolve name
                  Osama_Mustafa
                  Check
                  Environment Variable 'Network' Causes TNS-12154 and TNS-3505 [ID 276476.1]
                  • 6. Re: TNS-03505: Failed to resolve name
                    936666
                    >
                    Show us the entire contents of C:\oracle\sqlnet.ora
                    Show us the entire contents of C:\oracle\tnsnames.ora
                    Why am I asking for those files? Because your output of tnsping indicates it found sqlnet.ora at C:\oracle. Which, btw, is a very unusual place to find it. It looks like you over-rode some defaults (like SOFTWARE INSTALLATION DIRECTORY) when you installed oracle on this box. Which leaves the possibility of a lot of other things not being default, so we have to throw out almost all assumptions.
                    I have placed the sqlnet.ora,tnsnames.ora,listener.ora in Oracle folder and modified the Environment variable TNS_NAME to configure this path.

                    tnsnsames.ora
                    TESTDB =
                      (DESCRIPTION =
                        (ADDRESS = (PROTOCOL = TCP)(HOST = *******************)(PORT = 1521))
                        (CONNECT_DATA =
                          (SERVER = DEDICATED)
                          (SERVICE_NAME = TESTDB)
                        )
                      )
                    ORCL =
                      (DESCRIPTION =
                        (ADDRESS = (PROTOCOL = TCP)(HOST = *******************)(PORT = 1521))
                        (CONNECT_DATA =
                          (SERVER = DEDICATED)
                          (SERVICE_NAME = ORCL)
                        )
                      )
                    GIODB =
                      (DESCRIPTION =
                        (ADDRESS = (PROTOCOL = TCP)(HOST = *******************)(PORT = 1521))
                        (CONNECT_DATA =
                          (SERVER = DEDICATED)
                          (SERVICE_NAME = GIODB)
                        )
                      )
                    Tnsnsames.ora
                    SQLNET.AUTHENTICATION_SERVICES= (NTS)
                    NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
                    SQLNET.ENCRYPTION_TYPES_SERVER=(3DES168)
                    SQLNET.ENCRYPTION_SERVER=REQUIRED 
                    • 7. Re: TNS-03505: Failed to resolve name
                      936666
                      Hi,
                      I am able to login when i pass the parameter in this way

                      C:>Set Oracle_sid=Testdb
                      C:>sqlplus /nolog
                      SQL> CONN scott/tiger
                      Connected.
                      SQL> Select * from Dual;
                      D
                      -
                      X

                      Where as if pass the parameter in this way i am unable to login

                      C:>Set Oracle_sid=Testdb
                      C:>sqlplus /nolog
                      SQL> CONN scott/tiger@TESTDB
                      ERROR:
                      ORA-12154: TNS:could not resolve the connect identifier specified

                      So where lies the problem.
                      • 8. Re: TNS-03505: Failed to resolve name
                        sb92075
                        933663 wrote:
                        Hi,
                        I am able to login when i pass the parameter in this way

                        C:>Set Oracle_sid=Testdb
                        C:>sqlplus /nolog
                        SQL> CONN scott/tiger
                        Connected.
                        SQL> Select * from Dual;
                        D
                        -
                        X
                        above does NOT use SQL*Net
                        while below does try to use SQ*Net
                        Where as if pass the parameter in this way i am unable to login

                        C:>Set Oracle_sid=Testdb
                        C:>sqlplus /nolog
                        SQL> CONN scott/tiger@TESTDB
                        ERROR:
                        ORA-12154: TNS:could not resolve the connect identifier specified

                        So where lies the problem.
                        ORA-12154 ALWAYS only occurs on SQL Client & no SQL*Net packets ever leave client system
                        ORA-12154 NEVER involves the listener, the database itself or anything on the DB Server.
                        ORA-12154 occurs when client requests a connection to some DB server system using some connection string.
                        TNS-03505 is thrown by tnsping & is same error as ORA-12154 thrown by sqlplus or others.
                        The lookup operation fails because the name provided can NOT be resolved to any remote DB.
                        The analogous operation would be when you wanted to call somebody, but could not find their name in any phonebook.
                        The most frequent cause for the ORA-12154 error is when the connection alias can not be found in tnsnames.ora.
                        The lookup operation of the alias can be impacted by the contents of the sqlnet.ora file; specifically DOMAIN entry.
                        So post the content of the sqlnet.ora file.
                        TROUBLESHOOTING GUIDE: ORA-12154 & TNS-12154 TNS:could not resolve service name [ID 114085.1]
                        http://edstevensdba.wordpress.com/2011/02/26/ora-12154tns-03505/
                        • 9. Re: TNS-03505: Failed to resolve name
                          936666
                          sb92075 wrote:
                          ORA-12154 ALWAYS only occurs on SQL Client & no SQL*Net packets ever leave client system
                          ORA-12154 NEVER involves the listener, the database itself or anything on the DB Server.
                          ORA-12154 occurs when client requests a connection to some DB server system using some connection string.
                          TNS-03505 is thrown by tnsping & is same error as ORA-12154 thrown by sqlplus or others.
                          The lookup operation fails because the name provided can NOT be resolved to any remote DB.
                          The analogous operation would be when you wanted to call somebody, but could not find their name in any phonebook.
                          The most frequent cause for the ORA-12154 error is when the connection alias can not be found in tnsnames.ora.
                          The lookup operation of the alias can be impacted by the contents of the sqlnet.ora file; specifically DOMAIN entry.
                          So post the content of the sqlnet.ora file.
                          TROUBLESHOOTING GUIDE: ORA-12154 & TNS-12154 TNS:could not resolve service name [ID 114085.1]
                          http://edstevensdba.wordpress.com/2011/02/26/ora-12154tns-03505/
                          The most frequent cause for the ORA-12154  error is when the connection alias can not be found in tnsnames.ora.
                          in my tnsnames.ora there is an entry for the database and that too the database is also local host, i have replaced host by star(*) for business reasons.
                          • 10. Re: TNS-03505: Failed to resolve name
                            936666
                            Any suggestion for the above.!
                            • 11. Re: TNS-03505: Failed to resolve name
                              OraDB
                              can you try this...UR = a part in your tns entry....and reload the listener...
                              TESTDB =
                                (DESCRIPTION =
                                  (ADDRESS = (PROTOCOL = TCP)(HOST = *******************)(PORT = 1521))
                                  (CONNECT_DATA =
                                    (UR = A)
                                    (SERVER = DEDICATED)
                                    (SERVICE_NAME = TESTDB)
                                  )
                                )
                              • 12. Re: TNS-03505: Failed to resolve name
                                936666
                                No there is no change, same result.
                                • 13. Re: TNS-03505: Failed to resolve name
                                  JohnWatson
                                  933663 wrote:
                                  I have placed the sqlnet.ora,tnsnames.ora,listener.ora in Oracle folder and modified the Environment variable TNS_NAME to configure this path.
                                  Wrong variable name, it should be TNS_ADMIN.
                                  --
                                  John Watson
                                  http://skillbuilders.com
                                  • 14. Re: TNS-03505: Failed to resolve name
                                    936666
                                    hi,

                                    tnsping  task.<myhostname>
                                    C:\>tnsping  task.mysystemname.www.com
                                    
                                    TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 08-FEB-2013 15:36:46
                                    
                                    Copyright (c) 1997, 2010, Oracle.  All rights reserved.
                                    
                                    Used parameter files:
                                    C:\Oracle\sqlnet.ora
                                    
                                    TNS-03505: Failed to resolve name
                                    Tnsping task.hostname fails so what might be the reason. :( :(
                                    1 2 3 4 Previous Next