Re: interesting problem with tnsnames.ora

I'm compiling a list of Oracle Idiosyncrasies. One is about tnsnames.ora. E.g., if you write:

 myconnection.world =

instead of

myconnection.world =

i.e., if you have a space in front of the connections string, it gives the Cannot resolve service name error.

Next time you have a strange problem, give us more details. Show us the file you're editing.

Yong Huang
yhuang_at_indigopool.com

<maoshi_at_yahoo.com> wrote in message news:8tt7cj$9jb$1_at_nnrp1.deja.com...
> I have Oracle 8.0.5 server installed on a NT workstation. I also
> edited tnsnames.ora file for connecting to other Oracle 8.0 databases
> either on Unix or NT. It had worked for months until today.
> Today I added one more connection in tnsnames.ora file. However,
> SQL plus kept saying that tns could not resolve the service name.
>
> Then, I changed other connection strings in the file and found that
> the old string still worked while new strings couldn't be resolved.
>
> At last, I rmoved the tnsnames.ora file and found the old connection
> strings still worked for sql plus and other clients !!
>
> I searched all directories to make sure there was only one tnsnames.ora
> file. I picked also one connection string and did a search in all
> files but didn't find
> any other file that contained the string.
>
> Anybody has had similar experience? I don't have a name service.
>
> Maoshi
> e-Engineering
> GE R&D
> guma_at_crd.ge.com
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Nov 03 2000 - 17:30:20 CST