Re: Password/account problem with OPS$
Date: 7 Jun 1993 21:26:54 GMT
Message-ID: <1v0bqu$ifn_at_news.ysu.edu>
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! **Received on Mon Jun 07 1993 - 23:26:54 CEST