Re: Password/account problem with OPS$

In a previous article, bondono_at_vnet.IBM.COM () says:

>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 *ONLY* thing I can think of is that your *nix command line processor is trying to evaluate a "variable" called "ifplus", since the dollar sign is on the command line. Unix may be trying to send "ops/toto0" ($ifplus evaluates to null) which is obviously an invalid account.

Give it a shot and let me know! :)

-Brian

>
>Philippe Bondono Internet: bondono_at_vnet.ibm.com
>Dept 1403.30 Tel. (+33) 67 34 45 64
>CESA IBM de Montpellier Fax. (+33) 67 34 67 81
>BP 1021, 91106 Montpellier Cedex Bitnet: BONDONO at VNET
>France
>
 

-- 
Brian C. Shensky     313-649-3909 voice/fax/data  shensky_at_umcc.umich.edu
1954 Axtell #4       OS/2 2.1, Oracle RDBMS       ak730_at_yfn.ysu.edu (BEST)
Troy, MI 48084-4421  Occasional ARS N8FSR         bq383_at_cleveland.freenet.edu
** DOS your operating system fit your needs?  I bet it DOSn't.  Mine does! **