Setup Oracle XE Account on Linux

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

Setup Bash

Log 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_profile

export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server


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 - Production on Sun May 25 01:23:43 2008

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> connect / as sysdba
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

Leave a comment

Your email address will not be published. Required fields are marked *