怎么在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

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

PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:$HOME/bin:/usr/bin/X11:/sbin:.

export PATH

if [ -s "$MAIL" ] # This is at Shell startup. In normal

then echo "$MAILMSG"# operation, the Shell checks

fi # periodically.

PATH=$PATH:$HOME/bin

export PATH

unset USERNAME

export ORACLE_BASE= #根据需要自己选择路径

export ORACLE_HOME=$ORACLE_BASE/11.2.0/db_home1 #同上

export ORACLE_SID=orcl #SID

export ORACLE_HOSTNAME=zlyydb #主机名

export ORACLE_TERM=xterm

export NLS_LANG NLS_LANG=american_america.zhs16cgb231280

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

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

LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib

export LD_LIBRARY_PATH

export PATH=$PATH:$ORACLE_HOME/bin

export AIXTHREAD_SCOPE=S

umask 022

---