Re: OPS$user:-- Why won't it work????

From: Daniel A. Morgan <Daniel.Morgan_at_attws.com>
Date: Tue, 12 Jun 2001 13:13:46 -0700
Message-ID: <3B2677FA.AB07BB8E@attws.com>

Dirk Mika wrote:

> Hi,
>
> > I created the ops$user identified externally and granted connect to it. At
> > the operating system level the user is in the dba group.
> > Why wont't sqlplus / work?
>
> As far as i know if your os-username is "abc" than you have to create an
> oracle user "ops$abc". That's what you have done?
>
> Which error-message do you get, when you try to logon?
>
> Regards
> Dirk Mika

One possible issue could be related to the initSID.ora file.

The following must be in it.

os_authent_prefix = ops$

And remember it is case sensative.

Daniel A. Morgan Received on Tue Jun 12 2001 - 15:13:46 CDT