Skip to Content
avatar image
Former Member

Add host failed

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • 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
    10|10000 characters needed characters exceeded

  • 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
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 30, 2016 at 07:57 PM

    Hello Kok Hoo,

    Are you on SUSE or on RHEL ?

    KR,

    A.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 30, 2016 at 11:24 PM

    Hi,

    I'm on RHEL 6.7, with HANA SPS10 installation, i will try the above as suggested and update.

    Thanks.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Anand Tigadikar

      Anand,

      If you read the thread you will find I am *not* the person who asked the question. I am replying to Kok Hoo.

      If you have suggestions for him could you kindly reply to him as opposed to me.

      KR,

      A.

  • May 31, 2016 at 06:08 AM

    Hi Chong,

    This is permission issue. .Try using sidadm userid and password

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 31, 2016 at 06:49 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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