Thursday, February 6, 2014

Error "[NS-20802] Grid Infrastructure Configuration Failed" During 11.2 RAC installation on Windows 2008R2

I faced error "[NS-20802] Grid Infrastructure Configuration Failed" during a 2 node Oracle 11.2 RAC installation on Windows 2008 R2 (64 bit). All prerequisites were checked and cluvfy also did not show any problem, but during installation,
the installation failed at the following screen (on node1 where installation was initiated.)


A snippet from the installation log is as follows.
---------------------------------------------------------------
INFO: Starting Install on nodes 'hm-cnpb-st286b' 
INFO: Saving Cluster Inventory
INFO: InstallProgressMonitor: Starting phase 512
INFO: Saving Cluster Inventory
INFO: Saving Cluster Inventory
INFO: Running command 'c:\temp\OraInstall2014-01-06_02-40-12PM\oui\bin\platform\win64\setup.exe -jreLoc c:\temp\OraInstall2014-01-06_02-40-12PM\jdk/jre -paramFile c:\temp\OraInstall2014-01-06_02-40-12PM\oui/clusterparam.ini  -silent -ignoreSysPrereqs -attachHome -noClusterEnabled ORACLE_HOME=D:\oracle\11203\grid ORACLE_HOME_NAME=OraCrs11g_home1 CLUSTER_NODES=hm-cnpb-st286a,hm-cnpb-st286b "INVENTORY_LOCATION=C:\Program Files\Oracle\Inventory" LOCAL_NODE=hm-cnpb-st286b -remoteInvocation -invokingNodeName hm-cnpb-st286a -logFilePath "C:\Program Files\Oracle\Inventory/logs" -timestamp 2014-01-06_02-40-12PM' on the nodes 'hm-cnpb-st286b'.
INFO: Deleting service 'OracleOUIOraCrs11g_home1Service' on nodes 'hm-cnpb-st286b'.
INFO: Creating service 'OracleOUIOraCrs11g_home1Service' on nodes 'hm-cnpb-st286b'.
INFO: Starting service 'OracleOUIOraCrs11g_home1Service' on nodes 'hm-cnpb-st286b'.
INFO: Stopping service OracleOUIOraCrs11g_home1Service on nodes hm-cnpb-st286b.
INFO: Deleting service 'OracleOUIOraCrs11g_home1Service' on nodes 'hm-cnpb-st286b'.
INFO: InstallProgressMonitor: Completed phase 512
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: Updating the global context
INFO: Path To 'globalcontext.xml' = D:\oracle\11203\grid\install\chainedInstall\globalcontext
INFO: Since operation was successful, move the current OiicAPISessionDetails to installed list
INFO: Number of scripts to be executed as root user = 0
INFO: isSuccessfullInstallation: true
INFO: isSuccessfullRemoteInstallation: true
INFO: Adding ExitStatus SUCCESS to the exit status set
INFO: Completed setting up crssetup
INFO: Performing Configuration
INFO: Entering ConfigClient.init method
INFO: ConfigClient.init sOracleHomeLoc=D:\oracle\11203\grid, sTopAggId=oracle.crs
INFO: Entering ConfigClient.initClientAndSession method
INFO: ConfigClient.initClientAndSession status : connected to the config framework
INFO: ConfigClient.initClientAndSession session begun oracle.sysman.emCfg.client.CfwSession@560c9447
INFO: ConfigClient.initClientAndSession m_oAggregate=[Loracle.sysman.emCfg.common.IAggregate;@53daed73
INFO: Configuration log directory - D:\oracle\11203\grid\cfgtoollogs
INFO: Exiting ConfigClient.init method
INFO: Calling event ConfigSessionInitialized
INFO: ConfigClient.registerOutErrStream method called
INFO: Updating Transient Parameters in the Aggregates
INFO: Updating Transient Parameters for oracle.crs
INFO: Updating Transient Parameters for oracle.assistants.netca.client
INFO: Updating Transient Parameters for OuiConfigVariables
INFO: Updating Transient Parameters for oracle.assistants.asm
INFO: Setting value to transient variable S_ASMMONITORPASSWORD
INFO: Setting value to transient variable S_ASMPASSWORD
INFO: Setting value to transient variable s_asmcaArgs
INFO: Setting value to transient variable s_ASMPasswordFlag
INFO: Setting value to transient variable s_ASMMonitorPasswordFlag
INFO: Successfully updated Transient Parameters in the Aggregates
INFO: Entering ConfigClient.getToolsList method
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 - D:\oracle\11203\grid\cfgtoollogs
INFO: 
 The Runconfig command constructed is D:\oracle\11203\grid\oui\bin\runConfig.bat ORACLE_HOME=D:\oracle\11203\grid MODE=perform ACTION=configure RERUN=true $*
INFO: Created a new file D:\oracle\11203\grid\cfgtoollogs\configToolAllCommands
INFO: Since the option is to overwrite the existing D:\oracle\11203\grid\cfgtoollogs\configToolAllCommands file, backing it up
INFO: The backed up file name is D:\oracle\11203\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;@353d9906
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-01-06 14:55:16: Checking for super user privileges
INFO: 2014-01-06 14:55:16: superUser=$app-hkdl-oracle-svc groupName=Administrators
INFO: 2014-01-06 14:55:16: domain=APAC user=$APP-HKDL-ORACLE-SVC
INFO: 2014-01-06 14:55:16: D:\oracle\11203\grid\bin\crssetup.exe getsystem
INFO: 2014-01-06 14:55:16: Executing cmd: D:\oracle\11203\grid\bin\crssetup.exe getsystem
WARNING: Parameter ORACLE_OWNER not defined at D:\oracle\11203\grid\crs\install/crsconfig_lib.pm line 12044.
INFO: 2014-01-06 14:55:16: Command output:
INFO: >  SYSTEM 
INFO: >End Command output
INFO: 2014-01-06 14:55:16: User has $app-hkdl-oracle-svc privileges
INFO: Using configuration parameter file: D:\oracle\11203\grid\crs\install\crsconfig_params
WARNING: 
INFO: 
INFO: Completed Plugin named: Grid Infrastructure Configuration
INFO: Grid Infrastructure Configuration failed.
INFO: Grid Infrastructure Configuration failed.
INFO: ConfigClient.executeToolsInAggregate action performed
INFO: Exiting ConfigClient.executeToolsInAggregate method
INFO: Calling event ConfigToolsExecuted
INFO: 
 The Runconfig command constructed is D:\oracle\11203\grid\oui\bin\runConfig.bat ORACLE_HOME=D:\oracle\11203\grid MODE=perform ACTION=configure RERUN=false $*
INFO: Created a new file D:\oracle\11203\grid\cfgtoollogs\configToolFailedCommands
INFO: Since the option is to overwrite the existing D:\oracle\11203\grid\cfgtoollogs\configToolFailedCommands file, backing it up
INFO: The backed up file name is D:\oracle\11203\grid\cfgtoollogs\configToolFailedCommands.bak
WARNING: readme.txt file doesn't exits
INFO: ConfigClient.saveSession method called
INFO: Calling event ConfigSessionEnding
INFO: ConfigClient.endSession method called
INFO: Completed Configuration
INFO: Shutting down OUISetupDriver.JobExecutorThread
INFO: Cleaning up, please wait...
INFO: Dispose the install area control object
INFO: Update the state machine to STATE_CLEAN
INFO: All forked task are completed at state setup
INFO: Completed background operations
INFO: Moved to state <setup>
--------------------------------------------------------------------------

As can be seen above, there wasn't any ERROR message in the installation log files (installActions<Date_Time>.log) on either of the nodes, but, there was a WARNING "WARNING: Parameter ORACLE_OWNER not defined at D:\oracle\11203\grid\crs\install/crsconfig_lib.pm line 12044" in the log file of node 1 (please see above log snippet). Even though there wasn't any error message on node2 log file, but there was a message (INFO: Checkpoint:Failed Checkpoint found returning it for getAllFailedCheckPoints) which was not much clear.  

Based on the WARNING message on node 1, I had a hint that there could be something wrong with the OS user which is performing this installation

Solution
Actually the OS user name which I was using for this installation (domain user which was part of local Administrator group) was starting with a dollar sign i.e "$MY_USER_NAME" and this was the actual problem. Once we created a new OS user without $ sign as first letter, all went fine and I was able to perform a successful installation.
I have experienced same error being returned if username starts with a number.

Note
Remember; that in my case, $ sign was first character of the OS user I was using. If you have $ sign or any other special character or a number as first character or anywhere in the OS user name and you face this problem, you can consider creating a new user without any special character or a number as the first character of the username.
I contacted Oracle support but they also did not mentioned any restriction of this type, and until now (while I am writing this post), there is no official document available at MOS which explains this restriction of OS user name.
A similar type of issue is discussed here where OS username started with a number.

1 comment:

Nickos Gr said...

Oracle attempt to use your current Windows domain credentials to authenticate you with the oracle server.
This could fail the oracle server is not configured to support Windows authentication
or the credentials you use to login to your local machine are not sufficient to allow you to login to the server.
I had the same problem during installing grid 11g 2 (11.2.0.1 -11.2.0.4). The domain user was added to local admin group but that does not mean that had automatic admin privileges.
After 4 days inside asmca.log there was an error (ORA-12638….).Booooom…Kerberos authentication problem…
I try to change SQLNET.AUTHENTICATION_SERVICES= (NTS) to SQLNET.AUTHENTICATION_SERVICES= (NONE)…
But every time i was hitting the retry button the installer was reverting the value on the file sqlnet.ora to (NTS)…
So i decide to run the installer as local administrator…..
BOOOOOOOM….. Finally the installation of grid 11g r2 ended with no errors!!!!!!!!!
Just a couple days i was reading about the same problem (i cannot remember the site) and someone suggested
to add the DES ciphers to “Network security: Configure encryption types allowed for Kerberos” inside
“Computer Configuration\Policies\Windows Settings\Security Settings\Local Policies\Security Options”…
I have not tried that solution yet, but if someone is willing to try please let us now….

Popular Posts - All Times