Share the content if you found it is useful (You can share using 300 community websites) click "share" at the end of the post.

You are encouraged to leave a comment.








Thursday, August 19, 2010

Issue with Oracle DB Upgrade 9.2.0.5 to 10.2.0.4 (Apps DB)

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!!!!

No comments:

Related Posts Plugin for WordPress, Blogger...

Let us be Friends...

Share |

Popular Posts

Recent Comments