Re: sqlplus behaviour clarification : "could not resolve service name"

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Thu, 10 Apr 2003 22:22:12 +0200
Message-ID: <hfkb9v4psn8enmr51nbhgpm1pcfl4h5659@4ax.com>

On Thu, 10 Apr 2003 12:03:54 -0700, samir <samirks_at_operamail.com> wrote:

>Hi,
>
>Even after throwing back following error :
>
>ORA-12154: TNS:could not resolve service name
>
>sqlplus prompts for username/password.
>
>Please let me know why it does so and is there a way to disable it.
>Basically, we don't want to prompt the user for username/password when
>sqlplus client fails to connect to database (we are invoking sqlplus
>from a shell script and providing a .sql file on the command line ).
>
>Thanks and regards,
>samir

There is no way to disable it and you'd better resolve the real problem : an incorrect tnsnames.ora.
Information about how to resolve it is flooding in the google archives, the question is asked over and over again by people who don't read manuals and don't search google before posting, and in the troubleshooting chapter of the net8 documentation.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Apr 10 2003 - 15:22:12 CDT