查看原文
其他

Oracle 19C RAC 安装遇到的坑

JiekeXu JiekeXu DBA之路 2024-03-03

作者 | JiekeXu

来源 | JiekeXu DBA之路(ID: JiekeXu_IT)

大家好,我是 JiekeXu,很高兴又和大家见面了,今天和大家聊聊 Oracle 19c RAC 安装遇到的坑,欢迎点击上方蓝字关注我,标星或置顶,更多干货第一时间到达!

虽说 Oracle 21C 马上要发布了,但 Oracle 19C 作为长期支持的大版本,才是很多企业和个人选择的主流,最近公司新上线的系统中均以 19C 为主,11204 已经逐渐退出了舞台。下面对 19C 的安装简单说明下,最主要的是介绍遇到的坑。


以下均以 Linuxone 操作系统下 SUSE 12 SP5 为例。


一、设置主机名:

# uname -aLinux jiekesp5r1 4.12.14-120-default #1 SMP Thu Nov 7 16:39:09 UTC 2019 (fd9dc36) s390x s390x s390x GNU/Linux--主机名原则上最好不要超过 8 位,小写字母加数字即可。hostnamectl set-hostname jieksp5r1hostnamectl set-hostname jieksp5r2

二、时区设置:

  • 根据客户标准设置 OS 时区,国内通常为东八区"Asia/Shanghai".

  • 在安装 GRID 之前,一定要先修改好 OS 时区,否则 GRID 将引用一个错误的 OS 时区,导致 DB 的时区,监听的时区等不正确。

jieksp5r1:/u01/app/19.0.0.0/grid #timedatectl status Local time: Mon 2021-03-01 21:20:16 CST Universal time: Mon 2021-03-01 13:20:16 UTC RTC time: n/a Time zone: Asia/Shanghai (CST, +0800) Network time on: noNTP synchronized: no RTCin local TZ: no

修改OS时区:

# timedatectl set-timezone "Asia/Shanghai"

三、hosts 文件配置

在RAC的各个节点配置 /etc/hosts,注意不要修改localhost那一行

# vi /etc/hosts#public ip192.168.1.XXX        jiekesp5r1192.168.1.XXX        jiekesp5r2 # private ip10.10.41.XX   jiekesp5r1-priv10.10.41.XX   jiekesp5r2-priv# vip192.168.1.XXX        jiekesp5r1-vip192.168.1.XXX        jiekesp5r2-vip# scan ip #安装时注意集群名不要超过 15 个字符,也不能有大写主机名。192.168.1.XXX  jieke-cls-scan 

四、建立目录和权限

mkdir -p /u01/app/19.0.0.0/gridmkdir -p /u01/app/gridmkdir -p /u01/app/oracle/product/19.0.0.0/dbhome_1chown -R grid:oinstall /u01chown -R oracle:oinstall /u01/app/oraclechmod -R 775 /u01

 五、建立用户和组

/usr/sbin/groupadd -g 1001 dba/usr/sbin/groupadd -g 1000 oinstall/usr/sbin/groupadd -g 1002 oper/usr/sbin/groupadd -g 1010 asmadmin/usr/sbin/groupadd -g 1011 asmdba/usr/sbin/groupadd -g 1012 asmoper
/usr/sbin/useradd -u 1000 -g oinstall -G oinstall,dba,oper,asmdba,asmadmin oracle -m -d /home/oracle/usr/sbin/useradd -u 1010 -g oinstall -G oinstall,dba,asmdba,asmadmin,asmoper grid -m -d /home/grid
--修改用户密码passwd gridpasswd  oracle

六、环境变量

Grid:more .bash_profileumask 022export ORACLE_BASE=/u01/app/gridexport ORACLE_HOME=/u01/app/19.0.0.0/gridexport ORACLE_SID=+ASM1exportPATH=${ORACLE_HOME}/bin:${ORACLE_HOME}/OPatch:${PATH}export HOST=`hostname | cut -f1-d"."`export PS1='${HOST}:$PWD(${ORACLE_SID})$ 'export SSH_AUTH_SOCK=0
oracle:more .bash_profileumask 022export ORACLE_BASE=/u01/app/oracleexportORACLE_HOME=/u01/app/oracle/product/19.0.0.0/dbhome_1export ORACLE_SID=JiekeXu1#export NLS_LANG=AMERICAN_AMERICA.ZHS16GBKexport NLS_LANG=AMERICAN_AMERICA.AL32UTF8export NLS_DATE_FORMAT="YYYY-MM-DDHH24:MI:SS"export LD_LIBRARY_PATH=${ORACLE_HOME}/libexportPATH=${ORACLE_HOME}/bin:${ORACLE_HOME}/OPatch:${PATH}export HOST=`hostname | cut -f1-d"."`export PS1='${HOST}:$PWD(${ORACLE_SID})$ '

 七、用户 shell limits 配置 

# vi /etc/security/limits.conf* soft stack unlimited* hard stack unlimited* soft nproc unlimited* hard nproc unlimited* soft nofile 1048576* hard nofile 1048576* soft memlock unlimited* hard memlock unlimited

八、内核参数配置

编辑/etc/sysctl.conf文件,需要增加或修改的内容如下:#示例如下: vi /etc/sysctl.conffs.aio-max-nr = 3145728fs.file-max = 6815744kernel.shmall = 20971520kernel.shmmax = 85899345920kernel.shmmni = 4096kernel.shmmax = 68719476736 # Controls the maximum shared segmentsize, in byteskernel.shmall = 1073741824              # Controls themaximum number ofkernel.sem = 10240 335534080 10240 32767kernel.panic_on_oops = 1kernel.numa_balancing= 0kernel.pid_max = 131072net.ipv4.ip_local_port_range = 9000 65500net.core.rmem_default = 4194304net.core.rmem_max = 4194304net.core.wmem_default = 1048576net.core.wmem_max = 1048576vm.min_free_kbytes= 1048576 #固定值:32G内存2G,64G 内存 5G=5242880 128G 内存 10Gvm.hugetlb_shm_group =1000 vm.nr_hugepages =内存K/3/Hugepagesize#操作系统内存的1/3 ,如果是 x86 Hugepagesize =2048,linuxone=1024# 例x86平台64G内存 64*1024*1024/3/2048=10922#linuxone平台64G内存 64*1024*1024/3/1024=21845net.ipv4.ipfrag_low_thresh=15728640net.ipv4.ipfrag_high_thresh=16777216kernel.msgmnb = 6553600 #该文件指定在一个消息队列中最大的字节数kernel.msgmax = 65535 #该文件指定了从一个进程发送到另一个进程的消息最大长度。进程间的消息传递是在内核的内存中进行的。不会交换到硬盘上。所以如果增加该值,则将增加操作系统所使用的内存数量。kernel.msgmni = 2878 #该文件指定消息队列标识的最大数目。缺省设置:16。net.ipv4.ip_forward = 0 #Controls IP packet forwardingnet.ipv4.conf.default.rp_filter = 0 #Controls source route verificationnet.ipv4.conf.default.accept_source_route =0 #Do not accept source routingnet.ipv4.tcp_syncookies = 1 # Controls the use of TCP syncookiekernel.core_uses_pid = 1 # Controls whether core dumps will append thePID to the core filename, Useful for debugging multi-threaded applications 使参数生效# sysctl –p

九、共享磁盘情况

要求归档和数据的磁盘来自不同的存储,属组:grid:asmadmin;权限:660OCR 盘 3 块,每块 5GB, Normal 格式。 归档盘或者数据盘 100G 以上,按照实际需求划分,每块盘大小需一致,Extend 格式。
jiekesp5r1:/u01/app/19.0.0.0/grid #lvmdiskscan /dev/mapper/3600507680c800576f8000000000007bd-part1 [ 1.00 GiB] /dev/mapper/3600507680c800576f8000000000007bd-part2 [ 32.00 GiB] /dev/mapper/3600507680c800576f8000000000007bd-part3[ 467.00 GiB] LVM physical volume /dev/root [ 50.00 GiB] /dev/rootvg/backuplv [ 216.99 GiB] /dev/rootvg/homelv                                  [      20.00 GiB] /dev/rootvg/tmplv                                   [      10.00 GiB] /dev/rootvg/u01lv [ 150.00 GiB] /dev/mapper/asm1 [ 5.00 GiB] /dev/mapper/asm2 [ 5.00 GiB] /dev/mapper/asm3 [ 5.00 GiB] /dev/mapper/asm4 [ 100.00 GiB] 7disks 6partitions 0LVM physical volume whole disks 1LVM physical volume

接下来需要检查内存、swap、关闭透明大页、关闭防火墙和 selinux 等一些操作,这里就先不说明了。最后一项配置互信,便可以开启图形化安装 GI 了,这里着重说明一下配置互信。


十、配置互信


以前都是不知道用户密码,使用 ssh-keygen 配置,一路回车,将自己的公钥写入对方对应用户的 ~/.ssh/authorized_keys 即可。

cat id_rsa.pub >> authorized_keys 比较方便快捷。

后期知道用户密码一般都是使用图形化 第四步 SSH connectivity  时输入 grid 用户密码,点击 setup 配置,点击 test 测试连接。

 

这次使用以上两种方法配置居然都没有测试通过,报错 INS-06006,然后使用第三种方法 oracle 自带脚本 sshUserSetup.sh 配置。


(1)配置步骤如下:

cd .sshrm -rf */u01/app/19.0.0.0/grid/oui/prov/resources/scripts/sshUserSetup.sh-user grid -hosts "jiekesp5r1 jiekesp5r2"-advanced -confirm –noPromptPassphrase
for h in jiekesp5r1 jiekesp5r1-priv jiekesp5r2 jiekesp5r2-priv;dossh -l grid -o StrictHostKeyChecking=no $h date;done
/u01/app/19.0.0.0/grid/oui/prov/resources/scripts/sshUserSetup.sh-user oracle -hosts "jiekesp5r1 jiekesp5r2"-advanced -confirm -noPromptPassphrase
for h in jiekesp5r1 jiekesp5r1-priv jiekesp5r2 jiekesp5r2-priv;dossh -l oracle -o StrictHostKeyChecking=no $h date;done

(2)INS-06006

下一步也会报错:


没办法,明明已经配置好 ssh 了,测试没问题但就是图形化点击 test 就报错 INS-06006 ,真是活见鬼了。尝试过很多办法无果最后在 mos 上找到一篇 “ID2555697.1” INS-06006 GI RunInstaller Fails If OpenSSH Is Upgradedto 8.x (文档 ID2555697.1) 说是 OpenSSH  版本升级到 8.0 的问题,注意到说明 SUSE12SP4 OpenSSH_7.2 会有这个问题,AIX OpenSSH_7.5 也会有这个问题。

jiekesp5r1:/u01/app/19.0.0.0/grid(+ASM1)>ssh-VOpenSSH_7.2p2, OpenSSL 1.0.2p-fips 14 Aug 2018

上图英文被水印遮挡住了一部分,这里翻译如下: 

为了降低(CVE-2019-6111)的风险,OpenSSH 8.0增加了客户端检查从服务器发送的文件名是否匹配命令行请求,如果客户端和服务器通配符扩展存在差异,客户端可能会拒绝从服务器发送的文件。由于这个原因,OpenSSH 8.0 为scp提供了一个新的“-T”标志,该标志禁用这些客户端检查。详情请参见https://www.openssh.com/txt/release-8.0

--使用 debug 模式sh gridSetup.sh -debug | tee /tmp/gridsetup.logErrors : PRVG-2019 : Check for equivalence of user"grid" from node "jiekesp5r1" to node "jiekesp5r2"failed
PRKN-1038: The command "/usr/bin/ssh -o FallBackToRsh=no -o PasswordAuthentication=no -o StrictHostKeyChecking=yes -o NumberOfPasswordPrompts=0 jiekesp5r2 -n /bin/true" run on node "jiekesp5r1" gave an unexpected output:"sign_and_send_pubkey: signing failed: agent refused operationPermissiondenied (publickey,keyboard-interactive)."
SOLUTIONWorkaround : (if your unix admin allows it)
Before installation, as root user: (pleasechange the path if the location of your "scp" is not the same withbelow)

(3)SOLUTION 解决办法

# Rename the original scp.mv /usr/bin/scp /usr/bin/scp.orig
# Create a new file </usr/bin/scp>.vi /usr/bin/scp
# Add the below line to the new createdfile </usr/bin/scp>./usr/bin/scp.orig -T $*
# Change the file permission.chmod 555 /usr/bin/scp
Afterinstallation:
mv /usr/bin/scp.orig /usr/bin/scp

 

十一、解决 ssh 问题 

jiekesp5r1:/etc# cd /usr/binjiekesp5r1:/usr/bin# ll scp*-rwxr-xr-x1 root root 100592 Jul 18 2019 scp-rwxr-xr-x1 root root 90 Oct 26 2016 scp-dbus-servicejiekesp5r1:/usr/bin# mv /usr/bin/scp /usr/bin/scp.origjiekesp5r1:/usr/bin# ll scp*-rwxr-xr-x1 root root 90 Oct 26 2016 scp-dbus-service-rwxr-xr-x1 root root 100592 Jul 18 2019 scp.origjiekesp5r1:/usr/bin# vi /usr/bin/scp
/usr/bin/scp.orig-T $*jiekesp5r1:/usr/bin# chmod 555 /usr/bin/scpjiekesp5r1:/usr/bin# ll scp*-r-xr-xr-x1 root root 24 Mar 1 14:48 scp-rwxr-xr-x1 root root 90 Oct 26 2016 scp-dbus-service-rwxr-xr-x1 root root 100592 Jul 18 2019 scp.orig 

以上配置好之后退出图形化重新 runInstaller 还会有问题,再需要根据 ID:2070270.1 配置一个环境变量 export SSH_AUTH_SOCK=0 然后使用新的 VNC 界面重新安装。GI runInstaller Fails with INS-6006 in VNC During SSH testeven though SSH Setup is successful (文档 ID 2070270.1)

这样算是解决了,不过有的时候只需要修改 SCP 即可,不需要配置 SSH_AUTH_SOCK 便可以测试通过,这个看当时的环境决定啦,下面还有一个问题需要说明一下。


十二、集群名问题


这里的 SCAN Name 便是 /etc/hosts 文件里指定的名字,必须一模一样,由于业务命名规范类似于  JiekeXu-cls-scan 这样的集群名字超过 15 个字符便写到了下方栏目中,这样也能进行下一步,不会报错,但是当执行 root.sh 脚本时便出现了问题。


注意:

  • cluster name长度要小于等于15个字符,可以使用字母,数字和短横线(-),并以字母开头。

  • 建议统一使用小写字母,切勿大小写字母混合使用。

  • scan name为/etc/hosts中配置的scan ip的别名。


root.sh 执行失败的记录

jiekesp5r1:/u01/app/19.0.0.0/grid # sh root.sh Performing root user operation.
The following environment variables are set as: ORACLE_OWNER= grid ORACLE_HOME= /u01/app/19.0.0.0/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 byDatabase Configuration Assistant when a database is createdFinished running generic part of root script.Now product-specific root actions will be performed.Relinking oracle with rac_on optionUsing configuration parameter file: /u01/app/19.0.0.0/grid/crs/install/crsconfig_paramsThe log of current session can be found at: /u01/app/grid/crsdata/jiekesp5r1/crsconfig/rootcrs_jiekesp5r1_2021-03-01_03-52-02PM.log2021/03/01 15:52:11 CLSRSC-594: Executing installation step 1 of 19: 'SetupTFA'.2021/03/01 15:52:11 CLSRSC-594: Executing installation step 2 of 19: 'ValidateEnv'.2021/03/01 15:52:11 CLSRSC-363: User ignored prerequisites during installation2021/03/01 15:52:11 CLSRSC-594: Executing installation step 3 of 19: 'CheckFirstNode'.2021/03/01 15:52:14 CLSRSC-594: Executing installation step 4 of 19: 'GenSiteGUIDs'.2021/03/01 15:52:14 CLSRSC-594: Executing installation step 5 of 19: 'SetupOSD'.2021/03/01 15:52:15 CLSRSC-594: Executing installation step 6 of 19: 'CheckCRSConfig'.2021/03/01 15:52:15 CLSRSC-594: Executing installation step 7 of 19: 'SetupLocalGPNP'.2021/03/01 15:52:33 CLSRSC-594: Executing installation step 8 of 19: 'CreateRootCert'.2021/03/01 15:52:39 CLSRSC-594: Executing installation step 9 of 19: 'ConfigOLR'.2021/03/01 15:52:41 CLSRSC-4002: Successfully installed Oracle Trace File Analyzer (TFA) Collector.2021/03/01 15:52:53 CLSRSC-594: Executing installation step 10 of 19: 'ConfigCHMOS'.2021/03/01 15:52:53 CLSRSC-594: Executing installation step 11 of 19: 'CreateOHASD'.2021/03/01 15:52:58 CLSRSC-594: Executing installation step 12 of 19: 'ConfigOHASD'.2021/03/01 15:52:59 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.service'2021/03/01 15:53:26 CLSRSC-594: Executing installation step 13 of 19: 'InstallAFD'.2021/03/01 15:53:32 CLSRSC-594: Executing installation step 14 of 19: 'InstallACFS'.2021/03/01 15:53:37 CLSRSC-594: Executing installation step 15 of 19: 'InstallKA'.2021/03/01 15:53:42 CLSRSC-594: Executing installation step 16 of 19: 'InitConfig'.CRS-2672: Attempting to start 'ora.evmd' on 'jiekesp5r1'CRS-2672: Attempting to start 'ora.mdnsd' on 'jiekesp5r1'CRS-2676: Start of 'ora.mdnsd' on 'jiekesp5r1' succeededCRS-2676: Start of 'ora.evmd' on 'jiekesp5r1' succeededCRS-2672: Attempting to start 'ora.gpnpd' on 'jiekesp5r1'CRS-2676: Start of 'ora.gpnpd' on 'jiekesp5r1' succeededCRS-2672: Attempting to start 'ora.cssdmonitor' on 'jiekesp5r1'CRS-2672: Attempting to start 'ora.gipcd' on 'jiekesp5r1'CRS-2676: Start of 'ora.cssdmonitor' on 'jiekesp5r1' succeededCRS-2674: Start of 'ora.gipcd' on 'jiekesp5r1' failedCRS-2673: Attempting to stop 'ora.cssdmonitor' on 'jiekesp5r1'CRS-2677: Stop of 'ora.cssdmonitor' on 'jiekesp5r1' succeededCRS-2673: Attempting to stop 'ora.gpnpd' on 'jiekesp5r1'CRS-2677: Stop of 'ora.gpnpd' on 'jiekesp5r1' succeededCRS-2673: Attempting to stop 'ora.mdnsd' on 'jiekesp5r1'CRS-2677: Stop of 'ora.mdnsd' on 'jiekesp5r1' succeededCRS-2673: Attempting to stop 'ora.evmd' on 'jiekesp5r1'CRS-2677: Stop of 'ora.evmd' on 'jiekesp5r1' succeededCRS-4000: Command Start failed, or completed with errors.2021/03/01 15:54:46 CLSRSC-119: Start of the exclusive mode cluster failedDied at /u01/app/19.0.0.0/grid/crs/install/crsinstall.pm line 2439.



执行 root.sh 失败


执行 root 脚本失败,按照报错查了很久,最终 mos 发现一篇文章 2568395.1 说明是由于 bug 28628631 集群名大于 15 个字符导致的。修改完 /etc/hosts 清理掉本次安装错误的软件,然后重新图形化安装即可。CLSRSC-119: Start of the exclusive mode cluster failed WhileRunning root.sh While Installing Grid Infrastructure 19c (文档 ID 2568395.1)


jiekesp5r1:/u01/app/19.0.0.0/grid# ./root.shPerformingroot user operation.
Thefollowing environment variables are set as: ORACLE_OWNER= grid ORACLE_HOME= /u01/app/19.0.0.0/grid
Enter thefull pathname of the local bin directory: [/usr/local/bin]:Thecontents of "dbhome" have not changed. No need to overwrite.Thecontents of "oraenv" have not changed. No need to overwrite.Thecontents of "coraenv" have not changed. No need to overwrite.

Creating/etc/oratab file...Entrieswill be added to the /etc/oratab file as needed byDatabaseConfiguration Assistant when a database is createdFinishedrunning generic part of root script.Nowproduct-specific root actions will be performed.Relinkingoracle with rac_on optionUsingconfiguration parameter file:/u01/app/19.0.0.0/grid/crs/install/crsconfig_paramsThe logof current session can be found at: /u01/app/grid/crsdata/jiekesp5r1/crsconfig/rootcrs_jiekesp5r1_2021-03-01_08-30-28PM.log2021/03/01 20:30:37 CLSRSC-594: Executing installation step 1 of 19: 'SetupTFA'.2021/03/01 20:30:37 CLSRSC-594: Executing installation step 2 of 19: 'ValidateEnv'.2021/03/01 20:30:38 CLSRSC-363: User ignored prerequisites during installation2021/03/01 20:30:38 CLSRSC-594: Executing installation step 3 of 19: 'CheckFirstNode'.2021/03/01 20:30:40 CLSRSC-594: Executing installation step 4 of 19: 'GenSiteGUIDs'.2021/03/01 20:30:41 CLSRSC-594: Executing installation step 5 of 19: 'SetupOSD'.2021/03/01 20:30:41 CLSRSC-594: Executing installation step 6 of 19: 'CheckCRSConfig'.2021/03/01 20:30:41 CLSRSC-594: Executing installation step 7 of 19: 'SetupLocalGPNP'.2021/03/01 20:31:00 CLSRSC-594: Executing installation step 8 of 19: 'CreateRootCert'.2021/03/01 20:31:06 CLSRSC-594: Executing installation step 9 of 19: 'ConfigOLR'.2021/03/01 20:31:06 CLSRSC-4002: Successfully installed Oracle Trace File Analyzer (TFA)Collector.2021/03/01 20:31:22 CLSRSC-594: Executing installation step 10 of 19: 'ConfigCHMOS'.2021/03/01 20:31:22 CLSRSC-594: Executing installation step 11 of 19: 'CreateOHASD'.2021/03/01 20:31:28 CLSRSC-594: Executing installation step 12 of 19: 'ConfigOHASD'.2021/03/01 20:31:28 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.service'2021/03/01 20:31:57 CLSRSC-594: Executing installation step 13 of 19: 'InstallAFD'.2021/03/01 20:32:03 CLSRSC-594: Executing installation step 14 of 19: 'InstallACFS'.2021/03/01 20:32:09 CLSRSC-594: Executing installation step 15 of 19: 'InstallKA'.2021/03/01 20:32:14 CLSRSC-594: Executing installation step 16 of 19: 'InitConfig'.
ASM hasbeen created and started successfully.
[DBT-30001]Disk groups created successfully. Check/u01/app/grid/cfgtoollogs/asmca/asmca-210301PM083251.log for details.
2021/03/01 20:33:49 CLSRSC-482: Running command: '/u01/app/19.0.0.0/grid/bin/ocrconfig-upgrade grid oinstall'CRS-4256:Updating the profileSuccessfuladdition of voting disk aec0bea5a1dc4fe5bfe84ab3be3ebaa3.Successfuladdition of voting disk c967ec5031014f90bf88ab6393a3d1c0.Successfuladdition of voting disk 6e5bcaae9d7d4f57bfb415d21699a465.Successfullyreplaced voting disk group with +KHYXSP5R_OCR.CRS-4256:Updating the profileCRS-4266:Voting file(s) successfully replaced## STATE File Universal Id File Name Disk group-- ----- ----------------- --------- --------- 1. ONLINE  aec0bea5a1dc4fe5bfe84ab3be3ebaa3 (/dev/mapper/asm1) [JIEKSP5R_OCR] 2. ONLINE  c967ec5031014f90bf88ab6393a3d1c0 (/dev/mapper/asm2) [JIEKSP5R_OCR] 3. ONLINE  6e5bcaae9d7d4f57bfb415d21699a465 (/dev/mapper/asm3) [JIEKSP5R_OCR]Located 3voting disk(s).
2021/03/0120:35:50 CLSRSC-594: Executing installation step 17 of 19: 'StartCluster'.2021/03/0120:37:10 CLSRSC-343: Successfully started Oracle Clusterware stack2021/03/0120:37:10 CLSRSC-594: Executing installation step 18 of 19: 'ConfigNode'.2021/03/0120:38:21 CLSRSC-594: Executing installation step 19 of 19: 'PostConfig'.2021/03/0120:38:55 CLSRSC-325: Configure Oracle Grid Infrastructure for a Cluster ...succeededjiekesp5r1:/u01/app/19.0.0.0/grid#--节点2 root.sh 执行过程省略 jiekesp5r2:/u01/app/19.0.0.0/grid# ./root.sh

 如上,所示 GI 便安装完成了,接着便可以进行 db 软件和实例的安装。下边展示安装完成的集群状态。

jiekesp5r2:/backup/soft # /u01/app/19.0.0.0/grid/bin/crsctl status res -t --------------------------------------------------------------------------------Name Target State Server State details --------------------------------------------------------------------------------Local Resources--------------------------------------------------------------------------------ora.LISTENER.lsnr ONLINE ONLINE jiekesp5r1 STABLE ONLINE ONLINE jiekesp5r2 STABLEora.net1.network ONLINE ONLINE jiekesp5r1 STABLE ONLINE ONLINE jiekesp5r2 STABLEora.ons ONLINE ONLINE jiekesp5r1 STABLE ONLINE ONLINE jiekesp5r2 STABLE--------------------------------------------------------------------------------Cluster Resources--------------------------------------------------------------------------------ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup) 1 ONLINE ONLINE jiekesp5r1 STABLE 2 ONLINE ONLINE jiekesp5r2 STABLE 3 ONLINE OFFLINE STABLEora.JIEKSP5R_DATA.dg(ora.asmgroup) 1 ONLINE ONLINE jiekesp5r1 STABLE 2 ONLINE ONLINE jiekesp5r2 STABLE 3 OFFLINE OFFLINE STABLEora.JIEKSP5R_OCR.dg(ora.asmgroup) 1 ONLINE ONLINE jiekesp5r1 STABLE 2 ONLINE ONLINE jiekesp5r2 STABLE 3 OFFLINE OFFLINE STABLEora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE jiekesp5r1 STABLEora.asm(ora.asmgroup) 1 ONLINE ONLINE jiekesp5r1 Started,STABLE 2 ONLINE ONLINE jiekesp5r2 Started,STABLE 3 OFFLINE OFFLINE STABLEora.asmnet1.asmnetwork(ora.asmgroup) 1 ONLINE ONLINE jiekesp5r1 STABLE 2 ONLINE ONLINE jiekesp5r2 STABLE 3 OFFLINE OFFLINE STABLEora.cvu 1 ONLINE ONLINE jiekesp5r1 STABLEora.jiekesp5r1.vip 1 ONLINE ONLINE jiekesp5r1 STABLEora.jiekesp5r2.vip 1 ONLINE ONLINE jiekesp5r2 STABLEora.JiekeXu.db 1 ONLINE ONLINE jiekesp5r1 Open,HOME=/u01/app/o racle/product/19.0.0 .0/dbhome_1,STABLE 2 ONLINE ONLINE jiekesp5r2 Open,HOME=/u01/app/o racle/product/19.0.0 .0/dbhome_1,STABLEora.scan1.vip      1        ONLINE  ONLINE       jiekesp5r1                STABLE

至此便已经安装成功了,对于 RU 补丁安装的坑,前面一篇已经有说明了,这里就不在说明了,今天就到这里了,如果此文对您有帮助,欢迎点赞、在看与转发,便是对作者最大的支持。19C 集群安装软件可以点击阅读原文去下载。

————————————————————————————
公众号:JiekeXu DBA之路
墨天轮:https://www.modb.pro/u/4347
CSDN :https://blog.csdn.net/JiekeXu
腾讯云:https://cloud.tencent.com/developer/user/5645107

————————————————————————————



Oracle 12c 及以上版本补丁更新说明及下载方法(收藏版)

一线运维 DBA 五年经验常用 SQL 大全(一)

一线运维 DBA 五年经验常用 SQL 大全(二)

Oracle 21C 新特性:数据泵相关新特性汇总

如何通过 Shell 监控异常等待事件和活跃会话 

Oracle 12C 最新补丁下载与安装操作指北

DBA 常用的软件工具有哪些(分享篇)?

Oracle 每日一题系列合集

百花齐放的国产数据库

继续滑动看下一个

Oracle 19C RAC 安装遇到的坑

JiekeXu JiekeXu DBA之路
向上滑动看下一个

您可能也对以下帖子感兴趣

文章有问题?点此查看未经处理的缓存