This discussion is archived
1 2 3 4 Previous Next 52 Replies Latest reply: Feb 12, 2013 10:51 PM by 936666 RSS

TNS-03505: Failed to resolve name

936666 Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    Check
    Environment Variable 'Network' Causes TNS-12154 and TNS-3505 [ID 276476.1]
  • 6. Re: TNS-03505: Failed to resolve name
    936666 Newbie
    Currently Being Moderated
    >
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    Any suggestion for the above.!
  • 11. Re: TNS-03505: Failed to resolve name
    OraDB Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    No there is no change, same result.
  • 13. Re: TNS-03505: Failed to resolve name
    JohnWatson Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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

Legend

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