Oracle 19c Rac环境部署
前言
搭建Oracle 19c Rac环境部署，使用dns进行解析。
一、软件包
linuxx64_193000_grid_home.zip
linuxx64_193000_db_home.zip
二、配置信息
1.IP地址规划
编辑/etc/hosts
#public ip
10.1.50.213 kezcc1 kezcc1.zcc.com
10.1.50.214 kezcc2 kezcc2.zcc.com
#vip ip
10.1.50.215 kezcc1-vip kezcc1-vip.zcc.com
10.1.50.216 kezcc2-vip kezcc2-vip.zcc.com
#priv ip
10.10.10.213 kezcc1-priv kezcc1-priv.zcc.com
10.10.10.214 kezcc2-priv kezcc2-priv.zcc.com
#scan ip
10.1.50.217 kezcc-scan kezcc-scan.zcc.com
10.1.50.218 kezcc-scan kezcc-scan.zcc.com
10.1.50.219 kezcc-scan kezcc-scan.zcc.com
2.配置dns服务端
一般情况下都是采用windows server作为dns服务器
2.1 安装dns服务
管理》添加角色和功能
2.2 管理工具》dns
正向查找区域》新建
反向查找区域》新建
2.3 添加解析ip和地址
根据hosts对应的名称进行添加
3、配置DNS客户端
3.1 配置/etc/hosts文件
在主机名称后面加上域名
3.2 配置/etc/resolv.conf
search zcc.com zccdns.zcc.com localdomain
nameserver 10.1.50.212
options timeout:2
options attempts:5
3.3 配置解析顺序/etc/host.conf
orderbind,hosts
multion
3.4 配置网卡上的DNS
PEERDNS=NO
DNS1=10.1.50.212
3.5 停止NetworkManager影响
systemctl stop NetworkManager.service
systemctl disable NetworkManager.service
systemctl status NetworkManager.service
3.6 测试nslookup
systemctl restart network
nslookup
3.7 检查两个网卡配置信息
ONBOOT=yes
三、Linux操作系统的配置及参数修改
1、准备文件系统
pvcreate /dev/sdb /dev/sdc
vgcreate softvg /dev/sdb
vgcreate oravg /dev/sdc
lvcreate -n softlv -L 30000M softvg
lvcreate -n oralv -L 50000M oravg
mkfs.xfs /dev/softvg/softlv
mkfs.xfs /dev/oravg/oralv
vi /etc/fstab
/dev/oravg/oralv /oracle xfs defaults 0 0
/dev/softvg/softlv /soft xfs defaults 0 0
mkdir /oracle
mkdir /soft
mount /oracle
mount /soft
/oracle #存放集群安装的目录
/soft #存放软件的目录
2、创建用户、组、目录
/usr/sbin/groupadd -g 60001 oinstall
/usr/sbin/groupadd -g 60002 dba
/usr/sbin/groupadd -g 60003 oper
/usr/sbin/groupadd -g 60004 backupdba
/usr/sbin/groupadd -g 60005 dgdba
/usr/sbin/groupadd -g 60006 kmdba
/usr/sbin/groupadd -g 60007 asmdba
/usr/sbin/groupadd -g 60008 asmoper
/usr/sbin/groupadd -g 60009 asmadmin
/usr/sbin/groupadd -g 60010 racdba
useradd -u 61001 -g oinstall -G dba,asmdba,backupdba,dgdba,kmdba,racdba,oper oracle
useradd -u 61002 -g oinstall -G asmadmin,asmdba,asmoper,dba grid
id oracle
id grid
passwd oracle
passwd grid
mkdir -p /oracle/app/grid
mkdir -p /oracle/app/19.3/grid
chown -R grid:oinstall /oracle
mkdir -p /oracle/app/oracle
chown -R oracle:oinstall /oracle/app/oracle
mkdir -p /oracle/app/oraInventory
chown -R grid:oinstall /oracle/app/oraInventory
chmod -R 775 /oracle
3、安装相关软件包
#配置yum源
mount /dev/cdrom /mnt
cd /etc/yum.repos.d
mkdir bk
mv public-yum-ol7.repo bk/
vi dvd.repo
[EL]
name=Linux7.3DVD
baseurl=file:///mnt
gpgcheck=0
enabled=1
yum clean all
yum makecache
yum -y install autoconf
yum -y install automake
yum -y install binutils
yum -y install binutils-devel
yum -y install bison
yum -y install cpp
yum -y install dos2unix
yum -y install ftp
yum -y install gcc
yum -y install gcc-c++
yum -y install lrzsz
yum -y install python-devel
yum -y install compat-db*
yum -y install compat-gcc-34
yum -y install compat-gcc-34-c++
yum -y install compat-libcap1
yum -y install compat-libstdc++-33
yum -y install compat-libstdc++-33.i686
yum -y install glibc-*
yum -y install glibc-*.i686
yum -y install libXpm-*.i686
yum -y install libXp.so.6
yum -y install libXt.so.6
yum -y install libXtst.so.6
yum -y install libXext
yum -y install libXext.i686
yum -y install libXtst
yum -y install libXtst.i686
yum -y install libX11
yum -y install libX11.i686
yum -y install libXau
yum -y install libXau.i686
yum -y install libxcb
yum -y install libxcb.i686
yum -y install libXi
yum -y install libXi.i686
yum -y install libgcc_s.so.1
yum -y install libstdc++.i686
yum -y install libstdc++-devel
yum -y install libstdc++-devel.i686
yum -y install libaio
yum -y install libaio.i686
yum -y install libaio-devel
yum -y install libaio-devel.i686
yum -y install ksh
yum -y install libXp
yum -y install libaio-devel
yum -y install numactl
yum -y install numactl-devel
yum -y install make-y
yum -y install sysstat-y
yum -y install unixODBC
yum -y install unixODBC-devel
yum -y install elfutils-libelf-devel-0.97
yum -y install elfutils-libelf-devel
yum -y install redhat-lsb-core
yum -y install *vnc*
4、修改系统相关参数
4.1 修改资源限制参数
vi /etc/security/limits.conf
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft nproc 16384
oracle hard nproc 16384
oracle soft stack 10240
oracle hard stack 32768
grid soft nofile 1024
grid hard nofile 65536
grid soft nproc 16384
grid hard nproc 16384
grid soft stack 10240
grid hard stack 32768
#Oracle recommended value for memlock is set to 3145728 for user oracle
oracle hard memlock 576716800
#Oracle recommended value for memlock is set to 3145728 for user oracle
oracle soft memlock 576716800
ulimit -a
vi /etc/security/limits.d/90-nproc.conf
* - nproc 16384
vi /etc/pam.d/login
session required pam_limits.so
4.2 修改内核参数
vi /etc/sysctl.conf
fs.file-max = 6815744
kernel.sem = 250 32000 100 128
kernel.shmmni = 4096
kernel.shmall = 4194304
kernel.shmmax = 17179869184
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 = 9000 65500
vm.nr_hugepages=2500
hugepages大页，内存超过8G就需要使用，计算方法：SGA/2M
kernel.shmmax设置为物理内存的75%，kernel.shmall为kernel.shmmax/4096，可以通过下面参数计算
MEMORY=`cat /proc/meminfo | grep MemTotal | awk '{print $2}'`
SHMMAX=`expr $MEMORY \* 1024 \* 3 / 4`
SHMALL=`expr $MEMORY \* 1024 / 4 / 1024`
使内核参数生效
sysctl -p 或者 /sbin/sysctl --system
关闭透明页
vi /etc/rc.local
if test -f /sys/kernel/mm/transparent_hugepage/enabled; then
echo never > /sys/kernel/mm/transparent_hugepage/enabled
fi
if test -f /sys/kernel/mm/transparent_hugepage/defrag; then
echo never > /sys/kernel/mm/transparent_hugepage/defrag
fi
chmod +x /etc/rc.d/rc.local
4.3 配置安全
#关闭防火墙
systemctl status firewalld.service
systemctl stop firewalld.service
systemctl disable firewalld.service
#关闭selinux
vi/etc/selinux/config
SELINUX=disabled
或者
sed -i "s/SELINUX=enforcing/SELINUX=disabled/g" /etc/selinux/config
setenforce 0
4.4 关闭NTP服务
systemctl stop ntpd.service
systemctl disable ntpd.service
systemctl status ntpd.service
mv /etc/ntp.conf /etc/ntp.conf.bak
rm /var/run/ntpd.pid
4.5 配置NOZEROCONF
vi /etc/sysconfig/network
NOZEROCONF=yes
4.6 修改nsswitch.conf
vi /etc/nsswitch.conf
host:files dns myhostname nis
4.7 关闭avahi-daemon和avahi-dnsconfd
systemctl stop avahi-daemon
systemctl disable avahi-daemon
systemctl stop avahi-dnsconfd
systemctl disable avahi-dnsconfd
4.8 关闭chrondy服务
systemctl stop chronyd
systemctl disable chronyd
cp /etc/chrony.conf /etc/chrony.conf.bak
rm -rf /etc/chrony.conf
4.9 添加shm
vim /etc/fstab
tmpfs /dev/shm tmpfs defaults,size=16G 0 0
mount -o remount /dev/shm
size大小设置跟PGA最大值一致或者更高
5、配置用户环境变量
节点1:
su - grid
PS1="[`whoami`@`hostname`:"'$PWD]$'
export PS1
umask022
#aliassqlplus="rlwrap sqlplus"
export TMP=/tmp
export LANG=en_US
export TMPDIR=$TMP
ORACLE_SID=+ASM1; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
ORACLE_BASE=/oracle/app/grid; export ORACLE_BASE
ORACLE_HOME=/oracle/app/19.3/grid; export ORACLE_HOME
NLS_DATE_FORMAT="yyyy-mm-ddHH24:MI:SS"; export NLS_DATE_FORMAT
PATH=$PATH:$HOME/.local/bin:$HOME/bin:$ORACLE_HOME/bin; export PATH
THREADS_FLAG=native; export THREADS_FLAG
if[$USER="oracle"]||[$USER="grid"];then
if[$SHELL="/bin/ksh"];then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
umask 022
fi
su - oracle
PS1="[`whoami`@`hostname`:"'$PWD]$'
#alias sqlplus="rlwrap sqlplus"
#alias rman="rlwrap rman"
expor tPS1
export TMP=/tmp
export LANG=en_US
export TMPDIR=$TMP
export ORACLE_HOSTNAME=kezcc1
export ORACLE_UNQNAME=kezcc
ORACLE_SID=kezcc1; export ORACLE_SID
ORACLE_BASE=/oracle/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/19.3/db_1; export ORACLE_HOME
ORACLE_TERM=xterm; export ORACLE_TERM
NLS_DATE_FORMAT="yyyy-mm-ddHH24:MI:SS"; export NLS_DATE_FORMAT
NLS_LANG=AMERICAN_AMERICA.ZHS16GBK; export NLS_LANG
PATH=.:$PATH:$HOME/.local/bin:$HOME/bin:$ORACLE_BASE/product/19.3/db_1/bin:$ORACLE_HOME/bin; export PATH
THREADS_FLAG=native; export THREADS_FLAG
if[$USER="oracle"]||[$USER="grid"];then
if[$SHELL="/bin/ksh"];then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
umask 022
fi
su - root
vi .bash_profile
export PATH=/oracle/app/12.2/grid/bin:$PATH
节点2：
su - grid
PS1="[`whoami`@`hostname`:"'$PWD]$'
export PS1
umask022
#aliassqlplus="rlwrap sqlplus"
export TMP=/tmp
export LANG=en_US
export TMPDIR=$TMP
ORACLE_SID=+ASM2; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
ORACLE_BASE=/oracle/app/grid; export ORACLE_BASE
ORACLE_HOME=/oracle/app/19.3/grid; export ORACLE_HOME
NLS_DATE_FORMAT="yyyy-mm-ddHH24:MI:SS"; export NLS_DATE_FORMAT
PATH=$PATH:$HOME/.local/bin:$HOME/bin:$ORACLE_HOME/bin; export PATH
THREADS_FLAG=native; export THREADS_FLAG
if[$USER="oracle"]||[$USER="grid"];then
if[$SHELL="/bin/ksh"];then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
umask 022
fi
su - oracle
PS1="[`whoami`@`hostname`:"'$PWD]$'
#alias sqlplus="rlwrap sqlplus"
#alias rman="rlwrap rman"
expor tPS1
export TMP=/tmp
export LANG=en_US
export TMPDIR=$TMP
export ORACLE_HOSTNAME=kezcc2
export ORACLE_UNQNAME=kezcc
ORACLE_SID=kezcc2; export ORACLE_SID
ORACLE_BASE=/oracle/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/19.3/db_1; export ORACLE_HOME
ORACLE_TERM=xterm; export ORACLE_TERM
NLS_DATE_FORMAT="yyyy-mm-ddHH24:MI:SS"; export NLS_DATE_FORMAT
NLS_LANG=AMERICAN_AMERICA.ZHS16GBK; export NLS_LANG
PATH=.:$PATH:$HOME/.local/bin:$HOME/bin:$ORACLE_BASE/product/19.3/db_1/bin:$ORACLE_HOME/bin; export PATH
THREADS_FLAG=native; export THREADS_FLAG
if[$USER="oracle"]||[$USER="grid"];then
if[$SHELL="/bin/ksh"];then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
umask 022
fi
su - root
vi ~/.bash_profile
export PATH=/oracle/app/19.3/grid/bin:$PATH
四、配置共享存储及ASM磁盘
查看磁盘的uuid
for i in b c d e
do
echo "sd$i" "`/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/sd$i`";
done
1、配置multipath
mpathconf --enable
systemctl restart multipathd.service
multipath -ll
vi /etc/multipath.conf
blacklist {
devnode "^(ram|raw|loop|fd|md|dm-|sr|scd|st)[0-9]*"
devnode "^hd[a-z][[0-9]*]"
devnode "^cciss!c[0-9]d[0-9]*"
devnode "^sda[0-9]"
}
multipaths {
multipath {
wwid 14f504e46494c4552444143376e542d7a6f67332d49303855
alias file_data
}
multipath {
wwid 14f504e46494c4552316868436c592d695345312d43333778
alias file_ocr
}
multipath {
wwid 14f504e46494c455278504a486f6d2d564d324a2d54676d36
alias file_arch
}
multipath {
wwid 14f504e46494c45526630673473412d577049592d33377372
alias file_mgmt
}
}
重启生效
systemctl restart multipathd.service
multipath -ll
2、编写udev rules文件，生成文件内容的脚本：
for i in b c d e;
do
echo "KERNEL==\"sd?\",SUBSYSTEM==\"BLOCK\",PROGRAM==\"/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/\$name\",RESULT==\"`/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/sd$i`\",SYMLINK+=\"asm-disk$i\",OWNER=\"grid\",GROUP=\"asmadmin\",MODE=\"0660\""
done
将生成的内容保存在 99-oracle-asmdevices.rules 文件中。
重启 udev 设备
/sbin/udevadm trigger --type=devices --action=change
检查 udev设备
ls -lsa /dev/asm*
ls -lsa /dev/sd*
五、部署安装
1、准备文件
上传文件LINUX.X64_193000_db_home.zip LINUX.X64_193000_grid_home.zip
[root@kezcc1 u01]#chown grid.asmadmin LINUX.X64_193000_grid_home.zip
[root@kezcc1 u01]#mv LINUX.X64_193000_grid_home.zip /u01/app/19/grid
[root@kezcc1 u01]#su - grid
[grid@kezcc1 grid]$cd $ORACLE_HOME
[grid@kezcc1 grid]$ll
total 2821472
-rw-r--r--. 1 grid asmadmin 2889184573 Mar 30 2022 LINUX.X64_193000_grid_home.zip
[grid@kezcc1 grid]$ unzip LINUX.X64_193000_grid_home.zip
安装CVUDISK
[root@kezcc1 ~]# rpm -ivh /u01/app/19/grid/cv/rpm/cvuqdisk-1.0.10-1.rpm
Preparing... ################################# [100%]
Using default group oinstall to install package
Updating / installing...
1:cvuqdisk-1.0.10-1 ################################# [100%]
[root@kezcc1 ~]# scp /u01/app/19/grid/cv/rpm/cvuqdisk-1.0.10-1.rpm [email protected]:/root/
The authenticity of host '10.1.50.214 (10.1.50.214)' can't be established.
ECDSA key fingerprint is SHA256:4981la1ZpKQnst3bdHrXfbankjkHvCVMq8rO8i6luzI.
ECDSA key fingerprint is MD5:01:47:04:ad:b5:56:f9:11:15:8d:23:7c:7b:ad:ce:7b.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added '10.1.50.214' (ECDSA) to the list of known hosts.
[email protected]'s password:
cvuqdisk-1.0.10-1.rpm
[root@kezcc2 ~]# rpm -ivh cvuqdisk-1.0.10-1.rpm
Preparing... ################################# [100%]
Using default group oinstall to install package
Updating / installing...
1:cvuqdisk-1.0.10-1 ################################# [100%]
配置互信(方法：使用sshUserSetup.sh快速创建互信)
下面两条命令在一个节点上执行即可（可以在root用户下执行）：
[root@XAG01 scripts]# pwd
/u01/app/12.2.0/grid/oui/prov/resources/scripts
root@XAG01 scripts]# ./sshUserSetup.sh -user grid -hosts "kezcc1 kezcc2" -advanced -exverify –confirm
root@XAG01 scripts]# ./sshUserSetup.sh -user oracle -hosts "kezcc1 kezcc2" -advanced -exverify -confirm
2、验证
[grid@kezcc1 grid]$ ./runcluvfy.sh stage -pre crsinst -n kezcc1,kezcc2 -fixup -verbose
3、Grid安装
[grid@kezcc1 grid]./gridSetup.sh
cluster Name不能超过15个字符
1.、2节点root账号下分别依次执行
[root@kezcc1 ~]# /u01/app/oraInventory/orainstRoot.sh
Changing permissions of /u01/app/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.
Changing groupname of /u01/app/oraInventory to oinstall.
The execution of the script is complete.
[root@kezcc2 ~]# /u01/app/oraInventory/orainstRoot.sh
Changing permissions of /u01/app/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.
Changing groupname of /u01/app/oraInventory to oinstall.
The execution of the script is complete.
[root@kezcc1 ~]# /u01/app/19/grid/root.sh
Performing root user operation.
The following environment variables are set as:
ORACLE_OWNER= grid
ORACLE_HOME= /u01/app/19/grid
Enter the full pathname of the local bin directory: [/usr/local/bin]:
Copying dbhome to /usr/local/bin ...
Copying oraenv to /usr/local/bin ...
Copying coraenv to /usr/local/bin ...
Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Relinking oracle with rac_on option
Using configuration parameter file: /u01/app/19/grid/crs/install/crsconfig_params
The log of current session can be found at:
/u01/app/grid/crsdata/kezcc1/crsconfig/rootcrs_kezcc1_2024-07-15_11-34-09AM.log
2024/07/15 11:34:40 CLSRSC-594: Executing installation step 1 of 19: 'SetupTFA'.
2024/07/15 11:34:40 CLSRSC-594: Executing installation step 2 of 19: 'ValidateEnv'.
2024/07/15 11:34:40 CLSRSC-363: User ignored prerequisites during installation
2024/07/15 11:34:40 CLSRSC-594: Executing installation step 3 of 19: 'CheckFirstNode'.
2024/07/15 11:34:43 CLSRSC-594: Executing installation step 4 of 19: 'GenSiteGUIDs'.
2024/07/15 11:34:45 CLSRSC-594: Executing installation step 5 of 19: 'SetupOSD'.
2024/07/15 11:34:45 CLSRSC-594: Executing installation step 6 of 19: 'CheckCRSConfig'.
2024/07/15 11:34:45 CLSRSC-594: Executing installation step 7 of 19: 'SetupLocalGPNP'.
2024/07/15 11:35:12 CLSRSC-594: Executing installation step 8 of 19: 'CreateRootCert'.
2024/07/15 11:35:14 CLSRSC-4002: Successfully installed Oracle Trace File Analyzer (TFA) Collector.
2024/07/15 11:35:20 CLSRSC-594: Executing installation step 9 of 19: 'ConfigOLR'.
2024/07/15 11:35:41 CLSRSC-594: Executing installation step 10 of 19: 'ConfigCHMOS'.
2024/07/15 11:35:42 CLSRSC-594: Executing installation step 11 of 19: 'CreateOHASD'.
2024/07/15 11:35:51 CLSRSC-594: Executing installation step 12 of 19: 'ConfigOHASD'.
2024/07/15 11:35:52 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.service'
2024/07/15 11:37:02 CLSRSC-594: Executing installation step 13 of 19: 'InstallAFD'.
2024/07/15 11:37:13 CLSRSC-594: Executing installation step 14 of 19: 'InstallACFS'.
2024/07/15 11:38:46 CLSRSC-594: Executing installation step 15 of 19: 'InstallKA'.
2024/07/15 11:38:56 CLSRSC-594: Executing installation step 16 of 19: 'InitConfig'.
ASM has been created and started successfully.
[DBT-30001] Disk groups created successfully. Check /u01/app/grid/cfgtoollogs/asmca/asmca-240715AM113933.log for details.
2024/07/15 11:41:35 CLSRSC-482: Running command: '/u01/app/19/grid/bin/ocrconfig -upgrade grid oinstall'
CRS-4256: Updating the profile
Successful addition of voting disk 6d76289fd9454f10bff99f27e22b25a9.
Successfully replaced voting disk group with +OCR.
CRS-4256: Updating the profile
CRS-4266: Voting file(s) successfully replaced
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE 6d76289fd9454f10bff99f27e22b25a9 (/dev/mapper/file_ocr) [OCR]
Located 1 voting disk(s).
2024/07/15 11:43:39 CLSRSC-594: Executing installation step 17 of 19: 'StartCluster'.
2024/07/15 11:44:53 CLSRSC-343: Successfully started Oracle Clusterware stack
2024/07/15 11:44:53 CLSRSC-594: Executing installation step 18 of 19: 'ConfigNode'.
2024/07/15 11:47:19 CLSRSC-594: Executing installation step 19 of 19: 'PostConfig'.
[INFO] [DBT-30001] Disk groups created successfully. Check /u01/app/grid/cfgtoollogs/asmca/asmca-240715AM114724.log for details.
2024/07/15 11:49:37 CLSRSC-325: Configure Oracle Grid Infrastructure for a Cluster ... succeeded
[root@kezcc2 ~]# /u01/app/oraInventory/orainstRoot.sh
Changing permissions of /u01/app/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.
Changing groupname of /u01/app/oraInventory to oinstall.
The execution of the script is complete.
[root@kezcc2 ~]# /u01/app/19/grid/root.sh
Performing root user operation.
The following environment variables are set as:
ORACLE_OWNER= grid
ORACLE_HOME= /u01/app/19/grid
Enter the full pathname of the local bin directory: [/usr/local/bin]:
Copying dbhome to /usr/local/bin ...
Copying oraenv to /usr/local/bin ...
Copying coraenv to /usr/local/bin ...
Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Relinking oracle with rac_on option
Using configuration parameter file: /u01/app/19/grid/crs/install/crsconfig_params
The log of current session can be found at:
/u01/app/grid/crsdata/kezcc2/crsconfig/rootcrs_kezcc2_2024-07-15_11-50-06AM.log
2024/07/15 11:50:34 CLSRSC-594: Executing installation step 1 of 19: 'SetupTFA'.
2024/07/15 11:50:34 CLSRSC-594: Executing installation step 2 of 19: 'ValidateEnv'.
2024/07/15 11:50:35 CLSRSC-363: User ignored prerequisites during installation
2024/07/15 11:50:35 CLSRSC-594: Executing installation step 3 of 19: 'CheckFirstNode'.
2024/07/15 11:50:37 CLSRSC-594: Executing installation step 4 of 19: 'GenSiteGUIDs'.
2024/07/15 11:50:37 CLSRSC-594: Executing installation step 5 of 19: 'SetupOSD'.
2024/07/15 11:50:37 CLSRSC-594: Executing installation step 6 of 19: 'CheckCRSConfig'.
2024/07/15 11:50:38 CLSRSC-594: Executing installation step 7 of 19: 'SetupLocalGPNP'.
2024/07/15 11:50:40 CLSRSC-594: Executing installation step 8 of 19: 'CreateRootCert'.
2024/07/15 11:50:40 CLSRSC-594: Executing installation step 9 of 19: 'ConfigOLR'.
2024/07/15 11:50:51 CLSRSC-594: Executing installation step 10 of 19: 'ConfigCHMOS'.
2024/07/15 11:50:51 CLSRSC-594: Executing installation step 11 of 19: 'CreateOHASD'.
2024/07/15 11:50:53 CLSRSC-594: Executing installation step 12 of 19: 'ConfigOHASD'.
2024/07/15 11:50:53 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.service'
2024/07/15 11:51:08 CLSRSC-4002: Successfully installed Oracle Trace File Analyzer (TFA) Collector.
2024/07/15 11:51:58 CLSRSC-594: Executing installation step 13 of 19: 'InstallAFD'.
2024/07/15 11:52:00 CLSRSC-594: Executing installation step 14 of 19: 'InstallACFS'.
2024/07/15 11:53:25 CLSRSC-594: Executing installation step 15 of 19: 'InstallKA'.
2024/07/15 11:53:27 CLSRSC-594: Executing installation step 16 of 19: 'InitConfig'.
2024/07/15 11:53:39 CLSRSC-594: Executing installation step 17 of 19: 'StartCluster'.
2024/07/15 11:54:36 CLSRSC-343: Successfully started Oracle Clusterware stack
2024/07/15 11:54:36 CLSRSC-594: Executing installation step 18 of 19: 'ConfigNode'.
2024/07/15 11:55:03 CLSRSC-594: Executing installation step 19 of 19: 'PostConfig'.
2024/07/15 11:55:13 CLSRSC-325: Configure Oracle Grid Infrastructure for a Cluster ... succeeded
执行均成功后，点击OK，程序继续运行
4、配置ASM磁盘组
[grid@kezcc1 grid]$ asmca
5、安装oracle数据库软件
[root@kezcc1 ~]# chown oracle.oinstall LINUX.X64_193000_db_home.zip
[root@kezcc1 ~]# mv LINUX.X64_193000_db_home.zip /tmp
[root@kezcc1 ~]# su - oracle
Last login: Fri Jul 12 17:21:02 CST 2024 on pts/2
[oracle@kezcc1 ~]$ mv /tmp/LINUX.X64_193000_db_home.zip $ORACLE_HOME
[oracle@kezcc1 ~]$ cd $ORACLE_HOME
[oracle@kezcc1 db_1]$ unzip LINUX.X64_193000_db_home.zip
[oracle@kezcc1 db_1]$ ./runInstaller
两个节点root用户下运行脚本
[root@kezcc1 ~]# /u01/app/oracle/product/19/db_1/root.sh
Performing root user operation.
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/oracle/product/19/db_1
Enter the full pathname of the local bin directory: [/usr/local/bin]:
The contents of "dbhome" have not changed. No need to overwrite.
The contents of "oraenv" have not changed. No need to overwrite.
The contents of "coraenv" have not changed. No need to overwrite.
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
[root@kezcc2 ~]# /u01/app/oracle/product/19/db_1/root.sh
Performing root user operation.
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/oracle/product/19/db_1
Enter the full pathname of the local bin directory: [/usr/local/bin]:
The contents of "dbhome" have not changed. No need to overwrite.
The contents of "oraenv" have not changed. No need to overwrite.
The contents of "coraenv" have not changed. No need to overwrite.
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
6、安装数据库
dbca
prcoess一般生产环境设置3000
在生产环境中，点击Customize Storage Locatons进行配置：
#Control Files
Maximum Datafiles: 8192
#Tablespaces
USERS 5G
其余20G 关闭自动扩展
Redo Log Groups
10组 512M
7、修改rman参数
[oracle@node1 admin]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Sat Jul 20 09:59:14 2024
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: KEZCC (DBID=461961208)
RMAN> show all;
RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+data/snapcf_kezcc.f';
六、配置RAC环境下的归档和闪回
1、启动
首先要关闭另一个实例
alter system set db_recovery_file_dest_size=1G scope=both;
alter systen set db_recovery_file_dest='+dgrecovery' scope=both;
alter system set cluster_database=false scope=spfile;
shutdown immediate;
startup mount;
alter database archivelog;
alter database flashback on; --如果需要开闪回，就多执行本条命令，没必要就不要开
alter system set cluster_database=true scope=spfile;
shutdown immediate;
startup mount;
archive log list;
alter system switch logfile;
打开另外一个实例
2、关闭
首先关闭另一个实例
lter system set cluster_database=false scope=spfile;
shutdown immediate;
startup mount;
alter database flashback off;
alter database noarchivelog;
alter system set cluster_database=true scope=spfile;
shutdown immediate;
startup mount;
archive log list;
打开另一个实例
七、集群测试（负载均衡、故障切换）
1、测试环境
win client
oracle client 32/64bit
plsql 32/64bit
2、负载均衡测试
在客户端tns配置
kezcc =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac-scan.zcc.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = kezcc)
)
)
3、负载均衡+故障透明切换测试
–session
kezcc =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac-scan.zcc.com)(PORT = 1521))
(LOAD_BALANCE = yes)
(FAILOVER = ON)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = kezcc)
(FAILOVER_MODE =
(TYPE = SESSION)
(METHOD = BASIC)
)
)
)
–select(建议)
kezcc =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac-scan.zcc.com)(PORT = 1521))
(LOAD_BALANCE = yes)
(FAILOVER = ON)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = kezcc)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = BASIC)
)
)
)
总结
目前安装19c rac基本上没有什么bug，只要在检查环境的时候解决相对应的问题即可完成。
标签：Rac,19,oracle,grid,ORACLE,install,Oracle,yum,19c From： https://blog.csdn.net/qq_15168159/article/details/143587069