RHEL8.4安装Oracle19cRACRU19.13文档.docx
《RHEL8.4安装Oracle19cRACRU19.13文档.docx》由会员分享,可在线阅读,更多相关《RHEL8.4安装Oracle19cRACRU19.13文档.docx(65页珍藏版)》请在冰豆网上搜索。
RHEL8.4安装Oracle19cRAC文档
第一部分安装规划
虚拟环境
VirtualBox6.1.28
OS版本
RHEL8.4
数据库版本
19.3.0.0.0+19.13RU
安装介质
LINUX.X64_190000_db_home.zip
LINUX.X64_190000_grid_home.zip
软件安装目录
grid:
/u01/app/19.0.0/grid
oracle:
/u01/app/oracle/product/19.0.0/db_1
用户和组
grid:
oinstall,dba
oracle:
oinstall,dba
网络规划
#publicip
192.168.211.81ora19c-rac1
192.168.211.82ora19c-rac2
#vip
192.168.211.83ora19c-rac1-vip
192.168.211.84ora19c-rac2-vip
#privateip
192.168.137.81ora19c-rac1-priv
192.168.137.82ora19c-rac2-priv
#scanip
192.168.211.85rac-scan
ASM磁盘组
DG_OCR:
2G*3
DG_DATA:
10G*2
DG_INDEX:
10G*1
DG_ARCH:
10G*1
第二分部操作系统环境配置
2.1更改IO调度为deadline,关闭numa和透明大页
[root@ora19c-rac1proc]#cat/sys/kernel/mm/transparent_hugepage/enabled
[always]madvisenever
[root@ora19c-rac1queue]#cat/sys/block/sda/queue/scheduler
noopdeadline[cfq]
(1).vi/etc/default/grub(编辑/etc/default/grub文件,在GRUB_CMDLINE_LINUX_DEFAULT
条目后面添加"elevator=deadline","transparent_hugepage=never"和”numa=off”,
执行grub2-mkconfig-o/boot/grub2/grub.cfg最后重启操作系统)
GRUB_CMDLINE_LINUX_DEFAULT="resume=/dev/rootvg/lvswapmitigations=autoelevator=deadlinetransparent_hugepage=nevernuma=offsplash=silentquietshowoptscrashkernel=183M,highcrashkernel=72M,low"
grub2-mkconfig-o/boot/grub2/grub.cfg
(2).重启操作系统使配置生效.
验证结果:
[root@ora19c-rac1~]#cat/sys/block/sda/queue/scheduler
noop[deadline]cfq
[root@ora19c-rac1~]#cat/sys/kernel/mm/transparent_hugepage/enabled
alwaysmadvise[never]
2.2使用CTSS时钟同步
/sbin/servicentpdstop
chkconfigntpdoff
mv/etc/ntp.conf/etc/ntp.conf.org
systemctlstopchronyd
systemctldisablechronyd
2.3配置/etc/hosts解析表
vi/etc/hosts添加
#publicip
192.168.211.81ora19c-rac1
192.168.211.82ora19c-rac2
#vip
192.168.211.83ora19c-rac1-vip
192.168.211.84ora19c-rac2-vip
#privateip
192.168.137.81ora19c-rac1-priv
192.168.137.82ora19c-rac2-priv
#scanip
192.168.211.85rac-scan
2.4关闭防火墙
systemctldisablefirewalld.service
systemctlstopfirewalld.service
2.5关闭selinux
vi/etc/selinux/config
SELINUX=disabled
2.6关闭NetworkManager(rhel8禁用后网卡无法正常启动)
systemctldisableNetworkManager
systemctlstopNetworkManager
2.7禁用avahi-daemon
systemctlstopavahi-daemon.socketavahi-daemon.service
systemctldisableavahi-daemon.socketavahi-daemon.service
2.8配置NOZEROCONF
vi/etc/sysconfig/network
#Createdbyanaconda
#RecommendedvalueforNOZEROCONF
NOZEROCONF=yes
2.9内核参数修改
vi/etc/sysctl.conf
#kernelconfigurationfororacle19c
fs.file-max=13631488
kernel.sem=25032000100128
kernel.shmmni=4096
kernel.shmall=2147483648
kernel.shmmax=4398046510080
kernel.panic_on_oops=1
net.core.rmem_default=262144
net.core.rmem_max=4194304
net.core.wmem_default=262144
net.core.wmem_max=1048576
net.ipv4.conf.all.rp_filter=2
net.ipv4.conf.default.rp_filter=2
fs.aio-max-nr=1048576
net.ipv4.ip_local_port_range=900065500
#使配置修改生效
sysctl-p
2.10添加用户和组
/usr/sbin/groupadd-g54321oinstall
/usr/sbin/groupadd-g54322dba
/usr/sbin/useradd-u54321-m-goinstall-Goinstall,dbagrid
/usr/sbin/useradd-u54322-m-goinstall-Goinstall,dbaoracle
echooracle|passwd--stdingrid
echooracle|passwd--stdinoracle
2.11创建软件安装目录
mkdir-p/u01/app/19.0.0/grid
mkdir-p/u01/app/grid
mkdir-p/u01/app/oracle/product/19.0.0/db_1
chown-Rgrid:
oinstall/u01
chown-Roracle:
oinstall/u01/app/oracle
chmod-R775/u01/
2.12用户环境变量配置
#为grid用户添加环境变量
vi/home/grid/.bash_profile
exportORACLE_BASE=/u01/app/grid
exportORACLE_SID=+ASM1#(节点2改为ASM2)
exportORACLE_HOME=/u01/app/19.0.0/grid
exportPATH=$ORACLE_HOME/OPatch:
$ORACLE_HOME/bin:
$PATH
exportLD_LIBRARY_PATH=$ORACLE_HOME/lib:
$LD_LIBRARY_PATH
#为oracle用户添加环境变量
vi/home/oracle/.profile
exportORACLE_BASE=/u01/app/oracle
exportORACLE_SID=racdb1#(节点2改为racdb2)
exportORACLE_HOME=$ORACLE_BASE/product/19.0.0/db_1
exportPATH=$ORACLE_HOME/OPatch:
$ORACLE_HOME/bin:
$PATH
exportLD_LIBRARY_PATH=$ORACLE_HOME/lib:
$LD_LIBRARY_PATH
2.13配置用户资源限制
vi/etc/security/limits.conf
oraclesoftnproc8192
oraclehardnproc16384
oraclesoftnofile8192
oraclehardnofile65536
oraclesoftstack10240
gridsoftnproc8192
gridhardnproc16384
gridsoftnofile8192
gridhardnofile65536
gridsoftstack10240
vi/etc/pam.d/login添加
#thisisfororacleuser
sessionrequiredpam_limits.so
2.14配置全局profile
vi/etc/profile添加
#thisisfororacleuser
if[$USER="oracle"]||[$USER="grid"];then
if[$SHELL="/bin/ksh"];then
ulimit-p16384
ulimit-n65536
else
ulimit-u16384-n65536
fi
umask022
fi
2.15安装rpm依赖包
必需rpm包:
bc
binutils
elfutils-libelf
elfutils-libelf-devel
fontconfig-devel
glibc
glibc-devel
ksh
libaio
libaio-devel
libXrender
libX11
libXau
libXi
libXtst
libgcc
libnsl
librdmacm
libstdc++
libstdc++-devel
libxcb
libibverbs
make
smartmontools
sysstat
可选rpm包:
ipmiutil(forIntelligentPlatformManagementInterface)
libnsl2(forOracleDatabaseClientonly)
libnsl2-devel(forOracleDatabaseClientonly)
libvirt-libs(forKVM)
net-tools(forOracleRACandOracleClusterware)
nfs-utils(forOracleACFS)
检查依赖包缺失情况:
rpm-qbc\
binutils\
elfutils-libelf\
elfutils-libelf-devel\
fontconfig-devel\
glibc\
glibc-devel\
ksh\
libaio\
libaio-devel\
libXrender\
libX11\
libXau\
libXi\
libXtst\
libgcc\
libnsl\
librdmacm\
libstdc++\
libstdc++-devel\
libxcb\
libibverbs\
make\
smartmontools\
sysstat
挂载镜像:
mount/dev/cdrom/mnt/
配本地置yum源
vi/etc/yum.repos.d/rhel-dvd.repo
[BaseOS]
name=BaseOS
baseurl=file:
///mnt/BaseOS
enabled=1
gpgcheck=0
gpgkey=file:
///mnt/RPM-GPG-KEY-oracle
[AppStream]
name=AppStream
baseurl=file:
///mnt/AppStream
enabled=1
gpgcheck=0
gpgkey=file:
///mnt/RPM-GPG-KEY-oracle
yumcleanall
yum-yinstallbc\
binutils\
elfutils-libelf\
elfutils-libelf-devel\
fontconfig-devel\
glibc\
glibc-devel\
ksh\
libaio\
libaio-devel\
libXrender\
libX11\
libXau\
libXi\
libXtst\
libgcc\
libnsl\
librdmacm\
libstdc++\
libstdc++-devel\
libxcb\
libibverbs\
make\
smartmontools\
sysstat
2.16共享存储配置
iscsi配置(本文档使用ISCSI作为共享存储)
iscsiadm-mdiscovery-tst-p192.168.211.80:
3260
iscsiadm-mnode-Tiqn.2021-.openfiler:
tsn.ora19c_ocr1-l
iscsiadm-mnode-Tiqn.2021-.openfiler:
tsn.ora19c_ocr2-l
iscsiadm-mnode-Tiqn.2021-.openfiler:
tsn.ora19c_ocr3-l
iscsiadm-mnode-Tiqn.2021-.openfiler:
tsn.ora19c_data1-l
iscsiadm-mnode-Tiqn.2021-.openfiler:
tsn.ora19c_data2-l
iscsiadm-mnode-Tiqn.2021-.openfiler:
tsn.ora19c_index1–l
systemctlenableiscsi.service
(1).多路径方式安装配置
yum-yinstalldevice-mapper*
systemctlenablemultipathd
--生成默认配置文件
/sbin/mpathconf–enable
vi/etc/multipath.conf修改
multipaths{
multipath{
wwid14f504e46494c45527a37307969642d594e464e2d46697765
aliasDG_OCR1
}
multipath{
wwid14f504e46494c45526968306870502d325679642d4f784579
aliasDG_OCR2
}
multipath{
wwid14f504e46494c45526b5a415037302d336178442d78384653
aliasDG_OCR3
}
multipath{
wwid14f504e46494c4552686a6a47745a2d616a77652d55356461
aliasDG_DATA1
}
multipath{
wwid14f504e46494c4552465748577a562d345a73552d63644c49
aliasDG_DATA2
}
multipath{
wwid14f504e46494c45524748614e75352d336a746d2d4a775042
aliasDG_INDEX1
}
multipath{
wwid14f504e46494c45523142394739642d533665692d67567a67
aliasDG_ARCH1
}
}
multipath-F
systemctlrestartmultipathd.service
vi/etc/udev/rules.d/99-oracle-asmdevices.rules
KERNEL=="dm-*",ENV{DM_UUID}=="mpath-14f504e46494c45527a37307969642d594e464e2d46697765",OWNER="grid",GROUP="dba",MODE="0660"
KERNEL=="dm-*",ENV{DM_UUID}=="mpath-14f504e46494c45526968306870502d325679642d4f784579",OWNER="grid",GROUP="dba",MODE="0660"
KERNEL=="dm-*",ENV{DM_UUID}=="mpath-14f504e46494c45526b5a415037302d336178442d78384653",OWNER="grid",GROUP="dba",MODE="0660"
KERNEL=="dm-*",ENV{DM_UUID}=="mpath-14f504e46494c4552686a6a47745a2d616a77652d55356461",OWNER="grid",GROUP="dba",MODE="0660"
KERNEL=="dm-*",ENV{DM_UUID}=="mpath-14f504e46494c4552465748577a562d345a73552d63644c49",OWNER="grid",GROUP="dba",MODE="0660"
KERNEL=="dm-*",ENV{DM_UUID}=="mpath-14f504e46494c45524748614e75352d336a746d2d4a775042",OWNER="grid",GROUP="dba",MODE="0660"
KERNEL=="dm-*",ENV{DM_UUID}=="mpath-14f504e46494c45523142394739642d533665692d67567a67",OWNER="grid",GROUP="dba",MODE="0660"
udevadmcontrol-R
udevadmtrigger-tdevices-sblock
配置完成后,权限检查:
[root@rhel8yum.repos.d]#ll/dev/dm*
brw-rw----.1rootdisk253,0Nov2211:
16/dev/dm-0
brw-rw----.1rootdisk253,1Nov2211:
16/dev/dm-1
brw-rw----.1rootdisk253,2Nov2211:
16/dev/dm-2
brw-rw----.1griddba253,3Nov2211:
16/dev/dm-3
brw-rw----.1griddba253,4Nov2211:
16/dev/dm-4
brw-rw-