Re: ORA 12154

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Wed, 09 Oct 2002 19:20:36 +0200
Message-ID: <95p8quop99qlgkegigvqgcn8egen4329mj@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 Wed Oct 09 2002 - 12:20:36 CDT