TNS-03505: Failed to resolve name

[ianh]

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)
)
)