Oracle User and Groups

Oracle User and Groups

Create a user for Oracle to run as:

  # adduser oracle

Then create various groups which normal users might belong to in order to administer Oracle.

  # addgroup dba
  # addgroup oinstall

And add user oracle to these groups:

  # adduser oracle dba
  # adduser oracle oinstall

For this new oracle user edit /home/oracle/.bash_profile to add the following lines:

  export ORACLE_BASE=/ktnet/oracle
  export ORACLE_HOME=$ORACLE_BASE/product/8.1.7
  export PATH=$PATH:$ORACLE_HOME/bin
  export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib
  export ORACLE_SID=ora8
  export ORACLE_TERM=vt100
  export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
  
  umask 022

Now make sure the appropriate installation directory is set up:

  # cd /ktware
  # mkdir oracle
  # chown -R oracle.dba oracle