At least 4 GB of RAM for Oracle Grid Infrastructure for a standalone server including installations where you plan to install Oracle Database.
The following table describes the relationship between installed RAM and the configured swap space recommendation:
Table 6–1 Swap Space Requirement for Oracle Restart RAM Swap Space
Between 4 GB and 16 GB Equal to the size of the RAM More than 16 GB 16 GB
软件包
Packages for Oracle Linux 7and Red Hat Enterprise Linux7
The following packages (or later versions) must be installed: binutils-2.23.52.0.1-12.el7.x86_64 compat-libcap1-1.10-3.el7.x86_64 compat-libstdc++-33-3.2.3-71.el7.i686 compat-libstdc++-33-3.2.3-71.el7.x86_64 gcc-4.8.2-3.el7.x86_64 gcc-c++-4.8.2-3.el7.x86_64 glibc-2.17-36.el7.i686 glibc-2.17-36.el7.x86_64 glibc-devel-2.17-36.el7.i686 glibc-devel-2.17-36.el7.x86_64 ksh
libaio-0.3.109-9.el7.i686 libaio-0.3.109-9.el7.x86_64 libaio-devel-0.3.109-9.el7.i686 libaio-devel-0.3.109-9.el7.x86_64 libgcc-4.8.2-3.el7.i686 libgcc-4.8.2-3.el7.x86_64 libstdc++-4.8.2-3.el7.i686 libstdc++-4.8.2-3.el7.x86_64 libstdc++-devel-4.8.2-3.el7.i686 libstdc++-devel-4.8.2-3.el7.x86_64 libXi-1.7.2-1.el7.i686 libXi-1.7.2-1.el7.x86_64 libXtst-1.2.2-1.el7.i686 libXtst-1.2.2-1.el7.x86_64 make-3.82-19.el7.x86_64 sysstat-10.1.5-1.el7.x86_64
yum install -y binutils* \\ compat-libcap1* \\
compat-libstdc++*i686* \\ compat-libstdc++* \\ gcc* \\ gcc-c++* \\ glibc*i686* \\ glibc* \\
glibc-devel*i686* \\ glibc-devel* \\ ksh* \\
libaio*i686* \\ libaio* \\
libaio-devel*i686* \\ libaio-devel* \\ libgcc*i686* \\ libgcc* \\
libstdc++*686* \\ libstdc++* \\
libstdc++-devel*i686* \\ libstdc++-devel* \\ libXi*686* \\ libXi* \\
libXtst*686* \\ libXtst* \\ make* \\ sysstat* \\ unixODBC* \\
smartmontools* \\ nfs-utils*
部分语句需要perl安装包 yum install -y perl*
内核参数
cat /etc/sysctl.conf
fs.aio-max-nr = 1048576 fs.file-max = 6815744 kernel.shmall = 2097152
kernel.shmmax = 4294967295 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
sysctl -p
修改RemoveIPC参数
为了避免linux7.2的新特性,在一个user完全退出OS后会remove掉所有的IPC对象,需要修改如下参数
1).设置/etc/systemd/logind.conf中RemoveIPC=no 2).重启服务器或者重启systemd-logind 重启systemd-logind: # systemctl daemon-reload
# systemctl restart systemd-logind
配置文件系统描述符
/etc/security/limits.conf oracle soft nofile 1024 oracle hard nofile 65536 oracle soft nproc 2047 oracle hard nproc 16384 oracle soft stack 10240 oracle hard stack 10240
检查用户限制
check resource limits:
1. Log in as an installation owner.
2. Check the soft and hard limits for the file descriptor setting. Ensure that the result is in the recommended range, for example: $ ulimit -Sn 1024
$ ulimit -Hn 65536
3. Check the soft and hard limits for the number of processes available to a user. Ensure that the result is in the recommended range, for example: $ ulimit -Su 2047
$ ulimit -Hu 16384
4. Check the soft limit for the stack setting. Ensure that the result is in the recommended range, for example: $ ulimit -Ss 10240
$ ulimit -Hs 32768
用户
[root@node1 ~]# groupadd oinstall [root@node1 ~]# groupadd dba [root@node1 ~]# groupadd oper
[root@node1 ~]# groupadd asmadmin [root@node1 ~]# groupadd asmdba [root@node1 ~]# groupadd asmoper
[root@node1 ~]# useradd -g oinstall -G dba,oper,asmadmin,asmdba,asmoper oracle [root@node1 ~]# useradd -g oinstall -G dba,oper,asmadmin,asmdba,asmoper grid 注:可以指定各组和用户的gid 和id
目录
[root@node1 ~]# mkdir -p /u01/app/oracle/product/12.1/db [root@node1 ~]# mkdir -p /u01/app/grid
[root@node1 ~]# chown -R oracle:oinstall /u01
[root@node1 ~]# chown -R grid:oinstall /u01/app/grid/ [root@node1 /]# chmod -R 775 /u01
环境变量
grid
export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=/u01/app/grid export ORACLE_SID=+ASM
export PATH=$PATH:$ORACLE_HOME/bin
oracle
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2/db export ORACLE_SID=orcl
export PATH=$PATH:$ORACLE_HOME/bin
hosts
#public ip
192.168.56.25 node1 192.168.56.26 node2 #private ip
192.168.1.201 node1_priv 192.168.1.202 node2_priv #virtual ip
192.168.56.140 node1_vip 192.168.56.141 node2_vip #scan
192.168.56.102 node-scan
配置UDEV
for i in b c d e f do echo \SUBSYSTEM==\\\PROGRAM==\\\--whitelisted --replace-whitespace --device=/dev/\\$name\\\RESULT==\\\--whitelisted --replace-whitespace --device=/dev/sd$i`\\\SYMLINK+=\\\OWNER=\\\ done
KERNEL==\SUBSYSTEM==\PROGRAM==\--whitelisted --replace-whitespace --device=/dev/$name\RESULT==\SYMLINK+=\OWNER=\
KERNEL==\SUBSYSTEM==\PROGRAM==\--whitelisted --replace-whitespace --device=/dev/$name\RESULT==\SYMLINK+=\OWNER=\
KERNEL==\SUBSYSTEM==\PROGRAM==\--whitelisted --replace-whitespace --device=/dev/$name\RESULT==\SYMLINK+=\OWNER=\
使kernel重新读取磁盘信息: partprobe