Oracle Apps DBA

My photo
More than 5+ Years of IT Experience in administering Enterprise wide Multi Vendor UNIX Servers, Oracle Databases (8i to 11gR2), Middle-tiers, Applications and Clusters. I am a Sun Certified System Administrator (SCSA) for Solaris 10, oracle 10g database certified associate(OCA), Oracle 10g Database certified professional (OCP) and Oracle E-Business suite R12 certified professionl(OCP)

Oracle Database and Applications

Sunday, 11 July 2010

Chnaging Oracle Database Primary group

Error:


sqlplus / as sysdba, ORA-01031: insufficient privileges


  • First while Installing the primary group of oracle user was set to other, later it has been modified to dbaprod.
  • After modification not able to login to to oracle as /as sysdba user
  • Need to modify config.s file under $ORACLE_HOME/rdbms/lib/config.s or config.c (depends on env) in my server file was config.s
  • backup the current config.s file as orig_config.
original entry:
--------------

.L12:
.ascii "other\0"
.align 8

.L13:
.ascii "other\0"
.align 8


update entry:
-------------

.L12:
.ascii "dbaprod\0"
.align 8

.L13:
.ascii "dbaprod\0"
.align 8


To effect these changes run the mentioned below command:


make -f ins_rdbms.mk ioracle
chmod 755 /appl/11.2.0/dbhome_1//bin

After changing the group now oracle user can login successfully :)

Happy reading.

No comments: