Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Sqlp Plus Connect using <User>@<DbName> connects to $ORACLE_SID

1 view
Skip to first unread message

hemant_deshpande

unread,
Dec 10, 1998, 3:00:00 AM12/10/98
to
Hi !!!!

We are having problem using Sql*Plus

Platform : HP/UX
Database :8.0....
SqlPlus : ?????

If you connect to database as
sqlplus <userName>/<PassWord>@<DbName>
connects to <DbName> ----- This Works

But

sqlplus <UserName>@<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

ga1...@pop.iperbole.bologna.it

unread,
Dec 13, 1998, 3:00:00 AM12/13/98
to

hemant_deshpande ha scritto:


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


mp...@compuserve.com

unread,
Dec 15, 1998, 3:00:00 AM12/15/98
to
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 (@tnsname) goes after the password, even on the command line.

Example
sqlplus fred
PRompt-Password: pass...@otherdb.world

or sqlplus fred/pass...@otherdb.world

In article <36731267...@pop.iperbole.bologna.it>,

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

0 new messages