Re: Sysoper doesn't work after changing default sysoper group

This is fixed. It seems like you have to create the OS group BEFORE you relink the oracle executable. This time, since I already had the oper group, I deleted the config.o file, relinked oracle, and now the connect / as sysoper by the new user works.

Thanks

"Still Here" <evetsdrawoh_at_hotmail.com> wrote in message news:e2352707.0204110947.aa97d3b_at_posting.google.com...
> OS - Linux 7.1
> DB - 9.0.1.0.0
>
> I understand that you can assign an OS user to the group defined in
> $ORACLE_HOME/rdbms/lib/config.c as the SYS_OPER group. I edited this
> file and changed the default "dba" to "oper". I then relinked Oracle
> with the following:
>
> make -f ins_rdbms.mk ioracle, which completed without errors.
>
> I then added a user and placed them in the newly created oper group.
>
> If I then su to this user and open a sqlplus session and attempt to
> connect / as sysoper, it tells me
>
> ORA-01031: insufficient privileges
>
> Everything else works fine. Is there something I am missing?
>
> Thanks!
Received on Thu Apr 11 2002 - 13:32:14 CDT