on 05-30-2016 7:58 AM
Hi,
I tried to add host into my existing HANA system, but received below errors:
Header 1 |
---|
06: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
Thanks 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 c9t22875.ijsc.testcorp.net 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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
As was already suggested by Michael, have you followed the pre reqs ?
When adding hosts you should make sure the following files are aligned on all hosts.
/etc/hosts
/etc/passwd
/etc/shadow
/etc/services.
Have you tried to logon as "root" , "sapadm" and "tdbadm" on both hosts with the password you are using ? By this I mean you ssh directly to both hosts and logon with each of the users with the password you are proving hdblcm/hdbaddhost.
Please eliminate that first and then look at "not assigned to a local network interface" you encountered in attempt #2.
KR,
Amerjit
Hi Chong,
This is permission issue. .Try using sidadm userid and password
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I'm on RHEL 6.7, with HANA SPS10 installation, i will try the above as suggested and update.
Thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Kok Hoo,
Just for further analysis could you upload your: /var/tmp/hdb_TDB_hdblcm_add_hosts_2016-05-30_06.27.42/hdbmodify_addhosts.log.
The reason I asked your RHEL version was I had a problem on RHEL6.6 which meant I also had to do it with hdbaddhost as opposed to hdblcm and I also had no luck getting it to work with saphostagent.
As already suggested by Williams please execute hdbaddhost on the host where you want to install the worker node.
Let us know how you get on.
KR,
Amerjit
HDBLCM uses ssh between 2 nodes, if it's not set for your root user, then this error occurs.
I had this too in past, once ssh keys between 2 nodes were set, i did not had any issues.
Please get it done with your OS team, if you don't have authorizations of doing it.
Did you tried above SAP note ? If you are using hdbaddhost, that note should resolve your issue?
Hello Kok Hoo,
Are you on SUSE or on RHEL ?
KR,
A.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
Please make sure you have met the pre reqs from
http://help.sap.com/hana/SAP_HANA_Administration_Guide_en.pdf
Page 512.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.