Re: Password/account problem with OPS$

In article 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

The problem here is that if AIX is like other unix's I have come across then it is interpreting the '$ifplus' in the command line as a variable substitution. Since in all probability ifplus is not set then the following is being passed to Oracle:

      sqlplus ops/toto0

which of course isn't your logon id. Try escaping the $ sign i.e.

      sqlplus ops\$ifplus/toto0

---
Regards,
David TvE

+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
David Thornewill von Essen                           Sr. Systems Analyst
Motorola ASIC Division                            I don't speak for Mot.
Chandler, AZ-85224                                   fax: (602) 814-4451
email: ttg242_at_email.sps.mot.com                      tel: (602) 814-4395
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-