changing oracle group at os level Options

[Jac]

hi,

this is oracle 10g on linux. i am going to change my oracle group in $ORACLE_HOME/rdbms/lib/config.c file for my oracle user group to make it part of dba group. I can't connect to db at OS level therefore i am doing this.

to do so, i've to make ins_rdbms.mk file over again. Do i need to shutdown the database while i make the file or it can remain open? Is there any other consideration you guys suggest to peform this action.

thanks,

[dave]

why not just add your user to the right group?

[Jac]

>> id
uid=500(vancorlc) gid=1000(orcldba) groups=1000(orcldba)

>> grep dba /etc/group
orcldba:x:1000:

>> cat $ORACLE_HOME/rdbms/lib/config.c
/* SS_DBA_GRP defines the UNIX group ID for 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};
====

ok, oracle owner is orcldba; i do not have root access plus i am not sure changing group will do anything with gid,uid for oracle user & what would be implications of this. change in config.c file will point dba group to orcldba i.e. 'right group'. is it right approach?

[Asad]

you need to change in config.c file

#define SS_DBA_GRP "dba"
to
#define SS_DBA_GRP "orcldba"

and then make the ins_rdbms_mk file.
then relink all.

= {SS_DBA_GRP, SS_OPER_GRP};
====

ok, oracle owner is orcldba; i do not have root access plus i am not sure changing group will do anything with gid,uid for oracle user & what would be implications of this. change in config.c file will point dba group to orcldba i.e. 'right group'. is it right approach?

[Jac]

Do i need to shutdown the database while i make the file or it can remain open?

you need to change in config.c file

#define SS_DBA_GRP "dba"
to
#define SS_DBA_GRP "orcldba"

and then make the ins_rdbms_mk file.
then relink all.

[burleson]

Hi,

>> Do i need to shutdown the database

When re-linking an executable, a bounce is always a good idea (unless you like suprises)!