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

From: Daniel A. Morgan <Daniel.Morgan_at_attws.com>
Date: Wed, 13 Jun 2001 16:46:37 -0700
Message-ID: <3B27FB5D.38095CDE@attws.com>

"Howard J. Rogers" wrote:

> "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

> >

> >
> >

You are correct. I meant to say make sure it wasn't set to something else and got distracted.

Thanks for the correction.

Daniel A. Morgan Received on Wed Jun 13 2001 - 18:46:37 CDT