Re: Sqlp Plus Connect using <User>_at_<DbName> connects to $ORACLE_SID

I do not think it is a bug, at least not a new one. THe behavior has been around since V6 if not early V7.

The db spec (_at_tnsname) goes after the password, even on the command line.

Example
sqlplus fred
PRompt-Password: password_at_otherdb.world

or sqlplus fred/password_at_otherdb.world

In article <36731267.DF635429_at_pop.iperbole.bologna.it>,   ga11742_at_pop.iperbole.bologna.it wrote:
>
>
> hemant_deshpande ha scritto:
>
> > Hi !!!!
> >
> > We are having problem using Sql*Plus
> >
> > Platform : HP/UX
> > Database :8.0....
> > SqlPlus : ?????
> >
> > If you connect to database as
> > sqlplus <userName>/<PassWord>_at_<DbName>
> > connects to <DbName> ----- This Works
> >
> > But
> >
> > sqlplus <UserName>_at_<DbName> --- Password will be entered at command line
> > This connect to database specified by $ORACLE_SID not to <DbName>
> >
> > I have checked this by selecting name from v$database table;
> >
> > Are we missing any setup?
> >
> > Need Help ......
> >
> > Thanks
> > Hemant
>
> In all probability it is a bug of sql-plus: I know that the sql-plus of rel.
> 8.0 have just a problem
> when reconnecting; perhaps you can try to install sql-plus with rel. 8.0.5
> of DB:
> I think the problem is fixed.
>
> Hi
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Dec 15 1998 - 17:50:37 CET