oracle用户环境变量配置

## For Oracle ##
export EDITOR=vi
export ORACLE_SID=orcl
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
export ORA_CRS_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1/crs_1
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
#export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
#export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib64:/usr/lib64:/usr/local/lib64:/usr/X11R6/lib64/
export PATH=$ORACLE_HOME/bin:$ORA_CRS_HOME/bin:$PATH
umask 022

#export NLS_LANG='AMERICAN_AMERICA.UTF8'
export NLS_LANG=AMERICAN_AMERICA.ZHS16CGB231280
#export NLS_LANG=AMERICAN_AMERICA.ZHT16BIG5
#export NLS_LANG="traditional chinese_taiwan.ZHT16BIG5"

#export LC_CTYPE=en_US.UTF-8
export LANG=en_US.UTF-8

alias sqlplus="uniread sqlplus"
alias rman="uniread rman"
alias adrci="uniread adrci"

SuSE安装oracle 12c报错总结(随时更新)

根据官方文档的参考配置进行设置后,如安装在大内存服务器中,会出现如下错误

oracle:system defined limits for shared memery was misconfiguration

解决方法如下: Edit /etc/sysctl.conf and ensure the following lines are present

kernel.shmall = 18350080
kernel.shmmax = 75161927680
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128

0 条评论

发表回复

Avatar placeholder

您的邮箱地址不会被公开。 必填项已用 * 标注