2009年2月19日星期四

three things to do after oracle-xe-universal install

nowdays oss.oracle.com bandwidth is comparable with mirrors.163.com.
it's easy to download and install oracle-xe-universal for a test.
this post just make the most of DBA configuration into one-liner style.

sudo usermod -G $(groups $(whoami)| sed 's/$/ dba/;s/ /,/g') $(whoami)

dba ()
{
    ORACLE_HOME=$(dpkg -L oracle-xe-universal | grep server$) PATH=$PATH:$ORACLE_HOME/bin ORACLE_SID=XE sqlplus / as sysdba
}

typeset -f dba >> .bashrc

没有评论: