Hi,
I tried to add host into my existing HANA system, but received below errors:
Header 106:28:21.600 - INFO: -----------------------------------------------------------
06:28:21.600 - INFO: Adding additional host to SAP HANA Database...
06:28:21.600 - INFO: -----------------------------------------------------------
06:28:21.601 - INFO: Starting external program /hana/shared/TDB/global/hdb/install/bin/hdbmodify
06:28:21.601 - INFO: Command line is: /hana/shared/TDB/global/hdb/install/bin/hdbmodify -b --instlog_dir=/var/tmp/hdb_TDB_hdblcm_add_hosts_2016-05-30_06.27.42 --addhosts=c9t22875:role=worker:group=default --sid=TDB --nostart=0 --root_user=root --sapmnt=/hana/shared --install_ssh_key=1 --skip_hostagent_password=1 --remote_execution=ssh --install_hostagent=1 --read_password_from_stdin=xml
06:28:23.177 - INFO: Output line 1:
06:28:23.177 - INFO: Output line 2:
06:28:23.177 - INFO: Output line 3: SAP HANA Lifecycle Management - hdbmodify_addhosts 1.00.102.02.1446663129
06:28:23.177 - INFO: Output line 4: **************************************************************************
06:28:23.177 - INFO: Output line 5:
06:28:23.274 - INFO: Output line 6:
06:28:23.274 - INFO: Output line 7: System Properties:
06:28:23.274 - INFO: Output line 8: TDB /hana/shared/TDB HDB_ALONE
06:28:23.274 - INFO: Output line 9: HDB01
06:28:23.274 - INFO: Output line 10: version: 1.00.102.02.1446663129
06:28:23.275 - INFO: Output line 11: host: c9t22874.ijsc.testcorp.net (Database Worker (worker))
06:28:23.275 - INFO: Output line 12:
06:28:23.804 - INFO: Output line 13: Start reading from input channel...
06:28:23.810 - INFO: Output line 14: ... Done.
06:28:23.847 - INFO: Output line 15: Modifying configuration of SAP HANA System 'TDB'...
06:28:23.868 - INFO: Output line 16:
06:28:23.869 - INFO: Output line 17: Summary before execution:
06:28:23.869 - INFO: Output line 18: Installation Path: /hana/shared
06:28:23.869 - INFO: Output line 19: SAP HANA System ID: TDB
06:28:23.869 - INFO: Output line 20: Additional Hosts: c9t22875:role=worker:group=default
06:28:23.869 - INFO: Output line 21: Enable the installation or upgrade of the SAP Host Agent: Yes
06:28:23.869 - INFO: Output line 22: Remote Execution: ssh
06:28:23.869 - INFO: Output line 23: Root User Name: root
06:28:23.869 - INFO: Output line 24:
06:28:23.873 - INFO: Output line 25: Adding additional host...
06:28:23.895 - INFO: Output line 26: Adding host 'c9t22875'...
06:28:26.616 - INFO: Output line 27: Reconfiguring SAP HANA system failed!
06:28:26.617 - INFO: Output line 28: Add hosts:
06:28:26.617 - INFO: Output line 29: Creating a multiple host system failed
06:28:26.617 - INFO: Output line 30: Adding host 'c9t22875' failed!
06:28:26.618 - INFO: Output line 31: Add host failed
06:28:26.618 - INFO: Output line 32: Running in batch mode
06:28:26.618 - INFO: Output line 33: Wrong password
06:28:26.618 - INFO: Output line 34: AccessCheck request failed: Permission denied
06:28:26.619 - INFO: Output line 35:
06:28:26.642 - INFO: Output line 36: Log file written to '/var/tmp/hdb_TDB_hdblcm_add_hosts_2016-05-30_06.27.42/hdbmodify_addhosts.log' on host 'c9t22874.ijsc.testcorp.net'.
06:28:26.891 - INFO: Program terminated with exit code 1
06:28:26.892 - INFO: -----------------------------------------------------------
06:28:26.892 - INFO: END: End adding additional host to SAP HANA Database (start: 06:28:21.600 duration: 00:00:05.292)
06:28:26.892 - INFO: -----------------------------------------------------------
06:28:27.886 - ERR : Addition of hosts to the SAP HANA system failed.
06:28:28.038 - INFO: Summary of critical errors
06:28:27.886 - ERR : Addition of hosts to the SAP HANA system failed.
06:28:26.895 - ERR : Error occurred while executing Add Additional Hosts to SAP HANA System.
06:28:26.893 - INFO: Reconfiguring SAP HANA system failed!
06:28:26.893 - INFO: Add hosts:
06:28:26.894 - INFO: Creating a multiple host system failed
06:28:26.894 - INFO: Adding host 'c9t22875' failed!
06:28:26.894 - INFO: Add host failed
06:28:26.894 - INFO: Running in batch mode
06:28:26.894 - INFO: Wrong password
06:28:26.895 - INFO: AccessCheck request failed: Permission denied
It seems like failed with wrong password, I tried so many ways including configure root ssh equivalent, changing root password, setup saphostagent in the new node and install with --remote_execution=saphostagent, but nothing work, appreciate if anyone can help here.
Thanks
regards
6 Answers
-
Posted on May 30, 2016 at 12:44 PM
Hello,
Please make sure you have met the pre reqs from
http://help.sap.com/hana/SAP_HANA_Administration_Guide_en.pdf
Page 512.
Add comment
-
Posted on May 30, 2016 at 03:00 PM
Hello Kok,
The OS user are manage locally i presume, please remove the saphostagent on the host that you want to add, clean up the the /usr/sap/hostagent folder.
Also check if the <sidadm> exist on the additional host, if yes remove it.
Once the check done, from the host you wants to add go to the /hana/shared/TDB/global/hdb/install/bin and run the ./hdbaddhost script with the root user.
Please let know the result
Williams
Add comment
-
Posted on May 31, 2016 at 06:08 AM
Hi Chong,
This is permission issue. .Try using sidadm userid and password
Add comment
-
Former MemberPosted on May 31, 2016 at 06:49 AMThanks for all the replies, I have tested all as suggested, but no luck I'm still not able to add host, same error message, below are few tries i performed:
Header 1===========
1st Tried:
===========
/hana/shared/TDB/hdblcm/hdblcm
SAP HANA Lifecycle Management - SAP HANA 1.00.102.02.1446663129
***************************************************************
Choose an action to perform
Index | Action to be performed | Description
--------------------------------------------------------------------------------------
1 | add_hosts | Add Additional Hosts to the SAP HANA System
2 | configure_internal_network | Configure Inter-Service Communication
3 | configure_sld | Configure System Landscape Directory Registration
4 | print_component_list | Print Component List
5 | rename_system | Rename the SAP HANA System
6 | uninstall | Uninstall SAP HANA Components
7 | unregister_system | Unregister the SAP HANA System
8 | update_component_list | Update Component List
9 | update_components | Install or Update Additional Components
10 | update_host | Update the SAP HANA Instance Host integration
11 | exit | Exit (do nothing)
Enter selected action index [11]: 1
System Properties:
TDB /hana/shared/TDB HDB_ALONE
HDB01
version: 1.00.102.02.1446663129
host: c9t22874.ijsc.testcorp.net (Database Worker (worker))
Enter comma-separated host names to add: c9t22875
Enter Root User Name [root]:
Collecting information from host 'c9t22875'...
Information collected from host 'c9t22875'.
Select roles for host 'c9t22875':
Index | Host Role | Description
-------------------------------------------------------------------
1 | worker | Database Worker
2 | standby | Database Standby
3 | extended_storage_worker | Dynamic Tiering Worker
4 | extended_storage_standby | Dynamic Tiering Standby
5 | streaming | Smart Data Streaming
6 | rdsync | Remote Data Sync
7 | ets_worker | Accelerator for SAP ASE Worker
8 | ets_standby | Accelerator for SAP ASE Standby
Enter comma-separated list of selected indices [1]:
Enter Host Failover Group for host 'c9t22875' [default]:
Enter Storage Partition Number for host 'c9t22875' [<<assign automatically>>]:
Enter System Administrator (tdbadm) Password:
Unknown user password combination
Enter System Administrator (tdbadm) Password:
Enter SAP Host Agent User (sapadm) Password:
Confirm SAP Host Agent User (sapadm) Password:
Enter Certificate Host Name For Host 'c9t22875' [c9t22875]:
Summary before execution:
=========================
Add Additional Hosts to SAP HANA System
Add Hosts Parameters
Remote Execution: ssh
Enable the installation or upgrade of the SAP Host Agent: Yes
Install SSH Key: Yes
Root User Name: root
Do not start added hosts and do not start SAP HANA System: No
Certificate Host Names: c9t22875 -> c9t22875
Additional Hosts
c9t22875
Role: Database Worker (worker)
High-Availability Group: default
Storage Partition: <<assign automatically>>
Do you want to continue? (y/n): y
Adding additional host to SAP HANA Database...
Adding additional host...
Adding host 'c9t22875'...
Creating a multiple host system failed
Adding host 'c9t22875' failed!
Addition of hosts to the SAP HANA system failed.
Error occurred while executing Add Additional Hosts to SAP HANA System.
Reconfiguring SAP HANA system failed!
Add hosts:
Creating a multiple host system failed
Adding host 'c9t22875' failed!
Add host failed
Running in batch mode
Wrong password
AccessCheck request failed: Permission denied
You can send feedback to SAP with this form: https://c9t22874.ijsc.testcorp.net:1129/lmsl/HDBLCM/TDB/feedback/feedback.html
Log file written to '/var/tmp/hdb_TDB_hdblcm_add_hosts_2016-05-30_23.29.08/hdblcm.log' on host 'c9t22874.ijsc.testcorp.net'.
===========
2nd Tried:
===========
./hana/shared/TDB/global/hdb/install/bin/hdbaddhost
Enter Local Host Name [c9t22874.ijsc.testcorp.net]: c9t22875.ijsc.testcorp.net
IP address '16.250.26.51' (host 'c9t22875.ijsc.testcorp.net') is not assigned to a local network interface
I can't proceed further as i have above errors.
===========
3rd Tried:
===========
I follow SPS12 administration guide by adding the host with SAP host agent, I follow below steps:
- I downloaded the agent file - SAPHOSTAGENT10_10-20009394.SAR
- successfully extract it with SAPCAR
- installed agent
- saphostexec -status shows the agent running
- I have complete the configuration of SSL certificate and the HTTPS port is accessible
- run ./hdblcm --remote_execution=saphostagent
The same errors:
Summary before execution:
=========================
Add Additional Hosts to SAP HANA System
Add Hosts Parameters
Remote Execution: saphostagent
Enable the installation or upgrade of the SAP Host Agent: Yes
Do not start added hosts and do not start SAP HANA System: No
Certificate Host Names: c9t22875.ijsc.testcorp.net -> c9t22875.ijsc.testcorp.net
Additional Hosts
Role: Database Worker (worker)
High-Availability Group: default
Storage Partition: <<assign automatically>>
Do you want to continue? (y/n): y
Adding additional host to SAP HANA Database...
Adding additional host...
Adding host 'c9t22875.ijsc.testcorp.net'...
Creating a multiple host system failed
Adding host 'c9t22875.ijsc.testcorp.net' failed!
Addition of hosts to the SAP HANA system failed.
Error occurred while executing Add Additional Hosts to SAP HANA System.
Reconfiguring SAP HANA system failed!
Add hosts:
Creating a multiple host system failed
Adding host 'c9t22875.ijsc.testcorp.net' failed!
Add host failed
Configuration error (batch mode):
Wrong password
AccessCheck request failed: Permission denied
===========
4th Tried:
===========
I'm also checked note 927637, my file has the correct permission and owner set, nosuid is not set on mount point layer:
ls -l /usr/sap/hostctrl/exe/sapuxuserchk
-rwsr-x--- 1 root sapsys 722030 May 20 03:03 /usr/sap/hostctrl/exe/sapuxuserchk
df -h /usr/sap/hostctrl/exe
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/vg00-usr 4.9G 3.8G 918M 81% /usr
/dev/mapper/vg00-usr on /usr type ext4 (rw)
I have the SSH equivalent setup for root on the existing system and new server, i can ssh back and forth between servers without needed password.
I got strong feel this is due to the sticky bit on sapuxuserchk though I'm still try to figure out how to get around it.
Any suggestion would highly appreciate.
Thanks
Chong
Add comment
Add comment