Tuesday, May 27, 2008

Required users and groups while installing oracle

In this topic I will describe about the users and groups that are needed to install oracle on linux or solaris machine.

Groups Needed
-----------------------------------------------
Mandatory Group- The OSDBA Group(dba):
You must create this group the first time you install Oracle Database software on the system. It identifies operating system user accounts that have database administrative privileges (the SYSDBA privilege). We later can enter as sysdba if current user is a group of OSDBA. The default name for this group is dba.

Optional Group-The OSOPER group (oper): The users of this group have a limited set of database administrative privileges (the SYSOPER privilege). This is optional group.

To know more about SYSDBA and SYSOPER authenticated operations have a look at SYSDBA and SYSOPER Authenticated Operations.

Mandatory Group-The Oracle Inventory group (oinstall):
This group owns the Oracle
inventory, which is a catalog of all Oracle software installed on the system. If Oracle software is already installed on the system, then the existing Oracle Inventory group must be the primary group of the operating system user that you use to install new Oracle software.

Users Needed:
--------------------------
An unprivileged user (nobody):
Verify that the unprivileged user nobody exists on the system. The nobody user must own the external jobs (extjob) executable after the installation.

The Oracle software owner user (typically, oracle): You must create this user the first time you install Oracle software on the system.This user owns all of the software installed during the installation. This user must have the Oracle Inventory group as its primary group. It must also have the OSDBA and OSOPER groups as secondary groups.

Related Documents:
----------------------------

DBA Authentication

No comments:

Post a Comment