Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> changing oracle group at os level
Jac
post Jun 27 2007, 10:55 AM
Post #1


Advanced Member
***

Group: Members
Posts: 80
Joined: 23-February 07
Member No.: 7,138



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,
Go to the top of the page
 
+Quote Post
dave
post Jun 27 2007, 11:06 AM
Post #2


Advanced Member
***

Group: Members
Posts: 5,206
Joined: 8-October 04
Member No.: 785



why not just add your user to the right group?
Go to the top of the page
 
+Quote Post
Jac
post Jun 27 2007, 11:28 AM
Post #3


Advanced Member
***

Group: Members
Posts: 80
Joined: 23-February 07
Member No.: 7,138



>> 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?
Go to the top of the page
 
+Quote Post
Asad
post Jul 1 2007, 09:49 AM
Post #4


Advanced Member
***

Group: Members
Posts: 392
Joined: 30-November 05
From: AZ
Member No.: 3,343



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.


QUOTE (Jac @ Jun 27 2007, 04:29 PM) *
= {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?
Go to the top of the page
 
+Quote Post
Jac
post Jul 2 2007, 09:44 AM
Post #5


Advanced Member
***

Group: Members
Posts: 80
Joined: 23-February 07
Member No.: 7,138



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

QUOTE (Asad @ Jul 1 2007, 07:20 PM) *
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.
Go to the top of the page
 
+Quote Post
burleson
post Jul 2 2007, 10:10 AM
Post #6


Advanced Member
***

Group: Members
Posts: 11,417
Joined: 26-January 04
Member No.: 13



Hi,

>> Do i need to shutdown the database

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


--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 27th August 2014 - 12:06 PM