TNS-03505: Failed to resolve name
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: TNS-03505: Failed to resolve name

  1. #1
    Join Date
    Nov 2002
    Posts
    16

    TNS-03505: Failed to resolve name

    I am receiving the above error when performing a tnsping or sqlplus connect to a Database I have created on Oracle 817 on Windows 2000.

    Despite all efforts to amend the TNSNAMES file and SQLNET.ORA file LISTENER.ORA file I still receive this error. I have created database with a global name of LITTLE, SID = LITTLE.
    Services running on WIndows are:-
    Oracleora8iTNSListener
    OracleServiceLITTLE
    Oracleora8iAgent
    OracleWebAssistant


    LSNRCTL status shows the following:
    STATUS of the LISTENER
    ------------------------
    Alias LISTENER
    Version TNSLSNR for 32-bit Windows: Version 8.1.7.0.0 - Pr
    tion
    Start Date 20-DEC-2002 09:27:42
    Uptime 0 days 2 hr. 52 min. 40 sec
    Trace Level off
    Security OFF
    SNMP OFF
    Listener Parameter File c:\ora8i\network\admin\listener.ora
    Listener Log File c:\ora8i\network\log\listener.log
    Services Summary...
    LITTLE has 1 service handler(s)
    LITTLE has 1 service handler(s)
    PLSExtProc has 1 service handler(s)
    dsd01 has 1 service handler(s)
    dsdora81 has 1 service handler(s)

    Here are my configuration Files

    TNSNAMES.ORA
    ***************

    # TNSNAMES.ORA Network Configuration File: C:\oracle\ora81\network\admin\tnsnames.ora
    # Generated by Oracle configuration tools.

    ORA817 =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = dsd)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = ora817)
    )
    )

    LITTLE =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = dsd)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = LITTLE)
    )
    )

    EXTPROC_CONNECTION_DATA =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
    (SID = PLSExtProc)
    (PRESENTATION = RO)
    )


    SQLNET.ORA
    ******************
    # SQLNET.ORA Network Configuration File: c:\ora8i\network\admin\sqlnet.ora
    # Generated by Oracle configuration tools.

    #DISABLE_OOB = ON

    NAME.DEFAULT_ZONE = world

    NAMES.DEFAULT_DOMAIN = world

    SQLNET.AUTHENTICATION_SERVICES= (NONE)

    #AUTOMATIC_IPC = OFF
    #TRACE_LEVEL_CLIENT = OFF
    #names.directory_path = (TNSNAMES)

    NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES)

    LISTENER.ORA
    ***********

    # LISTENER.ORA Network Configuration File: c:\ora8i\network\admin\listener.ora
    # Generated by Oracle configuration tools.
    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = dsd)(PORT = 1521))
    )
    )
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = c:\ora8i)
    (PROGRAM = extproc)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = dsdora81)
    (ORACLE_HOME = c:\ora8i)
    (SID_NAME = dsdora81)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = dsd01)
    (ORACLE_HOME = c:\ora8i)
    (SID_NAME = dsd01)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = LITTLE)
    (ORACLE_HOME = c:\ora8i)
    (SID_NAME = LITTLE)
    )
    )

  2. #2
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    684
    Delete SQLNET.ORA or commect all lines.
    Best wishes!
    Dmitri

  3. #3
    Join Date
    Dec 2002
    Location
    Munich, Germany
    Posts
    20

    Re: TNS-03505: Failed to resolve name

    Originally posted by bal
    TNSNAMES.ORA
    ***************
    ...
    ORA817 =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = dsd)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = ora817)
    )
    )

    ...
    try use here SID keyword instead of SERVICE_NAME. If it works, then there is an issue of backward compatibility flag on one of conf. assistant tab (sorry, I don't remember more exactly where it is). It comes with default installation.

  4. #4
    Join Date
    Nov 2002
    Posts
    16

    Commenting SQLNET.ORA

    Commenting SQLNET.ORA did not work. Still receive the same error.TNS-03505: Failed to resolve name

  5. #5
    Join Date
    Nov 2002
    Location
    Dublin, Ireland
    Posts
    132
    Are you sure your host is dsd? if so try like below :

    LITTLE=
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = dsd)(PORT = 1521))
    )
    (CONNECT_DATA = (SID = LITTLE)(SERVER = DEDICATED))
    )

    Also try commenting out the following line in sqlnet.ora :
    # NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES)
    Giani

  6. #6
    Join Date
    Nov 2002
    Posts
    16

    Tried all above still not worked

    Tried all above still not worked

  7. #7
    Join Date
    Sep 2001
    Posts
    120
    in sqlnet.ora
    NAMES.DIRECTORY_PATH= (TNSNAMES, HOSTNAME, ONAMES)

    also in your listener.ora
    LISTENER.ORA
    ***********

    # LISTENER.ORA Network Configuration File: c:\ora8i\network\admin\listener.ora
    # Generated by Oracle configuration tools.
    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = dsd)(PORT = 1521))
    )
    )
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = c:\ora8i)
    (PROGRAM = extproc)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = dsdora81)
    (ORACLE_HOME = c:\ora8i)
    (SID_NAME = dsdora81)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = dsd01)
    (ORACLE_HOME = c:\ora8i)
    (SID_NAME = dsd01)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = LITTLE)
    (ORACLE_HOME = c:\ora8i)
    (SID_NAME = LITTLE)
    )
    )


    do
    GLOBAL_DBNAME as LITTLE.world everywhere
    Saurabh Garg
    OCP 9i

  8. #8
    Join Date
    Nov 2002
    Posts
    16

    Tried all above, still same error message.

    Tried all above, still same error message. what could be wrong.

  9. #9
    Join Date
    Dec 2002
    Location
    USA
    Posts
    53
    Did you install multiple oracle clients in your box?

  10. #10
    Join Date
    Dec 2002
    Posts
    2
    Make sure your init*.ora file located in directory
    %ORACLE_HOME%\admin\LITTLE\pfile\init*.ora
    has the following values:




    db_name = "LITTLE"

    db_domain = WORLD <--- this had better match the value
    <---- NAMES.DEFAULT_DOMAIN in SQLNET.ORA

    instance_name = LITTLE

    service_names = LITTLE.WORLD <-- This should be db_name + db_domain
    <-- and this name MUST match the value
    <-- in your TNSNAMES.ORA file item
    <-- CONNECT_DATA->SERVICE_NAME. see
    <-- below

    LITTLE =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = YOURSERVERGOESHERE)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = LITTLE.WORLD)
    )
    )

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width