Patterns

su to user oracle
sqlplus /nolog
CONNECT sys/password as SYSDBA
SHUTDOWN
SHUTDOWN IMMEDIATE
SHUTDOWN ABORT
STARTUP

Shell scripts to start stop database
$ORACLE_HOME/bin/dbstart
$ORACLE_HOME/bin/dbstop

Oracle Enterprise Manager Database Control
$ORACLE_HOME/bin/emctl stop dbconsole
$ORACLE_HOME/bin/emctl start dbconsole

ORACLE_SID and ORACLE_HOME can be found in /etc/oratab. Format is
$ORACLE_SID:$ORACLE_HOME:AUTOSTART Y/N

desc all_tables;

alter session set nls_date_format = 'dd-mm-yyyy hh24:mi:ss';

ORACLE_HOME=/opt/oracle/product/9206
ORACLE_OWNER=oracle
LD_LIBRARY_PATH=/usr/lib:/opt/oracle/product/9206/lib
NLS_DATE_FORMAT=yyyy-mm-dd hh24:mi:ss
NLS_LANG=_.WE8ISO8859P1

$ENV{'ORACLE_HOME'} = '/opt/oracle/product/9206';
$ENV{'LD_LIBRARY_PATH'} = '/lib:/usr/lib:/opt/oracle/product/9206/lib';