Re: ORA-12154 Errror PLease help

"Paul Brewer" <paul_at_paul.brewers.org.uk> wrote in message news:3e86342e_1_at_mk-nntp-1.news.uk.worldonline.com...
> "Karsten Farrell" <kfarrell_at_belgariad.com> wrote in message
> news:MPG.18ebdfa538b95f9998970e_at_news.la.sbcglobal.net...
> > One thing that always seems to snag people is having a default domain
> > specified in sqlnet.ora (such as .world). If you have that line, comment
> > it out and see what happens. Doesn't seem to be any glaring errors in
> > your other .ora files ... assuming you are getting the ORA-12154 error
> > while trying to connect on your localhost.
>
> Well, as far as I can see, you and Howard have both given what I have no
> doubt is the right answer - just with a slight difference in emphasis.

Not sure what that would be, but sqlnet.ora is an evil little bast*** for most users for most of the time, that's for sure. It does its stuff silently, and without qualification.

I can't say more... an emergency tooth extraction this morning and immense qyuantitues of drugs (legit!!) later, I wouldn't know what i was saying anyway.

Regards
HJR
>
> FWIW, I have dispensed with sqlnet.ora altogether. I just got fed up and
> deleted the damned thing. I'll put it back only when I need to force
tracing
> or some such. I lay no claim to being an OracleNet/Net8 expert, but it
works
> for me - with a couple of dozen hosts in various domains (once we have
made
> arrangements with the firewall people, of course).
>
> Regards,
> Paul
>
>
>
Received on Sun Mar 30 2003 - 01:42:04 CST