jueves, 12 de junio de 2008

Oracle Database 10g Creating Required Operating System Groups and Users for Solaris SPARC 64-Bit)

Creating Required Operating System Groups and Users

Creating the Oracle Inventory Group
When you install Oracle software on the system for the first time, Oracle Universal Installer creates the oraInst.loc file. This file identifies the name of the Oracle Inventory group and the path of the Oracle Inventory directory.

To determine whether the Oracle Inventory group exists, enter the following command:

# more /var/opt/oracle/oraInst.loc

If the oraInst.loc file exists, then the output from this command is similar to the

following:inventory_loc=/u01/app/oracle/oraInventoryinst_group=oinstall

The inst_group parameter shows the name of the Oracle Inventory group, oinstall.
Creating the Oracle Inventory Group

If the oraInst.loc file does not exist, then create the Oracle Inventory group by entering the following command:

# /usr/sbin/groupadd oinstall
# /usr/sbin/groupadd dba
# /usr/sbin/groupadd oper

# id -a oracle

If the oracle user exists, then the output from this command is similar to the following:uid=440(oracle) gid=200(oinstall) groups=201(dba),202(oper)

Creating an Oracle Software Owner User

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

# /usr/sbin/useradd -g oinstall -G dba[,oper] oracle

# mkdir /export/home

# /usr/sbin/usermod -d /export/home/oracle -m oracle



In this command:
o The -g option specifies the primary group, which must be the Oracle Inventory group, for example oinstall
o The -G option specifies the secondary groups, which must include the OSDBA group and if required, the OSOPER group. For example, dba or dba,oper

2. Set the password of the oracle user:

# passwd -r

Modifying an Oracle Software Owner User

# /usr/sbin/usermod -g oinstall -G dba[,oper] oracle

1. To determine whether the user exists, enter the following command: