# simple file to set oracle env variables # 2005-07-17 Bikle ############################################# # Variables for the db on this mac: ORACLE_BASE=/Users/oracle ORACLE_SID=orcl ORACLE_HOME=/Users/oracle/OraHome_5 JAVA_HOME=${ORACLE_HOME}/jdk export ORACLE_BASE ORACLE_HOME ORACLE_SID JAVA_HOME PATH=${ORACLE_HOME}/bin:${JAVA_HOME}/bin:/usr/bin:/bin:/usr/sbin:/sbin:/Users/oracle:/usr/local/bin:.:/Library/Java/Home/bin:/usr/X11R6/bin export PATH # Variables for the client installation: ## ORACLE_BASE=/oracle ## ## ORACLE_HOME=/oracle/instantClient ## ORACLE_HOME=/oracle/macClientAdministrator ## ## JAVA_HOME=/Users/oracle/OraHome_5/jdk ## export ORACLE_BASE ORACLE_HOME ORACLE_SID JAVA_HOME ## ## PATH=${ORACLE_HOME}/bin:${JAVA_HOME}/bin:/usr/bin:/bin:/usr/sbin:/sbin:/Users/oracle:/usr/local/bin:.:/pt/bin:/Library/Java/Home/bin:/usr/X11R6/bin ## export PATH NLS_DATE_FORMAT='YYYY-MM-DD' export NLS_DATE_FORMAT DYLD_LIBRARY_PATH=${ORACLE_HOME}/lib:/usr/local/lib export DYLD_LIBRARY_PATH CLASSPATH=/CD/MAC/m51.app/AddOns/JLink/JLink.jar:/oracle/OraHome_5/jdbc/lib/ojdbc14.jar:. export CLASSPATH # some aliases alias ls='ls -CFa' alias al=alias alias d=date alias cx='chmod +x' alias grip='grep -i' alias grp=grip alias alg='alias|grp' alias envg='env|grp' alias ff='find . -name \!* -print' alias h=history alias hg='h|grp' alias j=jobs alias ll='ls -l' alias m=more alias ltr='ls -latr' alias psor='ps aux|sort' alias psorg='psor|grp' alias disp='DISPLAY=' alias sql=sqlplus alias sqruby='sql ruby/ruby'