Useful Oracle DBA Commands

Sample .profile (.bash_profile for oracle user in /home/oracle)

---------

# .bash_profile

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

# User specific environment and startup programs

umask 022
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE

ORACLE_HOME=/u01/app/oracle/oracle/product/10.2.0/db_1; export ORACLE_HOME
ORACLE_SID=MCDB01 export ORACLE_SID


TMP=/u01/oratmp; export TMP
TMPDIR=$TMP; export TMPDIR

PATH=$PATH:$HOME/bin

PATH=$PATH:$ORACLE_HOME/bin

export PATH
unset USERNAME

---------

$>sqlplus / as sysdba

sqlplus>startup;

sqlplus>shutdown;

sqlplus>insert into DEPT values (60, 'Manager', 'Dallas');

sqlplus>commit;

sqlplus>show parameter log

-------------

-Suresh