Forgot your password?
New user?
Document Actions
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_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>
