Setup Oracle XE Account on Linux

The oracle account that is created by the Oracle XE installer isn't very helpful.

Setup BashLog into the system as root and su to oracle

#su - oracle

Copy over the bash files from the /etc/skel directory

cp /etc/skel/.bash* .

Edit .bash_profile and add ORACLE_HOME, ORACLE_SID and add $ORACLE_HOME/bin to PATH

vi .bash_profileexport ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server export ORACLE_SID=XE PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin

Log out and back in again and the environment will be setup with bash.  Now its easy to access sqlplus[oracle@localhost ~]$ sqlplus /nolog SQL*Plus: Release 10.2.0.1.0 - Production on Sun May 25 01:23:43 2008 Copyright (c) 1982, 2005, Oracle.  All rights reserved. SQL> connect / as sysdba Connected. SQL> show sga Total System Global Area  289406976 bytes Fixed Size                  1258488 bytes Variable Size              92277768 bytes Database Buffers          192937984 bytes Redo Buffers                2932736 bytes SQL>