RHEL8.4安装Oracle19cRACRU19.13文档.docx

资源描述

RHEL8.4安装Oracle19cRACRU19.13文档.docx

《RHEL8.4安装Oracle19cRACRU19.13文档.docx》由会员分享，可在线阅读，更多相关《RHEL8.4安装Oracle19cRACRU19.13文档.docx（65页珍藏版）》请在冰豆网上搜索。

RHEL8.4安装Oracle19cRACRU19.13文档.docx

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

umask022

2.15安装rpm依赖包

必需rpm包：

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