내맘대로긍정이 알려주는
Oracle 23ai 신기능
무료 세미나 발표자료
다운로드
trending_flat
OS환경 : Oracle Linux 7.6 (64bit)
DB 환경 : Oracle Database 19.3.0.0
에러 : [INS-20802] Oracle Cluster Verification Utility failed.
oracle 19c grid 설치(gridSetup.sh) 중 설치 마지막에 발생한 메세지
해결 방법 : 에러로그 확인 후 해당 verify 부분 조치
해당 로그파일 확인
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 | # vi /tmp/GridSetupActions2020-03-04_06-55-06AM/gridSetupActions2020-03-04_06-55-06AM.log INFO: [Mar 4, 2020 8:11:35 AM] Verifying Single Client Access Name (SCAN) ... INFO: [Mar 4, 2020 8:11:35 AM] Verifying DNS/NIS name service 'oel19db-scan' ... INFO: [Mar 4, 2020 8:11:35 AM] Verifying Name Service Switch Configuration File Integrity ...PASSED INFO: [Mar 4, 2020 8:11:37 AM] Verifying DNS/NIS name service 'oel19db-scan' ...FAILED (PRVG-11826, PRVG-11827, PRVF-4664) INFO: [Mar 4, 2020 8:11:37 AM] Verifying Single Client Access Name (SCAN) ...FAILED (PRVG-11826, PRVG-11827, PRVG-11368) INFO: [Mar 4, 2020 8:11:44 AM] Verifying OLR Integrity ...PASSED INFO: [Mar 4, 2020 8:12:00 AM] Verifying Voting Disk ...PASSED INFO: [Mar 4, 2020 8:12:19 AM] Verifying ASM Integrity ...PASSED INFO: [Mar 4, 2020 8:12:32 AM] Verifying ASM disk group free space ...PASSED INFO: [Mar 4, 2020 8:12:33 AM] Verifying User Not In Group "root": oracle ...PASSED INFO: [Mar 4, 2020 8:12:35 AM] Verifying Clock Synchronization ...PASSED INFO: [Mar 4, 2020 8:12:44 AM] Verifying VIP Subnet configuration check ...PASSED INFO: [Mar 4, 2020 8:12:44 AM] Verifying Network configuration consistency checks ...PASSED INFO: [Mar 4, 2020 8:12:44 AM] Verifying File system mount options for path GI_HOME ...PASSED INFO: [Mar 4, 2020 8:12:45 AM] Verifying Access control attributes for /var/tmp/.oracle ...PASSED INFO: [Mar 4, 2020 8:12:45 AM] Post-check for cluster services setup was unsuccessful. INFO: [Mar 4, 2020 8:12:45 AM] Checks did not pass for the following nodes: INFO: [Mar 4, 2020 8:12:45 AM] oel19db2,oel19db1 INFO: [Mar 4, 2020 8:12:45 AM] Failures were encountered during execution of CVU verification request "stage -post crsinst". INFO: [Mar 4, 2020 8:12:46 AM] Verifying Single Client Access Name (SCAN) ...FAILED INFO: [Mar 4, 2020 8:12:46 AM] oel19db2: PRVG-11368 : A SCAN is recommended to resolve to "3" or more IP INFO: [Mar 4, 2020 8:12:46 AM] addresses, but SCAN "oel19db-scan" resolves to only "/192.168.137.150" INFO: [Mar 4, 2020 8:12:46 AM] oel19db1: PRVG-11368 : A SCAN is recommended to resolve to "3" or more IP INFO: [Mar 4, 2020 8:12:46 AM] addresses, but SCAN "oel19db-scan" resolves to only "/192.168.137.150" INFO: [Mar 4, 2020 8:12:46 AM] Verifying DNS/NIS name service 'oel19db-scan' ...FAILED INFO: [Mar 4, 2020 8:12:46 AM] PRVG-11826 : DNS resolved IP addresses "" for SCAN name "oel19db-scan" not INFO: [Mar 4, 2020 8:12:46 AM] found in the name service returned IP addresses "192.168.137.150" INFO: [Mar 4, 2020 8:12:46 AM] PRVG-11827 : Name service returned IP addresses "192.168.137.150" for SCAN INFO: [Mar 4, 2020 8:12:46 AM] name "oel19db-scan" not found in the DNS returned IP addresses "" INFO: [Mar 4, 2020 8:12:46 AM] oel19db2: PRVF-4664 : Found inconsistent name resolution entries for SCAN INFO: [Mar 4, 2020 8:12:46 AM] name "oel19db-scan" INFO: [Mar 4, 2020 8:12:46 AM] oel19db1: PRVF-4664 : Found inconsistent name resolution entries for SCAN INFO: [Mar 4, 2020 8:12:46 AM] name "oel19db-scan" INFO: [Mar 4, 2020 8:12:46 AM] CVU operation performed: stage -post crsinst INFO: [Mar 4, 2020 8:12:46 AM] Date: Mar 4, 2020 8:10:10 AM INFO: [Mar 4, 2020 8:12:46 AM] CVU home: /ORA19/app/grid/19.3.0/ INFO: [Mar 4, 2020 8:12:46 AM] User: oracle INFO: [Mar 4, 2020 8:12:46 AM] Completed Plugin named: cvu INFO: [Mar 4, 2020 8:12:47 AM] Setup completed with overall status as Failed |
나의 경우 SCAN 문제임
SCAN IP가 DNS에 등록되어 있지 않아서 발생한 문제
그리고 로그상에 "A SCAN is recommended to resolve to "3" or more IP" 라고 표시됨
SCAN IP를 권장하는 값인 3개 이상을 사용하지 않고 1개만 사용해서 발생한 메세지
테스트 DB이므로 DNS에 등록 할 수 없고 문제가 되지 않기 때문에 무시함
원인 : SCAN IP가 DNS에 등록되어 있지 않아서 발생한 문제
참조 :
https://community.oracle.com/thread/4024420
https://wisdom16.tistory.com/19