RE: OPS$users

From: Paul Baumgartel <pbaumgartel_at_mortgagesight.com>
Date: Fri, 31 Aug 2001 09:46:18 -0700
Message-ID: <F001.0037F928.20010831093656@fatcity.com>

In your init.ora, check the value of OS_AUTHENT_PREFIX. If it's not "OPS$", that's the problem. Most people set it to "" (null string) now, so your Oracle username would be production, not ops$production.

Paul Baumgartel
MortgageSight Holdings, LLC
pbaumgartel_at_mortgagesight.com

-----Original Message-----
Sent: Friday, August 31, 2001 1:19 PM
To: Multiple recipients of list ORACLE-L

Hi all,

Is there some db parameter I need to set to get the ops$ login to work? I am using ORACLE V8.1.7 on a Compaq Tru64 V5.1 I have created a unix user called production. I then created the user in the database called ops$production.

When I login as this user and try to go into SQL*PLUS I get an invalid username/password error.

I get the error if I type:

sqlplus /

sqlplus
get the username prompt and hit enter.

Thanks
David
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Bartolo, David
INET: bartolo_at_USCOLO.edu

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Paul Baumgartel
INET: pbaumgartel_at_mortgagesight.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------