Oracle Database - (Software|Installation) Owner (oracle, grid)

> Database > Oracle Database

1 - About

The software owner is the user who owned/performed the installation of an oracle database (single or rac).

Oracle recommends that you create one software owner to own each Oracle software installation, typically:

  • oracle, for the database software
  • and grid for the Oracle Restart owner user.

Oracle software owners must have the Oracle Inventory group as their primary group, so that each Oracle software installation owner can write to the Central Inventory.

In Oracle documentation, the Oracle software owner users are referred to as oracle users.

3 - User

3.1 - oracle

The database software owner (typically, oracle) must also have the OSDBA group of the grid infrastructure home so that database instances can log on to Automatic Storage Management, and (if you create it) the OSOPER group as secondary groups.

You must create an Oracle software owner user in the following circumstances:

  • If an Oracle software owner user does not exist; for example, if this is the first installation of Oracle software on the system.
[root@oel5u5 ~]# id oracle
id: oracle: No such user
  • If an Oracle software owner user exists,
[root@oel5u5 ~]# id oracle
uid=502(oracle) gid=507(oinstall) groups=507(oinstall),502(dba),505(oper),506(asmdba)

but you want to use a different operating system user, with different group membership, to give database administrative privileges to those groups in a new Oracle Database installation.

  • If you have created an Oracle software owner for Oracle grid infrastructure, such as grid, and you want to create a separate Oracle software owner for Oracle Database software, such as oracle.

To create an oracle user, enter a command similar to the following:

[root@oel5u5 ~]# /usr/sbin/useradd -u 502 -g oinstall -G dba,asmdba,[oper] oracle

In the preceding command:

  • The -u option specifies the user ID. Using this command flag is optional, as you can allow the system to provide you with an automatically generated user ID number. However, you must make note of the oracle user ID number, as you require it later during preinstallation.
  • The -g option specifies the primary group, which must be the Oracle Inventory group–for example, oinstall
  • The -G option specifies the secondary groups, which must include the OSDBA group, and, if required, the OSOPER and ASMDBA groups. For example: dba, or asmdba,oper

Set the password of the oracle user:

[root@oel5u5 ~]# passwd oracle

If the oracle user exists, but its primary group is not oinstall, or it is not a member of the appropriate OSDBA or OSOPER groups, then modify it as follows:

Specify the primary group using the -g option and any required secondary group using the -G option:

[root@oel5u5 ~]# /usr/sbin/usermod -g oinstall -G dba,asmdba[,oper] oracle

You run Oracle Universal Installer from the oracle account. However, before you start Oracle Universal Installer you must configure the environment of the oracle user. Configuring the oracle User's Environment

Advertising

3.2 - grid

grid is an Oracle software owner for Oracle grid infrastructure. Oracle grid infrastructure only, the grid user (the Oracle Restart owner user) needs to be in the OSDBA group of every database home.