Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Tnsnames.ora - Strange Connectivity problem
"ORA-12154: TNS:could
not resolve service name".
means the name you specified in your connect string is not found in your tnsnames.ora .. i.e. if your tnsnames looks like this:
fred =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = myserver)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = fred)
)
)
#
and you issue 'connect system_at_freddie' you'll get the error because you don't have an entry for freddie. Also, check you sqlnet.ora file for names.default_domain. If you have, say, name.default_domain=world, then in the above example, you 'connect system_at_fred', you will need a tnsnames entry called fred.world.
Might help if you posted your tnsnames.ora, sqlnet.ora, and full text of your connect statement. Received on Wed May 03 2006 - 10:04:07 CDT