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

"Daniel A. Morgan" <Daniel.Morgan_at_attws.com> wrote in message news:3B2677FA.AB07BB8E_at_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$
>

No it doesn't. OPS$ is the default, so if that parameter is missing in the init.ora, it will be set to OPS$ whether you like it or not. You only need os_authent_prefix set when you wish to choose something other than ops$.

And it isn't case sensitive, since when you 'create user scott', it gets created as SCOTT anyway, and ops$scott would turn into OPS$SCOTT likewise.

HJR
> And remember it is case sensative.
>
> Daniel A. Morgan
>
>
>
Received on Wed Jun 13 2001 - 16:46:09 CDT