This blog is about error "insufficient Privileges" while connecting as sys as sysdba
SQL> conn / as sysdba
ERROR:
ORA-01031: insufficient privileges
When logging into the new ORACLE_HOME (to be upgraded)
I received this error. (ORA-01031)
OS: HP-UX 11.11 64 bit
OS_GROUP other than DBA My groups is USERS
Reason: in rdbms/lib config.c is hard-coded the group as "dba"
Solution:
1. Navigate to new ORACLE_HOME/rdbms/lib
2. Look for config.c
3. Backup config.o as config.o_bk
4. Backup config.c as config.c_bk
5. Open config.c
Change the lines as
Previous entry
/* SS_DBA_GRP defines the UNIX group ID for sqldba adminstrative access. */
/* Refer to the Installation and User's Guide for further information. */
#define SS_DBA_GRP "dba"
#define SS_OPER_GRP "dba"
char *ss_dba_grp[] = {SS_DBA_GRP, SS_OPER_GRP};
Changed Section
Previous entry
/* SS_DBA_GRP defines the UNIX group ID for sqldba adminstrative access. */
/* Refer to the Installation and User's Guide for further information. */
#define SS_DBA_GRP "users"
#define SS_OPER_GRP "users"
char *ss_dba_grp[] = {SS_DBA_GRP, SS_OPER_GRP};
6. run
make -f ins_rdbms.mk config.0 ioracle
once finished,
try to login as sysdba
it should work.
Cheers!!!!