暂无图片
oracle12cRAC集群执行root.sh脚本报错
我来答
分享
时光不老
2021-09-13
oracle12cRAC集群执行root.sh脚本报错

软件版本:
数据库版本:oracle 12.2.0.1
操作系统版本:red hat 6.8/7.6
补丁集版本:32928749

在节点1上执行root.sh时,报如下错误:
CRS-2676: Start of ‘ora.ctssd’ on ‘node1’ succeeded
CRS-2676: Start of ‘ora.cluster_interconnect.haip’ on ‘node1’ succeeded
CRS-2672: Attempting to start ‘ora.asm’ on ‘node1’
CRS-2676: Start of ‘ora.asm’ on ‘node1’ succeeded
CRS-2672: Attempting to start ‘ora.storage’ on ‘node1’
CRS-2676: Start of ‘ora.storage’ on ‘node1’ succeeded
CRS-2672: Attempting to start ‘ora.crf’ on ‘node1’
CRS-2676: Start of ‘ora.crf’ on ‘node1’ succeeded
CRS-2672: Attempting to start ‘ora.crsd’ on ‘node1’
CRS-2676: Start of ‘ora.crsd’ on ‘node1’ succeeded
CRS-6023: Starting Oracle Cluster Ready Services-managed resources
CRS-6017: Processing resource auto-start for servers: node1
CRS-6016: Resource auto-start has completed for server node1
CRS-6024: Completed start of Oracle Cluster Ready Services-managed resources
CRS-4123: Oracle High Availability Services has been started.
2021/09/13 22:24:55 CLSRSC-343: Successfully started Oracle Clusterware stack
2021/09/13 22:24:56 CLSRSC-594: Executing installation step 18 of 19: ‘ConfigNode’.
CRS-2672: Attempting to start ‘ora.ASMNET1LSNR_ASM.lsnr’ on ‘node1’
CRS-2676: Start of ‘ora.ASMNET1LSNR_ASM.lsnr’ on ‘node1’ succeeded
CRS-2672: Attempting to start ‘ora.asm’ on ‘node1’
CRS-2676: Start of ‘ora.asm’ on ‘node1’ succeeded
CRS-2672: Attempting to start ‘ora.OCR.dg’ on ‘node1’
CRS-2676: Start of ‘ora.OCR.dg’ on ‘node1’ succeeded
2021/09/13 22:26:30 CLSRSC-594: Executing installation step 19 of 19: ‘PostConfig’.

2021/09/13 22:27:10 CLSRSC-175: Failed to write the checkpoint ‘ROOTCRS_FIRSTNODE’ with status ‘SUCCESS’ (error code 1)
Died at /oracle/app/12.2.0.1/grid/crs/install/crsutils.pm line 13424.
The command '/oracle/app/12.2.0.1/grid/perl/bin/perl -I/oracle/app/12.2.0.1/grid/perl/lib -I/oracle/app/12.2.0.1/grid/crs/install /oracle/app/12.2.0.1/grid/crs/install/rootcrs.pl ’ execution failed

在节点1上删除集群的配置信息,再次执行root.sh ,脚本执行成功,在节点2上执行脚本,报如下错误:
[root@node2 oraInventory]# /oracle/app/12.2.0.1/grid/root.sh
Performing root user operation.

The following environment variables are set as:
ORACLE_OWNER= grid
ORACLE_HOME= /oracle/app/12.2.0.1/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: /oracle/app/12.2.0.1/grid/crs/install/crsconfig_params
The log of current session can be found at:
/oracle/app/grid/crsdata/node2/crsconfig/rootcrs_node2_2021-09-13_10-52-39PM.log
2021/09/13 22:52:44 CLSRSC-594: Executing installation step 1 of 19: ‘SetupTFA’.
2021/09/13 22:52:44 CLSRSC-4001: Installing Oracle Trace File Analyzer (TFA) Collector.
2021/09/13 22:54:00 CLSRSC-4002: Successfully installed Oracle Trace File Analyzer (TFA) Collector.
2021/09/13 22:54:00 CLSRSC-594: Executing installation step 2 of 19: ‘ValidateEnv’.
2021/09/13 22:54:01 CLSRSC-363: User ignored prerequisites during installation
2021/09/13 22:54:01 CLSRSC-594: Executing installation step 3 of 19: ‘CheckFirstNode’.
2021/09/13 22:54:05 CLSRSC-507: The root script cannot proceed on this node node2 because either the first-node operations have not completed on node node1 or there was an error in obtaining the status of the first-node operations.
Died at /oracle/app/12.2.0.1/grid/crs/install/crsutils.pm line 4130.
The command '/oracle/app/12.2.0.1/grid/perl/bin/perl -I/oracle/app/12.2.0.1/grid/perl/lib -I/oracle/app/12.2.0.1/grid/crs/install /oracle/app/12.2.0.1/grid/crs/install/rootcrs.pl ’ execution failed

我来答
添加附件
收藏
分享
问题补充
4条回答
默认
最新
Lucifer三思而后行
暂无图片

最新解决方案: Oracle集成基础安装包+补丁包

一、导读

本文主要介绍Redhat7.6系统安装oracle 12201版本RAC的一些坑以及避坑方式。绝对干货满满,物超所值,欢迎补充和纠错。

二、环境介绍

***OS:***redhat 7.6 64位(3.10.0-957.el7.x86_64)

***ORACLE:***12CR2 RAC

三、避坑指南

Notes:坑点主要位于Grid软件安装步骤中cvu的checkroot.sh执行

接下来是本篇文章的重点以及主旨,简单直接:

坑1:ASM device sharedness check

Shared Storage Accessibility:/dev/asm_ocr …FAILED (PRVG-11506)

可参照MOS文档:

12.2: PRVG-0802 : Storage type for path “/dev/mapper/asm011p1” could not be determined (Doc ID 2251322.1)

这里先不说解决方案,mos建议是打补丁:Apply patch 25784424, if CVU storage check fails for ASMLib paths 。

坑2:CLSRSC-400: A system reboot is required to continue installing.

此坑简直为巨坑无比,root.sh执行到进度14/19时,突然停止并且报错****CLSRSC-400,让我重启主机系统,重启之后安装已经终止了,无奈卸载重装依然报错。

可参照MOS文档:

ALERT: root.sh Fails With “CLSRSC-400” While Installing GI 12.2.0.1 on RHEL or OL with RedHat Compatible Kernel (RHCK) 7.3 (Doc ID 2284463.1)

这里先不说解决方案,mos建议是通过applyOneOffs打补丁:Interim patch 25078431 is required before installing 12.2 GI on Linux 7.3 (RedHat and OL7 with RHCK).

坑3:kgfnGetConnDetails requires 4 parameters at/u01/app/12.2.0/grid/lib/asmcmdbase.pm line 5704.

此坑是修复以上两个坑之后,root.sh执行到进度19/19时,突然停止,并报错如上,显示root.sh执行失败。

可参照MOS文档:

install.sh Hung And root.sh Is Failing At asmcmd lsdg --suppressheader While Installing A Zone With Clusterware (Doc ID 2414241.1)

ASMCMD Failing With "KGFNGETCONNDETAILS Requires 4 Parameters at <GI_HOME>/lib/asmcmdbase.pm (Doc ID 2748316.1)

解决方案:

/usr/bin/make -f /u01/app/12.2.0/grid/rdbms/lib/ins_rdbms.mk client_sharedlib libasmclntsh12.ohso libasmperl12.ohso ORACLE_HOME=/u01/app/12.2.0/grid
复制

1.如果已经遇到该错误,那么执行以上命令之后,重新执行root.sh即可,如果提前看到了本文,请按方法2提前执行;

***2.***出现执行root.sh提示框之时执行以上命令,需在两个节点以root身份执行该命令,GRID_HOME路径请根据实际情况填写

所有节点执行完之后,再执行root.sh

最后来总结以下坑1、2的解决方案

参考MOS文档:

***How to Apply a Grid Infrastructure Patch Before Grid Infrastructure Configuration (before root.sh or rootupgrade.sh or gridsetup.bat) is Executed (Doc ID 1410202.1)    ***

通过12C开始支持的applyPSU方式,提前给Grid软件打上最新的补丁,修复坑1,2的bug:

1.解压OPatch补丁包
$ su - grid -c "unzip /soft/p6880880_122010_Linux-x86-64.zip -d /u01/app/12.2.0/grid/"
Notes:选择A

2.查看OPatch补丁包版本
$ su - grid -c "/u01/app/12.2.0/grid/OPatch/opatch version"
OPatch Version: 12.2.0.1.24

3.解压最新PSU补丁
$ su - grid -c "unzip /soft/p32226491_122010_Linux-x86-64.zip -d /soft"

4.执行grid安装
$ ./gridSetup.sh -applyPSU /soft/32226491
Preparing the home to patch...
Applying the patch /soft/32226491/...
Successfully applied the patch.
The log can be found at: /u01/app/oraInventory/logs/GridSetupActions2021-04-01_04-18-54PM/installerPatchActions_2021-04-01_04-18-54PM.log
Launching Oracle Grid Infrastructure Setup Wizard...


5.安装grid成功之后查看补丁
$ opatch lspatches
26839277;DBWLM RELEASE UPDATE 12.2.0.1.0(ID:170913) (26839277)
32231681;ACFS JAN 2021 RELEASE UPDATE 12.2.0.1.210119 (32231681)
32253903;TOMCAT RELEASE UPDATE 12.2.0.1.0(ID:RELEASE) (32253903)
31802727;OCW OCT 2020 RELEASE UPDATE 12.2.0.1.201020 (31802727)
32228578;Database Jan 2021 Release Update : 12.2.0.1.210119 (32228578)
 
OPatch succeeded.
复制
暂无图片 评论
暂无图片 有用 0
打赏 0
暂无图片
时光不老
题主
2021-09-13
坑1解决,坑2打了补丁也不存在问题了,坑3占时没有遇到,我的问题好像跟你的问题都不一样,是Failed to write the checkpoint ‘ROOTCRS_FIRSTNODE’,第一个节点删除集群配置,配置成功后,第二个节点还是认不到,认为第一个节点没有执行成功。
时光不老
题主
2021-09-13
操作系统版本跟你一样,也是7.6的版本,第一个节点第一次配置的时候报Failed to write the checkpoint ‘ROOTCRS_FIRSTNODE’,删除集群配置后,再次重新执行root.sh就成功了,但是第二个节点执行root.sh,提示第一个节点的配置没有成功,其实是成功的了
Lucifer三思而后行
答主
2021-09-13
建议将grid卸载,重新安装试试,我现在按照上面这个步骤安装,没有遇到过任何报错!
时光不老
暂无图片 评论
暂无图片 有用 0
打赏 0
Uncopyrightable

可以查看linux系统的selinux、firewalld、网络方面是否有拦截或者连接不顺畅

暂无图片 评论
暂无图片 有用 0
打赏 0
时光不老
题主
2021-09-13
都已经检查过,不是这方面的问题,不管是6.8的操作系统还是7.6的操作系统都遇到了这个问题,6.8的操作系统没打补丁前,第一次执行root.sh脚本没有问题,但是第二个节点执行root.sh会报错,然后重装了一次,在执行脚本前,先打了补丁,第一个节点执行就报错
大海

p32226491_122010_Linux-x86-64.zip,这个补丁方便共享一下吗

暂无图片 评论
暂无图片 有用 0
打赏 0
回答交流
Markdown


请输入正文
提交
相关推荐
使用oracle linux安装oracle需要手动配置参数吗?
回答 2
已采纳
大部分有默认参数,但是sga等会让你输入一下(图形化界面)如果是静默安装,你要写一下。
怎么查看oracle中某个表里面的自增序列?
回答 2
oracle序列和表名没直接对应关系的,可以通过查询allsequences表查询序列名,根据自己的命名规则加条件查询
oracle里面描述的字段名,复制粘贴到excel表格里面都成了小写,怎么能变成大写?
回答 1
已采纳
excel自带转换函数,如果需要变成大写,可以尝试使用大写转换函数upper。UPPER()
oracle 目录LVM扩容resize2fs卡死
回答 2
已采纳
在RedHat5.4系统中,当使用resize2fs命令对/目录下的LVM扩容时出现了故障,导致系统进入假死状态。这可能是由于某些原因导致扩容操作无法正常完成,从而引发了此问题。以下是一些建议的步骤,
catbundle.sql psu apply
回答 1
DBAREGISTRYHISTORYprovidesinformationaboutupgrades,downgrades,andcriticalpatchupdatesthathavebeenper
Oracle 备份
回答 2
可以的,数据库会自己处理备份内容的,这样有可能会造成数据库全备提示找不到部分归档日志(备份归档日志时配置了备份后删除),整体不影响恢复完整性(前提是只要归档日志没有被删除,备份后的删除是可以的),全备
求oracle 11.2.0.4的安装包
回答 1
https://www.modb.pro/issue/33279
AWR分析报告问题求助:队列等待时间超过100s,平均等待时间超过100ms,建议针对该队列进行优化
回答 1
AWR报告应该是着重从等待事件和TOPSQL看问题
请教一个SQL(Oralce数据库)
回答 3
已采纳
WITHentrydateAS(SELECTTODATE('20180403','YYYYMMDD')ASstartdateFROMdual)SELECTADDMONTHS(startdate,(LE
oracle 从库与主库同步中断可能是什么原因?
回答 1
已采纳
DataGuard?可以看看从库的alert日志,看看报错是设么?查查看是不是有GAP?或者主库sys密码是不是被改过?DataGuard修复可以参考这篇:《实战篇:OracleDataGuard出现
问题信息
请登录之后查看
附件列表
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~