基于OracleLinux76的Oracle19CRAC 安装部署文档.docx
《基于OracleLinux76的Oracle19CRAC 安装部署文档.docx》由会员分享,可在线阅读,更多相关《基于OracleLinux76的Oracle19CRAC 安装部署文档.docx(33页珍藏版)》请在冰豆网上搜索。
基于OracleLinux76的Oracle19CRAC安装部署文档
ORACLE19CRAC安装部署文档
作者:
Aods
时间:
2021年7月11日
本文档根据实际过程编写。
1.安装介质装备
操作安装介质:
CentOSLinuxrelease7.6.1810(Core)或OracleLinux7.6.1810
V980739-01_OLE7.6.iso
数据库安装介质:
LINUX.X64_193000_grid_home.zip
LINUX.X64_193000_db_home.zip
2.RAC规划
2.1.IP规划
服务器主机名
xjzpt01
xjzpt02
PublicIP
192.168.15.56/24
192.168.15.57/24
VirutalIP
192.168.15.57/24
192.168.15.59/24
PrivateIP
11.11.11.56/24
11.11.11.57/24
OracleSID
xjzpt1
xjzpt2
集群实例名称
xjzpt
SCANP
192.168.11.60
2.2.操作系统规划
服务器本地盘采用Raid5+Hotspare模式进行数据保护,文件系统空间划分情况如下列所示
挂载目录文件系统格式文件系统大小
/homexfs50GB
/u01xfs200GB
/varxfs100GB
/boot1024MB
/boot/efi10GB
/xfs200GB
swapswap64GB
2.3.共享磁盘规划
本项目通过FCSAN提供两台服务器共享磁盘模式,三块20GB的磁盘用于Vote和ocr磁盘,三块磁盘为Nomal,6块5TB用于存放数据,1块2TB磁盘用于flash_recovery,1块4TB磁盘用于数据归档。
3.操作系统环境准备
本次部署操作系统安装为带有GUI的图形化安装,由于安装的OracleLinux7.6版本,操作系统自行安装有Oracleasm-support软件,但需要手动安装oracleasm-lib文件。
由于是局域网安装,将操作系统ISO文件导入到tmp目录,分别在两个节点配置本地yum源,以便于后期安装缺少的文件。
在完成操作系统安装过程中,后安装完成之后,分配修改两个节点的主机名为xjzpt01和xjzpt02。
3.1.关闭操作系统虚拟网卡网桥
两个节点都需要操作:
删除LINUX7.6的虚拟网卡网桥
ifconfigvirbr0down
brctldelbrvirbr0
systemctldisablelibvirtd.service
3.2.关闭防火墙和selinux
两个节点都需要操作:
关闭防火墙:
systemctlstopfirewalld.service
systemctldisablefirewalld.service
关闭selinux:
vi/etc/selinuc/config
将enforce修改为disabled,最后分别重启服务器reboot。
3.3.操作系统必要补丁文件安装
两个节点都需要进行如下文件的安装:
yuminstall-ybinutils-
yuminstall-ybinutils-2.27-34.base.0.1.el7.x86_64.rpm
yuminstall-ycompat-libcap1
yuminstall-ygccgcc-c++
yuminstall-yglibc
yuminstall-yksh
yuminstall-ylibaio
yuminstall-ylibXext
yuminstall-ylibXi
yuminstall-yxterm
yuminstall-yunixODBC
yuminstall-yelfutils-libelf
yuminstall-yelfutils-libelf-devel
yuminstall-ylibstdc++
yuminstall-ylibstdc++-devel
yuminstall-ypython
rpm-ivhcompat-libstdc++-33-3.2.3-72.el7.x86_64.rpm
3.4.配置Host
两个节点都需要配置/etc/hosts文件,具体描述如下:
#publicIP
192.168.15.56xjzpt01
192.168.15.57xjzpt02
#privateIP
11.11.11.56xjzpt01-priv
11.11.11.57xjzpt02-priv
#virtualIP
192.168.15.58xjzpt01-vip
192.168.15.59xjzpt02-vip
#ScanIP
192.168.15.60xjzpt-scan
3.5.添加用户和组
在两个节点分别添加用户和组:
groupadd-g1001oinstall
groupadd-g1002dba
groupadd-g1003oper
groupadd-g1004backupdba
groupadd-g1005dgdba
groupadd-g1006kmdba
groupadd-g1007asmdba
groupadd-g1008asmoper
groupadd-g1009asmadmin
groupadd-g1010racdba
useradd-u10011-goinstall-Gdba,asmdba,backupdba,oper,backupdba,dgdba,kmdba,racdbaoracle
useradd-u10012-goinstall-Gasmadmin,asmdba,asmoper,dba,racdbagrid
3.6.创建软件安装目录
在两个节点分别创建软件安装目录,如下描述所示,
mkdir-p/u01/app/grid
mkdir-p/u01/app/19.0.0/grid
mkidr-p/u01/app/oraInvertory
mkdir-p/u01/app/oracle
mkdir-p/u01/app/oracle/product/19.0.0/db_1
chown-Rgrid:
oinstall/u01/app/grid
chown-Rgrid:
oinstall/u01/app/19.0.0/grid
chown-Rgrid:
oinstall/u01/app/oraInventory
chown-Roracle:
oinstall/u01/app/oracle
chmod-R775/u01
3.7.配置操作系统相关参数
下面的参数需在两个节点都进行操作。
3.7.1配置network参数
vi/etc/sysconfig/network
#Createdbyanaconda
#RecommendedvalueforNOZEROCONF
NOZEROCONF=yes
3.7.2配置limits.conf文件
vi/etc/security/limits.conf
oraclesoftnofile2047
oraclehardnofile65536
oraclesoftnproc65536
oraclehardnproc65536
oraclesoftstack65536
oraclehardstack65536
oraclesoftmemlock474919276
oraclehardmemlock474919276
gridsoftnofile65536
gridhardnofile65536
gridsoftnproc65536
gridhardnproc65536
gridsoftstack65536
gridhardstack65536
#Endoffile
3.7.3配置login文件
编辑login文件,在最后添加一行,如下描述所示:
vi/etc/pam.d/login
sessionrequired/lib64/security/pam_limits.so
3.7.4配置sysctl文件
vi/etc/sysctl.conf
kernel.shmmax=43980456111104
kernel.shmall=1073741824
kernel.shmmni=4096
kernel.sem=25032000100128
net.ipv4.ip_local_port_range=900065500
net.core.rmem_default=262144
net.core.rmem_max=4194304
net.core.wmem_default=262144
net.core.wmem_max=1048576
fs.aio-max-nr=1048576
fs.file-max=6815744
3.8.grid用户环境变量设置
3.8.1在节点1配置gird用户环境变量
vi.bash_profile
exportPATH
exportORACLE_BASE=/u01/app/grid
exportORACLE_HOME=/u01/app/19.0.0/grid
exportORACLE_SID=+ASM1
exportNLS_DATE_FORMAT="yyyy-mm-ddhh24:
mi:
ss"
exportPATH=${PATH}:
$HOME/bin:
$ORACLE_HOME/bin
exportPATH=${PATH}:
/usr/bin:
/bin:
/usr/bin/X11:
/usr/local/bin
exportPATH=${PATH}:
$ORACLE_BASE/common/oracle/bin
exportORACLE_PATH=${PATH}:
$ORACLE_BASE/common/oracle/sql:
$ORACLE_HOME/rdbms/admin
exportORACLE_TERM=xterm
exportTNS_ADMIN=$ORACLE_HOME/network/admin
exportORA_NLS10=$ORACLE_HOME/nls/data
exportLD_LIBRARY_PATH=$ORACLE_HOME/lib
exportLD_LIBRARY_PATH=${LD_LIBRARY_PATH}:
$ORACLE_HOME/oracm/lib
exportLD_LIBRARY_PATH=${LD_LIBRARY_PATH}:
/lib:
/usr/lib:
/usr/local/lib
exportCLASSPATH=$ORACLE_HOME/JRE
exportCLASSPATH=${CLASSPATH}:
$ORACLE_HOME/jlib
exportCLASSPATH=${CLASSPATH}:
$ORACLE_HOME/rdbms/jlib
exportCLASSPATH=${CLASSPATH}:
$ORACLE_HOME/network/jlib
exportTHREADS_FLAG=native
exportTEMP=/tmp
exportTMPDIR=/tmp
exportPATH=${PATH}:
$ORACLE_HOME/bin
3.8.2在节点2配置grid用户环境变量
vi.bash_profile
exportPATH
exportORACLE_BASE=/u01/app/grid
exportORACLE_HOME=/u01/app/19.0.0/grid
exportORACLE_SID=+ASM2
exportNLS_DATE_FORMAT="yyyy-mm-ddhh24:
mi:
ss"
exportPATH=${PATH}:
$HOME/bin:
$ORACLE_HOME/bin
exportPATH=${PATH}:
/usr/bin:
/bin:
/usr/bin/X11:
/usr/local/bin
exportPATH=${PATH}:
$ORACLE_BASE/common/oracle/bin
exportORACLE_PATH=${PATH}:
$ORACLE_BASE/common/oracle/sql:
$ORACLE_HOME/rdbms/admin
exportORACLE_TERM=xterm
exportTNS_ADMIN=$ORACLE_HOME/network/admin
exportORA_NLS10=$ORACLE_HOME/nls/data
exportLD_LIBRARY_PATH=$ORACLE_HOME/lib
exportLD_LIBRARY_PATH=${LD_LIBRARY_PATH}:
$ORACLE_HOME/oracm/lib
exportLD_LIBRARY_PATH=${LD_LIBRARY_PATH}:
/lib:
/usr/lib:
/usr/local/lib
exportCLASSPATH=$ORACLE_HOME/JRE
exportCLASSPATH=${CLASSPATH}:
$ORACLE_HOME/jlib
exportCLASSPATH=${CLASSPATH}:
$ORACLE_HOME/rdbms/jlib
exportCLASSPATH=${CLASSPATH}:
$ORACLE_HOME/network/jlib
exportTHREADS_FLAG=native
exportTEMP=/tmp
exportTMPDIR=/tmp
exportPATH=${PATH}:
$ORACLE_HOME/bin
3.9Oracle环境变量设置
3.9.1在节点1配置oracle用户环境变量
vi.bash_profile
exportPATH
exportORACLE_BASE=/u01/app/oracle
exportORACLE_HOME=$ORACLE_BASE/product/19.0.0
exportORACLE_SID=xjzpt1
exportORACLE_UNQNAME=$ORACLE_SID
exportNLS_DATE_FORMAT="yyyy-mm-ddhh24:
mi:
ss"
exportPATH=${PATH}:
$HOME/bin:
$ORACLE_HOME/bin
exportPATH=${PATH}:
/usr/bin:
/bin:
/usr/bin/X11:
/usr/local/bin
exportPATH=${PATH}:
$ORACLE_BASE/common/oracle/bin
exportORACLE_PATH=${PATH}:
$ORACLE_BASE/common/oracle/sql:
$ORACLE_HOME/rdbms/admin
exportORACLE_TERM=xterm
exportTNS_ADMIN=$ORACLE_HOME/network/admin
exportLD_LIBRARY_PATH=$ORACLE_HOME/lib
exportLD_LIBRARY_PATH=${LD_LIBRARY_PATH}:
$ORACLE_HOME/oracm/lib
exportLD_LIBRARY_PATH=${LD_LIBRARY_PATH}:
/lib:
/usr/lib:
/usr/local/lib:
$ORACLE_HOME/lib64
exportCLASSPATH=$ORACLE_HOME/JRE
exportCLASSPATH=${CLASSPATH}:
$ORACLE_HOME/jlib
exportCLASSPATH=${CLASSPATH}:
$ORACLE_HOME/rdbms/jlib
exportCLASSPATH=${CLASSPATH}:
$ORACLE_HOME/network/jlib
exportTHREADS_FLAG=native
exportTEMP=/tmp
exportTMPDIR=/tmp
exportPATH=${PATH}:
$ORACLE_HOME/bin
3.9.2在节点2配置Oracle环境变量
vi.bash_profile
exportPATH
exportORACLE_BASE=/u01/app/oracle
exportORACLE_HOME=$ORACLE_BASE/product/19.0.0
exportORACLE_SID=xjzpt2
exportORACLE_UNQNAME=$ORACLE_SID
exportNLS_DATE_FORMAT="yyyy-mm-ddhh24:
mi:
ss"
exportPATH=${PATH}:
$HOME/bin:
$ORACLE_HOME/bin
exportPATH=${PATH}:
/usr/bin:
/bin:
/usr/bin/X11:
/usr/local/bin
exportPATH=${PATH}:
$ORACLE_BASE/common/oracle/bin
exportORACLE_PATH=${PATH}:
$ORACLE_BASE/common/oracle/sql:
$ORACLE_HOME/rdbms/admin
exportORACLE_TERM=xterm
exportTNS_ADMIN=$ORACLE_HOME/network/admin
exportLD_LIBRARY_PATH=$ORACLE_HOME/lib
exportLD_LIBRARY_PATH=${LD_LIBRARY_PATH}:
$ORACLE_HOME/oracm/lib
exportLD_LIBRARY_PATH=${LD_LIBRARY_PATH}:
/lib:
/usr/lib:
/usr/local/lib:
$ORACLE_HOME/lib64
exportCLASSPATH=$ORACLE_HOME/JRE
exportCLASSPATH=${CLASSPATH}:
$ORACLE_HOME/jlib
exportCLASSPATH=${CLASSPATH}:
$ORACLE_HOME/rdbms/jlib
exportCLASSPATH=${CLASSPATH}:
$ORACLE_HOME/network/jlib
exportTHREADS_FLAG=native
exportTEMP=/tmp
exportTMPDIR=/tmp
exportPATH=${PATH}:
$ORACLE_HOME/bin
3.10多路径软件
具体配置/etc/multipath.conf文件如下描述:
defaults{
user_friendly_namesyes
}
blacklist{
devnode"^(ram|raw|loop|fd|md|dm-|sr|scd|st)[0-9]*"
devnode"^hd[a-z]"
}
blacklist_exceptions{
wwid"36806933100864ea620b8232200000010"
wwid"36806933100864ea620b7c6a40000000e"
wwid"36806933100864ea620b812f10000000f"
wwid"36806933100864ea620b884f200000014"
wwid"36806933100864ea620b874a400000013"
wwid"36806933100864ea620b8be7f00000016"
wwid"36806933100864ea620b85e2300000012"
wwid"36806933100864ea620b849a900000011"
wwid"36806933100864ea620b8ab8400000015"
wwid"36806933100864ea620b8eb7d00000018"
wwid"36806933100864ea620b8d7bb00000017"
}
multipaths{
multipath{
wwid"36806933100864ea620b8232200000010"
aliasmpathocr01
path_grouping_policymultibus
path_selector"round-robin0"
failbackimmediate
}
multipath{
wwid"36806933100864ea620b7c6a40000000e"
aliasmpathocr02
path_grouping_policymultibus
path_selector"round-robin0"
failbackimmediate
}
multipath{
wwid"36806933100864ea620b812f10000000f"
aliasmpathocr03
path_grouping_policymultibus
path_selector"round-robin0"
failbackimmediate
}
multipath{
wwid"36806933100864ea620b884f200000014"
aliasmpathdata01
path_grouping_policymultibus
path_selector"round-robin0"
failbackimmediate
}
multipath{
wwid"36806933100864ea620b8be7f00000016"
aliasmpathdata02
path_grouping_policymultibus
path_selector"round-robin0"
failbackimmediate
}
multipath{
wwid"36806933100864ea620b874a400000013"