Setting up user profiles for Grid and Oracle user : Oracle RAC 11gR2 on Solaris 10

Below is the Solaris user profiles for “grid” and “oracle” user. If you have followed Oracles official documentation for installation ORacle Rac 11gR2. It is best practice to install Oracle clusterware under grid user and oracle database with Oracle user. It takes a little time to get used to this setup specially for RAC users coming from 10g. But once you get a hang of it. It will work like a charm.
FYI the below user profiles have been set on Solaris 10\
___________________________________________
GRID USER PROFILE
___________________________________________
grid:x:100:100::/export/home/grid:/usr/bin/bash
oracle:x:101:100::/export/home/oracle:/usr/bin/bash
cd /export/home/grid
root@swxracnode1 # more .bash_profile
## If doesnt exist create it and give permission as 775 and owner as grid:oinstall
ORACLE_HOME=/u02/11.2.0/grid
GRID_HOME=/u02/11.2.0/grid
ORACLE_SID=+ASM1
export ORACLE_HOME ORACLE_SID GRID_HOME
PATH=/u02/11.2.0/grid/bin:$PATH
. .bash_profile
___________________________________________
ORACLE USER PROFILE
___________________________________________
grid:x:100:100::/export/home/grid:/usr/bin/bash
oracle:x:101:100::/export/home/oracle:/usr/bin/bash
cd /export/home/oracle
root@swxracnode1 # more .bash_profile
## If doesnt exist create it and give permission as 775 and owner as oracle:oinstall
ORACLE_HOME=’/u01/app/oracle/product/11.2.0/db_1′
ORACLE_SID=’swx1′
export ORACLE_HOME ORACLE_SID
PATH=$PATH:$ORACLE_HOME/bin
export PATH
ORACLE_UNQNAME=’swx’
export ORACLE_UNQNAME

Category: DatabaseSQL

Tags:

Leave a Reply

Article by: Shadab Mohammad