centOS 6.3（64位）下安装oracle 11gR2

最新推荐文章于 2021-04-04 23:12:55 发布

az312994747

最新推荐文章于 2021-04-04 23:12:55 发布

阅读量514

点赞数

CC 4.0 BY-SA版权

分类专栏： Oracle

本文链接：https://blog.youkuaiyun.com/az312994747/article/details/8657082

Oracle 专栏收录该内容

2 篇文章

订阅专栏

本文详细介绍在Linux环境下安装Oracle数据库所需的软件包、配置用户与权限、调整系统参数等关键步骤。

一、安装rpm包：
binutils-2.20.51.0.2-5.11.el6 (x86_64)
compat-libcap1-1.10-1 (x86_64)
compat-libstdc++-33-3.2.3-69.el6 (x86_64)
compat-libstdc++-33-3.2.3-69.el6.i686
gcc-4.4.4-13.el6 (x86_64)
gcc-c++-4.4.4-13.el6 (x86_64)
glibc-2.12-1.7.el6 (i686)
glibc-2.12-1.7.el6 (x86_64)
glibc-devel-2.12-1.7.el6 (x86_64)
glibc-devel-2.12-1.7.el6.i686
ksh
libgcc-4.4.4-13.el6 (i686)
libgcc-4.4.4-13.el6 (x86_64)
libstdc++-4.4.4-13.el6 (x86_64)
libstdc++-4.4.4-13.el6.i686
libstdc++-devel-4.4.4-13.el6 (x86_64)
libstdc++-devel-4.4.4-13.el6.i686
libaio-0.3.107-10.el6 (x86_64)
libaio-0.3.107-10.el6.i686
libaio-devel-0.3.107-10.el6 (x86_64)
libaio-devel-0.3.107-10.el6.i686
make-3.81-19.el6

sysstat-9.0.4-11.el6 (x86_64)

二、安装ODBC驱动
unixODBC-2.2.14-11.el6 (x86_64) or later
unixODBC-2.2.14-11.el6.i686 or later
unixODBC-devel-2.2.14-11.el6 (x86_64) or later

unixODBC-devel-2.2.14-11.el6.i686 or later

三、创建用户组：oinstall,dba,oper
用户：oracle

# useradd -g oinstall -G dba oracle

四、设置内核参数
打开文件： vi /etc/sysctl.conf
修改下列参数
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144

net.core.wmem_max = 1048576

五、修改文件限制
vi /etc/security/limits.conf
添加下面参数
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536

oracle soft stack 10240

六、创建安装路径
# mkdir -p /u02/app/
# chown -R oracle:oinstall /u02/app/

# chmod -R 775 /u02/app/

七、切换为oracle用户，修改oracle用户的环境变量
vi .bash_profile
添加下列参数
export TMP=/tmp
export TMPDIR=/tmp
export ORACLE_BASE=/u02/app/oracle/product
export ORACLE_HOME=$ORACLE_BASE/11.2.0/dbhome_1
export ORACLE_SID=orcl
export ORALCE_TERM=xterm
export PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_OWNER=oracle
export NLS_LANG="SIMPLIFIED CHINESE_CHINA.ZHS16GBK"
umask 022
if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi

八、安装数据库