Tuesday, May 29, 2007

ORA-1031 : change oracle owner group

Today hit ORA-01031 Insufficient Privilege during running dbua .

Action taken:
1. Update the new group of oracle owner in $ORACLE_HOME/rdbms/lib/config.c (this is HP-UX platform, other platform could be config.s)
2. make -f ins_rdbms.mk config.o ioracle

Explanation from Oracle
By modifying the OSDBA and OSOPER values in the "config.c" or "config.s"
file you can change the group that has OSDBA and/or OSOPER privlidges in
the database.