-
Notifications
You must be signed in to change notification settings - Fork 0
/
.oracle
19 lines (16 loc) · 958 Bytes
/
.oracle
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
# Ruby Oracle Client Setup
# For oracle insta-client and oci8
# http://blog.rayapps.com/2008/04/24/how-to-setup-ruby-and-new-oracle-instant-client-on-leopard/
# function oracle2 {
# USER=$(grep contract_development ~/.authinfo| awk '{print $2}')
# PASS=$(grep contract_development ~/.authinfo| awk '{print $3}')
# HOST=$(grep contract_development ~/.authinfo| awk '{print $4}')
# DB=$(grep contract_development ~/.authinfo| awk '{print $5}')
# HIST=~/.sqlplus_history
# touch $HIST
# rlwrap -i -f $HIST -H $HIST -s 30000 /usr/local/oracle/instantclient_10_2/sqlplus $USER/$PASS@"(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=$HOST)(PORT=1521)))(CONNECT_DATA=(SID=$HOST)))"
# }
export DYLD_LIBRARY_PATH=/usr/local/mysql/lib:/usr/local/oracle/instantclient_10_2:$DYLD_LIBRARY_PATH;
export SQLPATH="/usr/local/oracle/instantclient_10_2"
export TNS_ADMIN="/usr/local/oracle/network/admin"
export NLS_LANG="AMERICAN_AMERICA.UTF8"