前段时间升级19c的时候遇到如下问题。
在进行升级前检查时报错如下：
./runcluvfy.sh stage -pre crsinst -upgrade -rolling -dest_crshome /u01/app/19c/grid -dest_version 19.0.0.0 -fixup
error:
Pre-check for cluster services setup was unsuccessful.
Checks did not pass for the following nodes:
zqdb2,zqdb1
Failures were encountered during execution of CVU verification request "stage -pre crsinst".
Verifying Network Time Protocol (NTP) ...FAILED
Verifying NTP daemon is synchronized with at least one external time source
...FAILED
zqdb1: PRVG-13602 : NTP daemon is not synchronized with any external time
source on node "zqdb1".
Verifying Time offset between nodes ...WARNING
PRVG-12103 : The current time offset of "81" seconds on node "zqdb2" is greater
than the permissible offset of "60" when compared to the time on node "zqdb1"
PRVG-12102 : The time difference between nodes "zqdb2" and "zqdb1" is beyond
the permissible offset of "60" seconds
Verifying Clusterware Version Consistency ...FAILED
Verifying cluster upgrade state ...FAILED
zqdb2: PRVG-13410 : The state of Oracle Clusterware is not as expected to
allow upgrade or patch operation. [Expected = "NORMAL" ; Found ="UPGRADE FINAL"]
zqdb1: PRVG-13410 : The state of Oracle Clusterware is not as expected to
allow upgrade or patch operation. [Expected = "NORMAL" ; Found ="UPGRADE FINAL"]
Verifying RPM Package Manager database ...INFORMATION
PRVG-11250 : The check "RPM Package Manager database" was not performed because
it needs 'root' user privileges.
检查失败？集群状态为"UPGRADE FINAL"
先用集群命令查看集群状态
检查集群版本状态
[grid@zqdb1 ~]$ crsctl query crs softwarepatch
crsctl query crs activeversionOracle Clusterware patch level on node zqdb1 is [817910529].
[grid@zqdb1 ~]$ crsctl query crs activeversion
Oracle Clusterware active version on the cluster is [18.0.0.0.0]
[grid@zqdb1 ~]$ crsctl query crs releasepatch
Oracle Clusterware release patch level is [817910529] and the complete list of patches [27908644 27923415 28090523 28090553 28090557 28256701 28547619 28655784 2865591
6 28655963 28656071 29249584 29301631 29301643 29302264 ] have been applied on the local node. The release patch string is [18.6.0.0.0].[grid@zqdb1 ~]$ crsctl query crs activeversion -f
Oracle Clusterware active version on the cluster is [18.0.0.0.0]. The cluster upgrade state is [UPGRADE FINAL]. The cluster active patch level is [817910529].
[grid@zqdb2 ~]$ crsctl query crs softwarepatch
crsctl query crs activeversionOracle Clusterware patch level on node zqdb2 is [817910529].
[grid@zqdb2 ~]$ crsctl query crs activeversion
Oracle Clusterware active version on the cluster is [18.0.0.0.0]
[grid@zqdb2 ~]$ crsctl query crs releasepatch
Oracle Clusterware release patch level is [817910529] and the complete list of patches [27908644 27923415 28090523 28090553 28090557 28256701 28547619 28655784 2865591
6 28655963 28656071 29249584 29301631 29301643 29302264 ] have been applied on the local node. The release patch string is [18.6.0.0.0].[grid@zqdb2 ~]$ crsctl query crs activeversion -f
Oracle Clusterware active version on the cluster is [18.0.0.0.0]. The cluster upgrade state is [UPGRADE FINAL]. The cluster active patch level is [817910529].
检查发现状态确实为 [UPGRADE FINAL]。
使用cluvfy修复试试。
cluvfy stage -post crsinst -collect cluster -gi_upgrade -n all
跑的过程中发现有如下报错
Failures were encountered during execution of CVU verification request "stage -post crsinst".
Verifying Single Client Access Name (SCAN) ...FAILED
zqdb2: PRVG-11368 : A SCAN is recommended to resolve to "3" or more IP
addresses, but SCAN "zqdb-scan" resolves to only "/10.7.82.45"
zqdb1: PRVG-11368 : A SCAN is recommended to resolve to "3" or more IP
addresses, but SCAN "zqdb-scan" resolves to only "/10.7.82.45"
Verifying DNS/NIS name service 'zqdb-scan' ...FAILED
PRVG-11826 : DNS resolved IP addresses "" for SCAN name "zqdb-scan" not found
in the name service returned IP addresses "10.7.82.45"
PRVG-11827 : Name service returned IP addresses "10.7.82.45" for SCAN name
"zqdb-scan" not found in the DNS returned IP addresses ""
zqdb2: PRVF-4664 : Found inconsistent name resolution entries for SCAN name
"zqdb-scan"
zqdb1: PRVF-4664 : Found inconsistent name resolution entries for SCAN name
"zqdb-scan"
Verifying Clock Synchronization ...WARNING
zqdb2: PRVG-11640 : The check "Clock Synchronization" was not performed as it
is disabled
zqdb1: PRVG-11640 : The check "Clock Synchronization" was not performed as it
is disabled
disable scan再次执行
export ORA_DISABLED_CVU_CHECKS=TASKCTSSINTEGRITY,SCAN
cluvfy stage -post crsinst -collect cluster -gi_upgrade -n all
检查状态
[grid@zqdb1 ~]$ crsctl query crs releasepatch
Oracle Clusterware release patch level is [817910529] and the complete list of patches [27908644 27923415 28090523 28090553 28090557 28256701 28547619 28655784 2865591
6 28655963 28656071 29249584 29301631 29301643 29302264 ] have been applied on the local node. The release patch string is [18.6.0.0.0].[grid@zqdb1 ~]$ crsctl query crs activeversion -f
Oracle Clusterware active version on the cluster is [18.0.0.0.0]. The cluster upgrade state is [NORMAL]. The cluster active patch level is [817910529].
发现状态变为正常。
