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 Thu Apr 17 1997 - 00:00:00 CDT