怎么在linux中配置oracle的环境变量？

编辑Oracle家目录下面的.bash_profile文件.

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

unset USERNAME

export PATH

umask 022

TERM=xterm

export TERM

TMPDIR=/tmp

export TMPDIR

export ORACLE_SID=orcl

export ORACLE_BASE=/opt/oracle

export ORACLE_HOME=/opt/oracle/product/10.1.0

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib

export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib

export TNS_ADMIN=$ORACLE_HOME/network/admin

export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data

export ORACLE_OWNER=oracle

export ORACLE_TERM=xterm

#export LDEMULATION=elf_i386_glibc21

#export GCC_EXEC_PREFIX=/usr/i386-glibc21-linux/lib/gcc-lib/

export LD_ASSUME_KERNEL=2.6.18

PATH=$ORACLE_HOME/bin:/bin:/usr/bin:/usr/local/bin:/usr/sbin:/usr/X11R6/bin:/opt/oracle/product/10.1.0/bin

/ets/systcl.conf

kernel.shmmax = 4294967295

# Controls the maximum number of shared memory segments, in pages

kernel.shmall = 2147483648

kernel.shmmni = 4096

kernel.shmall = 2097152

kernel.sem = 250 32000 100 128

fs.file-max = 65536

net.ipv4.ip_local_port_range = 1024 65000

"/etc/security/limits.conf" 5C oracle softnofile 65536

oracle hardnofile 65536

oracle softnproc 16384

oracle hardnproc 16384

某些变量要根据自己安装的版本改变。不要照抄。

1.是的，一般配置完.bash_profile后要重读环境变量：source .bash_profile.

2.你的配置文件确实有问题，你没有加载库文件。正确配置如下：

su - oracle

vim .bash_profile，在文件最后添加:

export ORACLE_BASE=/oracle/app

export ORACLE_HOME=$ORACLE_BASE/oracle/product/10.2.0/db_1

export ORACLE_SID=TEST (或者你写的是FLOW)

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib

export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin

export LANG=C (或者你写的是zh_CN.UTF-8)

然后source .bash_profile重读环境变量。

卢韬旭

---