Re: DBA-Sys admin Relationship - Need help to define it

badri (badri_at_cc.gatech.edu) wrote:
: Hi:
 

: 1. A few weeks ago, I (as the DBA) was denied root access. I
: gather from netters that this is the norm.

  u sure do need root access while installing but not really in the   daily maintenance. But u must and should have the DB root access   ie. login as internal. Also, u should be a part of the dba group   on UNIX to login as internal. u need not be a part of dba group to   login as SYS and SYSTEM.

  I am not really sure about the backups.

  hope this helps...

  Ravi

: 2. It appears as though I may not be able to install new
: ORACLE versions on the production machine. I do it on the test box
: and the Sysadmin does it on production box. THe reason given was
: that we are using volume managers and I cannot issue those commands
: since I do not have root privilege.
 

: 3. I do not have any control over backups since sysadmins are again
: backing up the entire filesystem to tape and unmounting/mounting
: file systems in the process, thus requiring root access.
 

: It appears to me as though this is not the ideal set-up for aa DBA.
: I do understand that the relationship between DBA and sysadmin is defined
: differently in every company. But, can you comment if this set-up I
: described seems acceptable to you?
 

: Before I voice my concerns to my boss, I want to run it by the
: experienced netters to know whether I am justified taking up my boss'
: time!
 

: Any comments are gracefully welcome,
 

: -Badri
Received on Thu Feb 22 1996 - 00:00:00 CET