Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: sqlplus foo/bar@baz works; connect foo/bar@baz doesn't

Re: sqlplus foo/bar@baz works; connect foo/bar@baz doesn't

From: Thomas Schwickert <schwickert_at_yahoo.com>
Date: Thu, 20 Sep 2001 08:50:47 +0000 (UTC)
Message-ID: <c60e67d9fe9042787131ac40198ef737.20305@mygate.mailgate.org>


"Ban Spam" <ban-spam_at_operamail.com> wrote in message news:Xns9121B4596775SunnySD_at_24.0.3.73...
>
> The first example of invoking sqlplus on the command
> line ONLY needs an entry in TNSNAMES.ORA file.

ok  

> After you are "inside" the sqlplus application,
> you need BOTH an entry in TNSNAMES.ORA file, plus
> a database link (DB_LINK) defined inside the instance.
>
> HTH & YMMV!
good joke ...

In 8.0.4 (i think) there was a bug where connect user/pwd_at_alias succeeds
whereas
connect user_at_alias, then enter the password don't work (or was it the other way ...?)

try connect foo_at_baz, then enter password, perhaps it helps.

Perhaps the bug strikes back ..

Hth
Thomas.

-- 
Posted from  [212.20.131.226] 
via Mailgate.ORG Server - http://www.Mailgate.ORG
Received on Thu Sep 20 2001 - 03:50:47 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US