Re: Problem with command prompt SqlPlus/Imp

From: gazzag <gareth_at_jamms.org>
Date: 25 Aug 2006 08:49:02 -0700
Message-ID: <1156520942.500590.256790@m73g2000cwd.googlegroups.com>

Jean-Martin Lemieux wrote:
>
> I know that the archive are flooding with stupid ORA-12154 questions
> and that might be why I couldn't find anything usefull about my
> problem. Like I said my TNS DOES work, I can connect locally or from
> another computer using it. The only time it doesn't work is when I try
> to connect using the command prompt.
>
> Look I'm sorry if it's a stupid question, maybe I don't know how to
> search well enough but I did search before posting and all I could find
> are people with typo in their Tnsnames.ora or with the wrong services
> names, etc etc. Nothing about a tns that works everywhere excepts in
> the command prompt.
>
> Thank you,

I'd suggest that you've got multimple Oracle homes on that box and something's out of whack. If you tnsping that database, you should see what Oracle home your sqlnet.ora file is using.

HTH -g Received on Fri Aug 25 2006 - 10:49:02 CDT