$ cat oracle-env.sh
export INSTANT_CLIENT_PATH=/home/oracleInstalls/10.2/instantclient_10_2
export LD_LIBRARY_PATH=$INSTANT_CLIENT_PATH
export PATH=$INSTANT_CLIENT_PATH:$PATH
export TNS_ADMIN=/opt/oracle
export ORACLE_HOME=$INSTANT_CLIENT_PATH
export ORACLE_USERID='user/password'
#export ORACLE_DSN='mydb2.myhost' # this dien't work
export ORACLE_DSN='dbi:Oracle:host=myhost;sid=mydb2' # necessary to get make test to work in dbd::oracle

#needed for sqlplus
export TWO_TASK=mydb2.myhost
export ORACLE_SID=mydb2


alias go-dbd-oracle='cd /usr/cpanroot64/.cpan/build/DBD-Oracle-1.18'
#$dbh = DBI->connect("dbi:Oracle:host=myhost.com;sid=ORCL", $user, $passwd);
alias the-sqlplus='sqlplus user/password@mydb2.myhost'