暂无图片
Oracle--安装部署四(安装Oracle Grid Infrastructure for a New Cluster)
最近更新:2022-10-23 11:39:13

0.主机节点信息概述

  openfiler的安装指南可以参考:图形界面安装openfiler指南

openfiler.zb.com  
硬盘:/dev/sda(50G) /dev/sdb (30G) /dev/sdc(30G) /dev/sdd(30G) eth0:192.168.209.150/24 

主机一:
oracle1.zb.com 
硬盘:/dev/sda(50G) 
ens33:10.0.0.80/24 
ens37:192.168.209.128/24 
OS:CentOS 7.6 
内存:4G(如果有条件设置内存>=8G,相应的swap大小也为8G) 

主机二:oracle3.zb.com 
硬盘:/dev/sda(50G) 
ens33:10.0.0.81/24 
ens37:192.168.209.129/24 
OS:CentOS7.6 
内存:4G 

## 配置完成openfiler之后,在oracle1和oracle2上都执行如下命令 
### 1.扫描openfiler iscsi控制器 
[root@oracle1 ~]# iscsiadm -m discovery -t st -p 192.168.209.150 192.168.209.150:3260,1 iqn.2006-01.com.openfiler:tsn.50b2e856ab3d 
### 2.配置iSCSI的配置文件 
[root@oracle1 ~]# vim /etc/iscsi/iscsid.conf node.session.auth.username = iqn.2006-01.com.openfiler:tsn.50b2e856ab3d node.session.auth.password = 50b2e856ab3d 
### 3.启动服务 
[root@oracle1 ~]# systemctl enable iscsi.service 
[root@oracle1 ~]# systemctl start iscsi.service 
### 4.验证 
[root@oracle1 ~]# ll /dev/sd* 
brw-rw---- 1 root disk 8, 0 Oct 14 10:05 /dev/sda 
brw-rw---- 1 root disk 8, 1 Oct 14 10:05 /dev/sda1 
brw-rw---- 1 root disk 8, 2 Oct 14 10:05 /dev/sda2 
brw-rw---- 1 root disk 8, 16 Oct 14 13:50 /dev/sdb 
brw-rw---- 1 root disk 8, 32 Oct 14 13:50 /dev/sdc 
brw-rw---- 1 root disk 8, 48 Oct 14 13:50 /dev/sdd 
## 安装相关依赖包 
yum install -y bc binutils compat-libcap1 compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel fontconfig-devel glibc glibc-devel ksh libaio libaio-devel libX11 libXau libXi libXtst libXrender libXrender-devel libgcc libstdc++ libstdc++-devel libxcb make smartmontools sysstat cvuqdisk

  如果没有注册的DNS服务,可以搭建一个本地的DNS服务。【可以参考在Linux本地搭建DNS服务器(CentOS 7.6)

1.创建组、用户、Oracle Grid Infrastructure路径

#创建相关组 
groupadd -g 54321 oinstall # 必须 
groupadd -g 54322 dba # 必须 
groupadd -g 54323 oper 
groupadd -g 54324 backupdba 
groupadd -g 54325 dgdba 
groupadd -g 54326 kmdba 
groupadd -g 54330 racdba 
groupadd -g 54331 asmdba # 必须 
# 创建用户 
useradd -u 54321 -g oinstall -G dba,asmdba,backupdba,dgdba,kmdba,racdba,oper oracle 
echo oracle123 | passwd --stdin oracle 
useradd -u 54331 -g oinstall -G dba,asmdba,backupdba,dgdba,kmdba,racdba,oper grid 
echo grid123| passwd --stdin grid 
# 创建相关路径 
mkdir -p /u01/app/oraInventory 
chown -R oracle.oinstall /u01/app/oraInventory 
# grid home path 
mkdir -p /u01/app/19.3.0/grid 
# grid base path 
mkdir -p /u01/app/grid 
# oracle base path 
mkdir -p /u01/app/oracle 
# oracle home path 
mkdir -p /u01/app/oracle/product/19.3.0.0/dbhome_1 
chown -R grid:oinstall /u01 
chown -R oracle:oinstall /u01/app/oracle 
chmod -R 775 /u01/

2.设置用户资源限制

vim /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 32768 
grid soft nofile 1024 
grid hard nofile 65536 
grid soft nproc 2047 
grid hard nproc 16384 
grid soft stack 10240 
grid hard stack 32768

3.设置系统内核参数

vim /etc/sysctl.conf
net.ipv4.ip_local_port_range = 9000 65500
net.ipv4.tcp_rmem = 4096 87380 4194304
net.ipv4.tcp_wmem = 4096 16384 4194304
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 2684354560
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

4.关闭透明大页

echo never > /sys/kernel/mm/transparent_hugepage/enabled
# 在引导命令行中添加参数transparent_hugepage=never
[root@oracle1 ~]# vim /etc/default/grub
GRUB_TIMEOUT=5
GRUB_DISTRIBUTOR="$(sed 's, release .*$,,g' /etc/system-release)"
GRUB_DEFAULT=saved
GRUB_DISABLE_SUBMENU=true
GRUB_TERMINAL_OUTPUT="console"
GRUB_CMDLINE_LINUX="rd.lvm.lv=centos_oracle1/root rd.lvm.lv=centos_oracle1/swap rhgb quiet numa=off transparent_hugepage=never"
GRUB_DISABLE_RECOVERY="true"

# 重新生成配置文件
grub2-mkconfig -o /boot/grub2/grub.cfg

5.关闭selinux服务

setenforce 0 
vim /etc/selinux/config 
SELINUX=disabled

6.配置用户环境变量

# 查看shell类型
[root@oracle3 ~]# echo $SHELL
/bin/bash

su - oracle
vim .bash_profile
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/19.3.0.0/dbhome_1
export ORACLE_SID=orcl
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
umask 022
source .bash_profile
......