Evaluate Weigh the pros and cons of technologies, products and projects you are considering.

Role of system administrator versus database administrator

We are trying to determine who does what in our organization. We have a Unix system administrator and an Oracle DBA. They are actually two separate bodies. In the real world, who is usually responsible for the following areas:

  1. Oracle installation, patches and upgrade
  2. Set up standby database and role switching procedure and strategy?

Any information you can provide is appreciated.


In most of the organizations I work with (I'm a consultant, so I see quite a few of these), both of the tasks you list (installation activities and standby management) are DBA functions. Most of the time, the system administrator role is responsible for:

  • proper OS patches and monitoring
  • proper shared memory, semaphore, and networking settings (kernel parameters)
  • storage configuration, mirroring, monitoring for health
  • OS-level monitoring on availability of services, overall system performance, et cetera.
  • OS backups (usually excludes the oradata directories)
  • creation of the oracle user, dba and oinstall groups, OS password policies
  • ensuring that the DBA-provided scripts for starting and stopping Oracle processes are set up to do so at appropriate times
  • monitoring appropriate OS vendor resources for security alerts and addressing vulnerabilities in the OS

The DBA role is usually responsible for things in these general categories:

  • installation, patching, and upgrade of databases
  • all configuration of files in the ORACLE_HOME (i.e. network configuration, init.ora files, et cetera)
  • database creation, tuning, physical design
  • maintenance of scripts to do startup/shutdown for all Oracle processes on the host (give them to the system administrator for execution at proper times)
  • monitoring Oracle security alerts for new vulnerabilities and addressing them
  • anything else that they have privilege to do under the oracle user account


Dig Deeper on Oracle database installation, upgrades and patches