INS-20802 GRID Infrastructure Configuration failed

584635169

操作系统：windows server 2008 R2  sp1 64bit
数据库版本：oracle 11.2.0.2  采用asm方式
卸载原来的grid，数据库之后，重新安装，出现如图所示错误。
查看提示日志，部分内容如下：
INFO: Created config job for Grid Infrastructure Configuration
INFO: Created config job for Update Inventory
INFO: Created config job for Oracle Net Configuration Assistant
INFO: Created config job for Automatic Storage Management Configuration Assistant
INFO: Created config job for Oracle Cluster Verification Utility
INFO: Configuration log directory - C:\app\11.2.0\grid\cfgtoollogs
INFO:
The Runconfig command constructed is C:\app\11.2.0\grid\oui\bin\runConfig.bat ORACLE_HOME=C:\app\11.2.0\grid MODE=perform ACTION=configure RERUN=true $*
INFO: Created a new file C:\app\11.2.0\grid\cfgtoollogs\configToolAllCommands
INFO: Since the option is to overwrite the existing C:\app\11.2.0\grid\cfgtoollogs\configToolAllCommands file, backing it up
INFO: The backed up file name is C:\app\11.2.0\grid\cfgtoollogs\configToolAllCommands.bak
INFO: Entering ConfigClient.executeToolsInAggregate method
INFO: ConfigClient.executeToolsInAggregate oAggregate=oracle.crs:oracle.crs:11.2.0.3.0:common
INFO: Entering ConfigClient.assignAction method
INFO: ConfigClient.assignAction actionref=[Loracle.sysman.emCfg.common.IActionReference;@68443a3
INFO: ConfigClient.assignAction action is of type :configuration
INFO: Exiting ConfigClient.assignAction method
INFO: ConfigClient.executeToolsInAggregate action assigned
INFO: Started Plugin named: Grid Infrastructure Configuration
INFO: Found associated job
INFO: Starting 'Grid Infrastructure Configuration'
INFO: Starting 'Grid Infrastructure Configuration'
INFO: 2014-07-22 18:45:28: Checking for super user privileges

INFO: 2014-07-22 18:45:28: superUser=SOFTINSTALLER groupName=Administrators

INFO: 2014-07-22 18:45:28: domain=dylq user=SOFTINSTALLER

INFO: 2014-07-22 18:45:28: C:\app\11.2.0\grid\bin\crssetup.exe getsystem

INFO: 2014-07-22 18:45:28: Executing cmd: C:\app\11.2.0\grid\bin\crssetup.exe getsystem

INFO: 2014-07-22 18:45:28: Command output:

INFO: >  SYSTEM

INFO: >End Command output

INFO: 2014-07-22 18:45:28: User has SOFTINSTALLER privileges

INFO: Using configuration parameter file: C:\app\11.2.0\grid\crs\install\crsconfig_params

INFO: Creating trace directory

INFO:
WARNING:
INFO: Completed Plugin named: Grid Infrastructure Configuration
远程节点：D:\app\11.2.0\grid\cfgtoollogs\oui日志：
……
                Oracle Recovery Manager 11.2.0.2.0
                Oracle Database Utilities 11.2.0.2.0
                SQL*Plus 11.2.0.2.0
                Oracle Netca Client 11.2.0.2.0
                Oracle Net 11.2.0.2.0
                Oracle JVM 11.2.0.2.0
                Oracle Internet Directory Client 11.2.0.2.0
                Oracle Net Listener 11.2.0.2.0
                Cluster Ready Services Files 11.2.0.2.0
                Oracle Database 11g 11.2.0.2.0

INFO: Checkpoint:Failed Checkpoint found returning it for getAllFailedCheckPoints.
INFO: Checkpoint:Failed Checkpoint found returning null for getLastFailedCheckPoint.
INFO: Checkpoint:Index file written and updated
INFO: Checkpoint:Failed Checkpoint found returning it for getAllFailedCheckPoints.
INFO: Checkpoint:Failed Checkpoint found returning null for getLastFailedCheckPoint.
INFO: Checkpoint:Index file written and updated
INFO: Checkpoint:Transfer of file done from remote node
INFO: Done calling doOperation.
INFO: Ending the inventory Session
INFO: Disposing the install area control objects
INFO: 'AttachHome' was successful.

请问，这种情况是什么原因导致的？谢谢！

Maclean Liu(刘相兵

这个图里 具体是哪一个步骤出错了 ， 哪个小窗口正好盖住了 看不到。

你的root.sh是否正常运行？ 请重新截图

584635169

Maclean Liu(刘相兵 发表于 2014-7-24 16:42
这个图里 具体是哪一个步骤出错了 ， 哪个小窗口正好盖住了 看不到。

你的root.sh是否正常运行？ 请重新截 ...

grid OUI界面检测未报任何错误。runcluvfy.bat结果如下：
E:\>cd E:\ORACLE11.2.0.2\GRID

E:\ORACLE11.2.0.2\GRID>runcluvfy.bat stage -pre crsinst -n dylqora1,dylqora2 -ve
rbose

Performing pre-checks for cluster services setup

Checking node reachability...

Check: Node reachability from node "DYLQORA1"
  Destination Node                      Reachable?
  ------------------------------------  ------------------------
  dylqora1                              yes
  dylqora2                              yes
Result: Node reachability check passed from node "DYLQORA1"


Checking user equivalence...

Check: User equivalence for user "softinstaller"
  Node Name                             Comment
  ------------------------------------  ------------------------
  dylqora1                              passed
  dylqora2                              passed
Result: User equivalence check passed for user "softinstaller"

Checking node connectivity...


Interface information for node "dylqora1"
Name   IP Address      Subnet          Gateway         Def. Gateway    HW Addre
ss        MTU
------ --------------- --------------- --------------- --------------- --------
--------- ------
Public 10.50.234.101   10.50.234.96    On-link         UNKNOWN         6C:AE:8B
:78:41:26 1500
Private 20.2.2.1        20.2.2.0        On-link         UNKNOWN         90:E2:B
A:43:4E:40 1500
storage 10.10.10.20     10.10.10.0      On-link         UNKNOWN         6C:AE:8
B:78:41:24 1500


Interface information for node "dylqora2"
Name   IP Address      Subnet          Gateway         Def. Gateway    HW Addre
ss        MTU
------ --------------- --------------- --------------- --------------- --------
--------- ------
Public 10.50.234.102   10.50.234.96    On-link         UNKNOWN         6C:AE:8B
:78:3F:BA 1500
Private 20.2.2.2        20.2.2.0        On-link         UNKNOWN         90:E2:B
A:43:51:E6 1500
Storage 10.10.20.20     10.10.20.0      On-link         UNKNOWN         6C:AE:8
B:78:3F:B8 1500


Check: Node connectivity of subnet "10.50.234.96"
  Source                          Destination                     Connected?

  ------------------------------  ------------------------------  --------------
--
  dylqora1[10.50.234.101]         dylqora2[10.50.234.102]         yes

Result: Node connectivity passed for subnet "10.50.234.96" with node(s) dylqora1
,dylqora2


Check: TCP connectivity of subnet "10.50.234.96"
  Source                          Destination                     Connected?

  ------------------------------  ------------------------------  --------------
--
  DYLQORA1:10.50.234.101          dylqora1:10.50.234.101          failed


ERROR:
PRVF-7617 : Node connectivity between "DYLQORA1 : 10.50.234.101" and "dylqora1 :
10.50.234.101" failed
  DYLQORA1:10.50.234.101          dylqora2:10.50.234.102          failed


ERROR:
PRVF-7617 : Node connectivity between "DYLQORA1 : 10.50.234.101" and "dylqora2 :
10.50.234.102" failed
Result: TCP connectivity check failed for subnet "10.50.234.96"


Check: Node connectivity of subnet "20.2.2.0"
  Source                          Destination                     Connected?

  ------------------------------  ------------------------------  --------------
--
  dylqora1[20.2.2.1]              dylqora2[20.2.2.2]              yes

Result: Node connectivity passed for subnet "20.2.2.0" with node(s) dylqora1,dyl
qora2


Check: TCP connectivity of subnet "20.2.2.0"
  Source                          Destination                     Connected?

  ------------------------------  ------------------------------  --------------
--
  DYLQORA1:10.50.234.101          dylqora1:20.2.2.1               passed

  DYLQORA1:10.50.234.101          dylqora2:20.2.2.2               failed


ERROR:
PRVF-7617 : Node connectivity between "DYLQORA1 : 10.50.234.101" and "dylqora2 :
20.2.2.2" failed
Result: TCP connectivity check failed for subnet "20.2.2.0"


Check: Node connectivity of subnet "10.10.10.0"
Result: Node connectivity passed for subnet "10.10.10.0" with node(s) dylqora1


Check: TCP connectivity of subnet "10.10.10.0"
  Source                          Destination                     Connected?

  ------------------------------  ------------------------------  --------------
--
  DYLQORA1:10.50.234.101          dylqora1:10.10.10.20            passed

Result: TCP connectivity check passed for subnet "10.10.10.0"


Check: Node connectivity of subnet "10.10.20.0"
Result: Node connectivity passed for subnet "10.10.20.0" with node(s) dylqora2


Check: TCP connectivity of subnet "10.10.20.0"
  Source                          Destination                     Connected?

  ------------------------------  ------------------------------  --------------
--
  DYLQORA1:10.50.234.101          dylqora2:10.10.20.20            failed


ERROR:
PRVF-7617 : Node connectivity between "DYLQORA1 : 10.50.234.101" and "dylqora2 :
10.10.20.20" failed
Result: TCP connectivity check failed for subnet "10.10.20.0"


Interfaces found on subnet "20.2.2.0" that are likely candidates for VIP are:
dylqora1 Private:20.2.2.1
dylqora2 Private:20.2.2.2

WARNING:
Could not find a suitable set of interfaces for the private interconnect

Result: Node connectivity check failed


Check: Total memory
  Node Name     Available                 Required                  Comment
  ------------  ------------------------  ------------------------  ----------
  dylqora1      63.9775GB (6.7085304E7KB)  922MB (944128.0KB)        passed
  dylqora2      63.9775GB (6.7085304E7KB)  922MB (944128.0KB)        passed
Result: Total memory check passed

Check: Available memory
  Node Name     Available                 Required                  Comment
  ------------  ------------------------  ------------------------  ----------
  dylqora1      59.3914GB (6.227644E7KB)  50MB (51200.0KB)          passed
  dylqora2      60.5366GB (6.3477244E7KB)  50MB (51200.0KB)          passed
Result: Available memory check passed

Check: Swap space
  Node Name     Available                 Required                  Comment
  ------------  ------------------------  ------------------------  ----------
  dylqora1      83.507GB (8.756344E7KB)   16GB (1.6777216E7KB)      passed
  dylqora2      83.507GB (8.756344E7KB)   16GB (1.6777216E7KB)      passed
Result: Swap space check passed

Check: Free disk space for "dylqora1:C:\Windows\temp"
  Path              Node Name     Mount point   Available     Required      Comm
ent
  ----------------  ------------  ------------  ------------  ------------  ----
--------
  C:\Windows\temp   dylqora1      C             55.388GB      1GB           pass
ed
Result: Free disk space check passed for "dylqora1:C:\Windows\temp"

Check: Free disk space for "dylqora2:C:\Windows\temp"
  Path              Node Name     Mount point   Available     Required      Comm
ent
  ----------------  ------------  ------------  ------------  ------------  ----
--------
  C:\Windows\temp   dylqora2      C             60.8378GB     1GB           pass
ed
Result: Free disk space check passed for "dylqora2:C:\Windows\temp"

Check: System architecture
  Node Name     Available                 Required                  Comment
  ------------  ------------------------  ------------------------  ----------
  dylqora1      64-bit                    64-bit                    passed
  dylqora2      64-bit                    64-bit                    passed
Result: System architecture check passed

Checking length of value of environment variable "PATH"
Check: Length of value of environment variable "PATH"
  Node Name         Set?          Maximum Length  Actual Length  Comment

  ----------------  ------------  ------------  ------------  ----------------
  dylqora1          yes           1023          193           passed
  dylqora2          yes           1023          162           passed
Result: Check for length of value of environment variable "PATH" passed.

Checking for Media Sensing status of TCP/IP
  Node Name     Enabled?                  Comment
  ------------  ------------------------  ------------------------
  dylqora1      no                        passed
  dylqora2      no                        passed
Result: Media Sensing status of TCP/IP check passed

Starting Clock synchronization checks using Network Time Protocol(NTP)...

Checking daemon liveness...

Check: Liveness for "W32Time"
  Node Name                             Running?
  ------------------------------------  ------------------------
  dylqora1                              yes
  dylqora2                              yes
Result: Liveness check passed for "W32Time"
Check for NTP daemon or service alive passed on all nodes

Result: Clock synchronization check using Network Time Protocol(NTP) passed



Checking if current user is a domain user...
Check: If user "softinstaller" is a domain user
Result: User "softinstaller" is a part of the domain "DYLQ"
Check: Time zone consistency
Result: Time zone consistency check passed

Checking for status of Automount feature
  Node Name     Enabled?                  Comment
  ------------  ------------------------  ------------------------
  dylqora1      yes                       passed
  dylqora2      yes                       passed
Result: Check for status of Automount feature passed

Pre-check for cluster services setup was unsuccessful.
Checks did not pass for the following node(s):
        DYLQORA1 : 10.50.234.101

E:\ORACLE11.2.0.2\GRID>

由于该RAC只是卸载后重新安装，尚未进行操作系统重装。

584635169

报错截图

Maclean Liu(刘相兵

ODM FINDING:

RAC on Windows: Oracle Grid Infrastructure Install or Upgrade Fails With Error INS-20802 if Microsoft WMI Service is Disabled (文档 ID 1641356.1)

PPLIES TO:

Oracle Database - Standard Edition - Version 11.2.0.2 and later
Information in this document applies to any platform.
SYMPTOMS

On Windows, Oracle Grid Infrastructure install or upgrade will fail during 'Grid Infrastructure Configuration' and likely at 85% with the error:  INS-20802 presented.

CAUSE

The INS-20802 error is rather generic and may have many causes indicating many underlying issues, however, one such case is if the Microsoft Windows Management Instrumentation Service (WMI) is disabled on the remote node(s)



Here is an example / test case scenario where we would expect to see this behavior:

1.  install Grid Infrastructure 11.2.0.2

2.  disable and stop WMI on both nodes

3.  patch Grid Infrastructure with (the latest) patch bundle - 11.2.0.2.27, for example

4.  upgrade GI from 11.2.0.2.27 to 11.2.0.4

***  Grid Infrastructure configuration fails at 85% with error:  INS-20802 reported ***



$GI_HOME\cfgtoollogs\crsconfig\rootcrs<hostname>.log from the remote node (example:  node 2) reports:



2014-03-29 18:38:43: J2EE (OC4J) Container Resource enable ... passed
2014-03-29 18:38:43: Running as user Administrator: E:\app\11.2.0\grid_1\bin\srvctl start oc4j
2014-03-29 18:38:43: s_run_as_user2: Running E:\app\11.2.0\grid_1\bin\srvctl start oc4j
2014-03-29 18:38:45: E:\app\11.2.0\grid_1\bin\srvctl exited with rc=1

2014-03-29 18:38:45: Error encountered in the command E:\app\11.2.0\grid_1\bin\srvctl start oc4j
>  OC4J could not be started
>  PRCR-1079 : Failed to start resource ora.oc4j
>  CRS-2674: Start of 'ora.oc4j' on 'jsrac64b' failed
>  CRS-2678: 'ora.oc4j' on 'jsrac64b' has experienced an unrecoverable failure
>  CRS-0267: Human intervention required to resume its availability.
>  End Command output
2014-03-29 18:38:45: J2EE (OC4J) Container Resource Start ... failed ...
2014-03-29 18:38:45: Failed to perform J2EE (OC4J) Container Resource upgrade


Specifically, the WMI is must be enabled in order for our ora.oc4j clusterware resource to startup.  If WMI is disabled during install or upgrade, the ora.oc4j resource will not startup and cause the Grid Infrastructure configuration to fail.

SOLUTION

-  Re-enable the (non-Oracle) Windows Management Instrumentation service on the remote node(s) by setting it back to 'Automatic'

-  return to the Oracle Universal Installer (OUI) window (on node 1) and click 'Retry'

Maclean Liu(刘相兵

尝试 ：


-  Re-enable the (non-Oracle) Windows Management Instrumentation service on the remote node(s) by setting it back to 'Automatic'

-  return to the Oracle Universal Installer (OUI) window (on node 1) and click 'Retry'

584635169

Maclean Liu(刘相兵 发表于 2014-7-27 14:14
尝试 ：

重装操作系统之后，顺利完成了安装。windows系统确实比较。。。恶心