Re: ORA-12154 ?!!?!?

On Tue, 24 Oct 2006 13:27:45 +0200, Alexander Skwar wrote:

>
> C:\Documents and Settings\so_ask>type %TNS_ADMIN%\tnsnames.ora
> ORABDE.EUROPE.DELPHIAUTO.NET =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = 10.233.30.8)(PORT = 1521))
> )
>
> (CONNECT_DATA =
> (SERVICE_NAME = orabde.delphi)
> )
> )
>

Could not resolve service name means exactly that ... whatever you put after the @ in the connect string could not be translated to ORADBE.EUROPE.DELPHIAUTO.NET There are several basic possibilities, the most common being

1. the client could not find the tnsnames.ora
   • you appear to have that resolved
2. you did not enter the above string exactly as written
   • hidden characters in a connect string can do funny things
3. you have a sqlnet.ora that contains default_domain setting and you enter a service alias oradbq

-- 
Hans Forbrich   (mailto: Fuzzy.GreyBeard_at_gmail.com)   
*** Feel free to correct me when I'm wrong!
*** Top posting [replies] guarantees I won't respond.