Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Tnsnames.ora - Strange Connectivity problem

Re: Tnsnames.ora - Strange Connectivity problem

From: EdStevens <quetico_man_at_yahoo.com>
Date: 3 May 2006 08:04:07 -0700
Message-ID: <1146668647.734167.172220@g10g2000cwb.googlegroups.com>


"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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US