More suggestions:
Do this:
CREATE USER ops$root IDENTIFIED BY <password>;
As root: sqlplus / (or connect /)- it should work.
Log out as ops$root, log into SQL*Plus as system (UNIX user root):
ALTER USER ops$root IDENTIFIED EXTERNALLY;
connect /
and see what happens.
You could also add the line OS_AUTHENTICATION_PREFIX="" (two double
quotes) to your init.ora file and try everything all over again (with
ORACLE user root this time around).
I apologize for flooding you with all these suggestions, but
currently I don't have access to an ORACLE database to try them
out before posting them.
I hope this helps
Michael Serbanescu
Sr. Consultant, MIACO Corporation
Michael Serbanescu wrote:
>
> So, you tried "sqlplus /" as root and it did no work ?
> Interesting ! Can you stand some other suggestions
> (hopefully more helpful this time around):
>
> - is root user part of the UNIX dba group ? If yes, remove
> it from there, try again and see what happens. If not, add
> it to the group, try again and see what happens.
>
> - do what you did with the root user initially, with any or all user(s)
> in the dba UNIX group (oracle ?) and see what happens.
>
> I hope this helps.
>
> Michael Serbanescu
> Sr. Consultant, MIACO Corporation
> ---------------------------------------------------------------------
> twod_at_not.valid wrote:
> >
> > Michael Serbanescu (mserban_at_postoffice.worldnet.att.net) wrote:
> > : I don't think IDENTIFIED EXTERNALLY will work once you are in SQL*Plus. So, after
> >
> > It does.
> >
> > : Also, have you set the INIT.ORA parameter OS_AUTHENT_PREFIX to OPS$ ?
> >
> > Nope, but it defaults to ops$ - Verified in V_$PARAMETER.
> > Other ops$ accounts can be created and work just dandy.
> > It's just the root (super)user that this spits the dummy on.
> >
> > : I hope this helps.
> >
> > Well ....
> >
> > IAP
> >
> > --
> > In an attempt to reduce junk email I use an invalid 'From' address.
> > My correct email address is twod_at_value.net
Received on Fri Apr 18 1997 - 00:00:00 CDT