Monday, November 19, 2012

oracle user account in Linux


Creating a oracle user account in Linux

Log in as root, please. Use tcsh or csh. Do not use su or sudo.


Please check the availability for UID in the /etc/passwd.
Create a user account:
-   oracle, account with a non-zero and available UID number such as 1001
     (installation owner of Oracle)

groupadd oracleinstall
groupadd dba
groupadd oracle
useradd -u 1001 -o -g oracle -s /bin/tcsh -d /home/oracle -m -c 'Oracle Owner' oracle
usermod -aG dba,oracleinstall oracle
passwd oracle
id oracle
chown -R oracle  /home/oracle/
cat /etc/group

You should see an entry in the /etc/passwd like this:
  oracle:x:uid_nr:group_nr:Oracle Owner:/home/oracle:/bin/tcsh


 Setting the environment variables

Before the proper installation of the Oracle database system check and complete environment variables:
su - oracle
env | grep ORACLE
set | grep ORACLE


Set them if they are not properly set:
su - oracle
vi /home/oracle/.bash_profile
ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/dbhome_1;
export ORACLE_HOME;
ORACLE_SID=essdb; export ORACLE_SID;
ORACLE_OWNER=oracle; export ORACLE_OWNER;
ORACLE_BASE=/home/oracle/app/oracle; export ORACLE_BASE;
PATH=$ORACLE_HOME/bin:$PATH; export PATH

touch /home/oracle/.cshrc
vi /home/oracle/.cshrc
setenv ORACLE_HOME /home/oracle/app/oracle/product/11.2.0/dbhome_1
setenv ORACLE_SID essdb
setenv ORACLE_OWNER oracle
setenv ORACLE_BASE /home/oracle/app/oracle
setenv PATH $ORACLE_HOME/bin:$PATH

reboot
su - oracle
env | grep ORACLE
set | grep ORACLE

No comments: