ครั้งหนึ่งที่เราได้เรียนรู้

# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
 . ~/.bashrc
fi

# User specific environment and startup programs

ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.1.0/db_1; export ORACLE_HOME
ORACLE_SID=oratest; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH

[root@oracle11g-server ~]# su - oracle
[oracle@oracle11g-server ~]$ sqlplus

SQL*Plus: Release 11.1.0.6.0 - Production on Wed Aug 5 14:53:06 2009

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

Enter user-name: / as sysdba
Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area  422670336 bytes
Fixed Size      1300352 bytes
Variable Size    272631936 bytes
Database Buffers   142606336 bytes
Redo Buffers      6131712 bytes
Database mounted.
Database opened.
SQL>