# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
# sh /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.sh
export ORACLE_HOME="/usr/lib/oracle/xe/app/oracle/product/10.2.0/server"
export PATH=$PATH:/sbin:$ORACLE_HOME/bin
export JAVA_BINDIR="/usr/java/jdk1.5.0_11/bin"
export JAVA_HOME="/usr/java/jdk1.5.0_11"
export JAVA_ROOT="/usr/java/jdk1.5.0_11"
export JDK_HOME="/usr/java/jdk1.5.0_11"
export JRE_HOME="/usr/java/jdk1.5.0_11/jre"
export SDK_HOME="/usr/java/jdk1.5.0_11"
export ORACLE_SID=XE
export NLS_LANG=`$ORACLE_HOME/bin/nls_lang.sh`
if [ $?LD_LIBRARY_PATH ]
then
LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
else
LD_LIBRARY_PATH=$ORACLE_HOME/lib
fi
export LD_LIBRARY_PATH
А вот результат
[sash@localhost ~]$ env
SSH_AGENT_PID=18148
HOSTNAME=localhost.localdomain
SHELL=/bin/bash
TERM=xterm
DESKTOP_STARTUP_ID=
HISTSIZE=1000
XDG_SESSION_COOKIE=d26b2de605c44ee21c6c21004663c000-1183535232.130716-629215011
GTK_RC_FILES=/etc/gtk/gtkrc:/home/sash/.gtkrc-1.2-gnome2
WINDOWID=48234790
USER=sash
JRE_HOME=/usr/java/jdk1.5.0_11/jre
LS_COLORS=no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;0
1:or=01;05;37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32:*.exe=00;32:*.com=00;32:*.b
t
m=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.arj=00;31:*
.
taz=00;31:*.lzh=00;31:*.zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.b
z
=00;31:*.tz=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00;35:*
.
xbm=00;35:*.xpm=00;35:*.png=00;35:*.tif=00;35:
ORACLE_SID=XE
GNOME_KEYRING_SOCKET=/tmp/keyring-ijdreg/socket
SSH_AUTH_SOCK=/tmp/ssh-fVJXq18056/agent.18056
SESSION_MANAGER=local/localhost.localdomain:/tmp/.ICE-unix/18056
USERNAME=sash
MAIL=/var/spool/mail/sash
PATH=/usr/kerberos/bin:/usr/local/bin:/usr/bin:/bin:/sbin:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin
DESKTOP_SESSION=default
JAVA_BINDIR=/usr/java/jdk1.5.0_11/bin
GDM_XSERVER_LOCATION=local
INPUTRC=/etc/inputrc
PWD=/home/sash
JAVA_HOME=/usr/java/jdk1.5.0_11
LANG=ru_RU.UTF-8
KDE_IS_PRELINKED=1
GDM_LANG=ru_RU.UTF-8
KDEDIRS=/usr
GDMSESSION=default
SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
SHLVL=2
HOME=/home/sash
JDK_HOME=/usr/java/jdk1.5.0_11
GNOME_DESKTOP_SESSION_ID=Default
LOGNAME=sash
DBUS_SESSION_BUS_ADDRESS=unix:abstract=/tmp/dbus-mj1eIpAclK,guid=4006999fbaa7a9a49a2e1400468b5080
LESSOPEN=|/usr/bin/lesspipe.sh %s
DISPLAY=:0.0
ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
G_BROKEN_FILENAMES=1
JAVA_ROOT=/usr/java/jdk1.5.0_11
COLORTERM=gnome-terminal
XAUTHORITY=/tmp/.gdmH61WUT
_=/usr/bin/env
[sash@localhost ~]$
Параметры:
NLS_LANG
LD_LIBRARY_PATH
отсутствуют.
Эти строки я взял из файла oracle_env.sh
ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
export ORACLE_HOME
ORACLE_SID=XE
export ORACLE_SID
NLS_LANG=`$ORACLE_HOME/bin/nls_lang.sh`
export NLS_LANG
PATH=$ORACLE_HOME/bin:$PATH
export PATH
if [ $?LD_LIBRARY_PATH ]
then
LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
else
LD_LIBRARY_PATH=$ORACLE_HOME/lib
fi
export LD_LIBRARY_PATH
В руководстве по установке говориться
After you have installed and configured Oracle Database XE Server, users must set their environment before they use Oracle Database XE. They do not need to log on with root permissions to do so. Oracle Database XE provides a script that sets the necessary environment variables.
Follow these steps:
1.
Go to the following directory:
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin
2.
Look for the following scripts:
oracle_env.sh (for Bourne, Bash, or Korn shell)
3.
Run the appropriate script for your shell. For example:
*
Bourne, Bash, or Korn shell:
$ . ./oracle_env.sh
You may also want edit your login or profile files so that these environment variables are set properly each time you log in or open a new shell.
For Bourne, Bash, or Korn shell, enter the following line into the .bash_profile (to log in) or .bashrc file (to open a new shell):
. /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.sh
Но все это результатов почему-то не дает, вот я и решил разместить все это ручками в файл переменных окружения.
В чем дело?
