Re: Password/account problem with OPS$

In article <19930607.091526.482_at_almaden.ibm.com>, bondono_at_vnet.IBM.COM writes:
|> I have found some problems to connect users with OPS$ accounts (Oracle
|> V7.11 on S/6000 w/ AIX). If I type:
|>
|> $ sqlplus ops$ifplus/toto0
|>
|> SQL*Plus: Release 3.1.1.6.1 - Developer's Release on Mon Jun 7 18:11:13 1993
|>
|> Copyright (c) Oracle Corporation 1979, 1992. All rights reserved.
|>
|> ERROR: ORA-01017: invalid username/password; logon denied
|>
|> However if I do:
|>
|> $ sqlplus
|>
|> SQL*Plus: Release 3.1.1.6.1 - Developer's Release on Mon Jun 7 18:11:50 1993
|>
|> Copyright (c) Oracle Corporation 1979, 1992. All rights reserved.
|>
|> Enter user-name: ops$ifplus/toto0
|>
|> Connected to:
|> ORACLE7 Server Release 7.0.11.2.2 - Developer's Release
|> With the procedural and distributed options
|> PL/SQL V2.0.13.1.1 - Developer's Release
|>
|> Anybody has already seen this behavior?
|>
|> Philippe
|>

Philippe,

the only thing you have to do, is to mask your $ sign, to prevent it from the shell:

                sqlplus ops\$ifplus/toto0
so it should work!!

but it will also work when you just type

                sqlplus /
oracle will use the operating-system login as the oracle account. in this case you don't need a password, couse your unix password will be taken.

if you've got additional questions, feel free to email me!

hope this helps,

                        Peter

--
Peter Kesch             Kapp & Co                  email:kesch_at_kapp-coburg.de
phone:+49 9561 866376   Callenberger Strasse 52-58
fax:  +49 9561 866103   96450 Coburg, Germany