Re: Can't start db after chown & chgrp

Hi Andrew,

Give platform and version next time....

Why did you 3) remove oracle from the dba group ? That is exactly where he needs to be to enable O/S Authentication....put him back there, assure you have REMOTE_LOGIN_PASSWORDFILE = NONE in your init.ora, and you will be able to

  "connect / as sysdba"

without problems.

• Kenneth Koenraadt

acjunk2_at_yahoo.com (Andrew) wrote in message news:<c7603e9b.0211221833.7de0d1b3_at_posting.google.com>...
> I did the following on Linux:
> 1) standard install with user oracle a member of oinstall, sysdba, and
> sysoper.
> 2) I wanted to clean this up, and made oracle a member of a new group
> called oracle.
> 3) Removed oracle's membership in oinstall, sysdba, sysoper groups.
> 4) Then I changed everything in $ORACLE_HOME and $ORACLE_BASE to be a
> member of oracle:oracle.
>
> Now I can't start the database!!! When I do:
> sqlplus /nolog
> conn / as sysdba
>
> I get:
>
> SQL> conn / as sysdba
> ERROR:
> ORA-01031: insufficient privileges
>
> Anyone know what I need to do to fix this problem? Regenerate the
> orapw file? chown/chgrp any other hidden files?
>
> Thanks!
> Andrew
Received on Sat Nov 23 2002 - 07:13:29 CST