Re: Error ORA-1254 Oracle 10g on linux

From: Ronald Rood <devnull_at_ronr.nl>
Date: Thu, 24 Mar 2005 19:46:38 +0100
Message-ID: <0001HW.BE68C99E00C0C0C6F03055B0@news.individual.net>

On Thu, 24 Mar 2005 19:14:19 +0100, ccote_msl_at_yahoo.com wrote (in article <1111688059.282372.166940_at_l41g2000cwc.googlegroups.com>):

> HI, logged on as Oracle, when I issue sqlplus scott/tiger_at_mydb, I get
> the above error. At second try (in the same sesion, Oracle asks again
> for user name), it works. Is there something that is misconfigured?
>
> Thank you,
> Ccote
>

There is nothing misconfigured. It's just that you specified an incorrect tns alias (mydb). At the second try the database asked for a username and password, which you supplied without @mydb. In your enviroment you have the default database defined (ORACLE_SID or TWO_TASK) and de default database works for you.

With kind regards / met vriendelijke groeten, Ronald

http://ronr.nl/unix-dba
http://homepage.mac.com/ik_zelf/oracle Received on Thu Mar 24 2005 - 12:46:38 CST