Linux+Oracle+11G+R2+64+安装文档.doc

Linux Oracle 11G R2 64 安装文档

目录

1. 环境及系统参数配置.....................................................................................................................2

1.1. 添加 oracle,grid 用户及设置环境变量(在所有节点上执行)............................................2

1.2. 所必需的安装包检查..........................................................................................................4

1.3. 修改系统配置......................................................................................................................5

2. 时间同步(分别在不同前置机上执行)..........................................................................................6

3. SSH 信任关系设置(Oracle 用户下执行)......................................................................................6

8. 创建数据库...................................................................................................................................21

9. 附录...............................................................................................................................................32

9.1. 自动内存管理增加/dev/shm.............................................................................................32

9.2. NTPD 设置.........................................................................................................................33

9.3. 增大 SWAP 区....................................................................................................................33

1. 环境及系统参数配置

1.1.添加 oracle,grid 用户及设置环境变量(在所有节点上执

行)

1.1.1 添加 oracle 用户

# /usr/sbin/groupadd –g 1005 asmdba

# /usr/sbin/groupadd –g 1006 orauser

# /usr/sbin/usermod -g oinstall -G dba,asmdba oracle

# /usr/sbin/usermod -g oinstall -G dba,asmdba,oper,oinstall,asmadmin grid

//设置 oracle 密码

passwd oracle

passwd grid

//创建 oracle 的安装目录

mkdir /u01

//修改目录权限

# chown -R oracle:oinstall /u01/app/oracle

1.1.2 配置环境变量

设置 Oracle 用户环境变量

vi /home/oracle/.bash_profile 添加以下内容

export ORACLE_UNQNAME=rac

export ORACLE_SID=rac1[2]

export ORACLE_BASE=/u01/app

export ORACLE_HOME=$ORACLE_BASE/oracle

export ORACLE_OWNER=oracle

export

unset USERNAME

alias sqlplus="rlwrap sqlplus"

umask 022

设置 grid 用户环境变量

vi /home/grid/.bash_profile

export ORACLE_SID=+ASM1[2]

export ORACLE_BASE=/u01/app

export ORACLE_HOME=/u01/grid

export ORACLE_OWNER=grid

export

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

#alias sqlplus="rlwrap sqlplus"

umask 022

1.2.所必需的安装包检查

binutils-2.17.50.0.6

compat-libstdc++-33-3.2.3

compat-libstdc++-33-3.2.3 (32 bit)

elfutils-libelf-0.125

elfutils-libelf-devel-0.125

gcc-4.1.2

gcc-c++-4.1.2

libaio-0.3.106 (32 bit)

libaio-devel-0.3.106

libaio-devel-0.3.106 (32 bit)

libgcc-4.1.2

libgcc-4.1.2 (32 bit)

libstdc++-4.1.2

libstdc++-4.1.2 (32 bit)

libstdc++-devel 4.1.2

make-3.81

sysstat-7.0.2

1022 rpm -qa | grep compat-

1029 rpm -qa | grep elfutils

1030 rpm -qa gcc

1031 rpm -qa gcc-c++

1032 rpm -qa glibc

1033 rpm -qa glibc-common

1034 rpm -qa glibc-devel

1035 rpm -qa libaio

1036 rpm -qa | grep libaio

1040 rpm -qa libaio-devel-0.3.106-3.2.i386.rpm

1044 rpm -qa libgcc

1048 rpm -qa sysstat

1052 rpm -qa unixODBC

1053 rpm -qa | grep unixODBC

#oracle

if [ $USER = "oracle" ] || [ $USER = "grid" ]; then

if [ $SHELL = "/bin/ksh" ]; then

ulimit -p 16384

ulimit -n 65536

else

ulimit -u 16384 -n 65536

fi

umask 022

fi

net.core.rmem_default = 262144

net.core.rmem_max = 4194304

net.core.wmem_default = 262144

fs.file-max = 6815744

net.ipv4.ip_local_port_range = 9000 65500

net.core.wmem_max = 1048576

fs.aio-max-nr = 1048576

然后运行使用之生效

/sbin/sysctl -p

1.3.3 修改 oracle 用户 shell 限制