Re: ORA-12154 Errror PLease help

No Oracle version and no platform.

So this is all entirely guesswork.

(PLEASE: If you post, include a soddin' version and platform. End of Rant. Normal service will be resumed shortly. Your call is important to us. Press 1 to continue).

Your tnsnames has an alias for GCRCDEV. Your Listener is aware of an instance called GCRCDEV.med.utah.edu. My suspicion is that you are running on NT or something desperately similar, and you have a sqlnet.ora containing the line 'sqlnet.default_domain=blah.blah.blah' -or something vaguely similar.

Point is, that line is evil. Sheer, bloody evil. Sorry... if you're in Utah, that should have read, "sheer, dreadful badness". It appends the 'default.domain' silently to whatever you type as your connection tns alias.

For example. Sqlnet.ora set to 'blah.world'. Tnsnames has an entry for 'SALES'. You type 'connect scott/tiger_at_sales' and sqlnet.ora will ensure that what actually gets issued is a 'connect scott/tiger_at_sales.blah.world'.

So. One. Find out what the default domain is, assuming it's set at all in sqlnet.ora, and get rid of it. Just delete the line entirely from your sqlnet.ora, and try again.

Two. Make your tnsnames.ora agree with your sqlnet.ora. In your case, if sqlnet.ora is appending 'blah.world' to whatever you type as your connection string, make sure tnsnames.ora has an entry not for GCRCDEV but for GCRCDEV.blah.world. Replace with med.utah.edu as appropriate, but strictly after meals and before bedtime. Three times a day.

Regards
HJR "nth_prime" <jrojas_at_hsc.utah.edu> wrote in message news:72435b0f.0303261513.3499c2bb_at_posting.google.com...
> I am getting this error
> ORA-12154 TNS : Could resolve service name
>
>
> Am I missing somthing?????? SQL.net needs to be configured?
>
> Here is my TNSNAME.ora
>
>
>
> GCRCDEV =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVER = DEDICATED)
> (SERVICE_NAME = GCRCDEV)
> )
> )
>
>
>
> ******************
> Here is my listener.ora
>
>
> LISTENER =
> (DESCRIPTION_LIST =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
> )
> )
> )
>
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (GLOBAL_DBNAME = GCRCDEV.med.utah.edu)
> (ORACLE_HOME = /odata/oracle/production/9.2.0.1.0)
> (SID_NAME = GCRCDEV)
> )
> )
Received on Wed Mar 26 2003 - 17:49:55 CST