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