Re: ORA 12154

Thanks for you answer

some more details
i use odbc to connect to oracle
when i test the odbc connection the odbc driver tells me the ORA 12154. when i use this odbc settings in ms access, i can link to the database! i can open the enterprice manager and work with the database, but when i open sqlplus i cannot connect?!

i used the same settings on windows nt and it works, on windows 2k sp3 it does not.

regards
gerald

"Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> schrieb im Newsbeitrag news:95p8quop99qlgkegigvqgcn8egen4329mj_at_4ax.com...
> On Wed, 9 Oct 2002 16:12:55 +0200, "Gerald Saurugg" <g.saurugg_at_pvm.at>
> wrote:
>
> >Hello
> >
> >I tried to install Oracle 9i Releace 2 Client tools on a Win2k SP3
machine.
> >With Net Manager i am able to connect to the server, with SQLPLUS i
cannot
> >to this, i get ORA 12154.
> >Has anyone an idea whats going one?
> >thanks
> >Gerald
> >
>
> Sure
> - You get an error
> - You don't look it up in the Server Messages Manual
> - You don't look in the net 8 administrators manual
> - You post it immediately to this group
> - you get the response this is a FAQ
> - it means you are using a service name which is not in tnsnames.ora,
> and most likely you have multiple tnsnames.ora floating around
> - get them in sync and set the TNS_ADMIN string var
>
> Of course you wouldn't have posted this question if you would have
> searched the archives before posting. But why avoid wasting people's
> spare free time, eh?
>
> Regards
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Thu Oct 10 2002 - 04:24:33 CDT