How to Rename SAP HANA Database Hostname

1. Login to the HANA database server as root and switch to the below directory.

# cd /hana/shared/SID/hdblcm/

2. Execute the HDBLCM command. Choose 9 (rename_system) to rename the SAP HANA database system.

# ./hdblcm

SAP HANA Lifecycle Management - SAP HANA Database 2.00.024.04.1530240705
************************************************************************

Choose an action

  Index | Action                     | Description
  ------------------------------------------------------------------------------------------
  1     | add_host_roles             | Add Host Roles
  2     | add_hosts                  | Add Hosts to the SAP HANA Database System
  3     | check_installation         | Check SAP HANA Database Installation
  4     | configure_internal_network | Configure Inter-Service Communication
  5     | configure_sld              | Configure System Landscape Directory Registration
  6     | extract_components         | Extract Components
  7     | print_component_list       | Print Component List
  8     | remove_host_roles          | Remove Host Roles
  9     | rename_system              | Rename the SAP HANA Database System
  10    | uninstall                  | Uninstall SAP HANA Database Components
  11    | unregister_system          | Unregister the SAP HANA Database System
  12    | update_component_list      | Update Component List
  13    | update_components          | Install or Update Additional Components
  14    | update_host                | Update the SAP HANA Database Instance Host integration
  15    | exit                       | Exit (do nothing)

Enter selected action index [15]: 9

3. Enter the required information as required. When comes to Enter Target Host Name for Source Host, put in the new hostname.

Local Host Name: OLD-HOSTNAME

System Properties:
SID /hana/shared/SID HDB_ALONE
        HDB15
        version: 2.00.024.04.1530240705
        host: OLD-HOSTNAME (Database Worker (worker))
        edition: SAP HANA Database

Enter Target Host Name for Source Host 'OLD-HOSTNAME' [OLD-HOSTNAME]: NEW-HOSTNAME

4. Define the system usage. We choose 3 as this is our development system.

  Index | System Usage | Description
  -------------------------------------------------------------------------------
  1     | production   | System is used in a production environment
  2     | test         | System is used for testing, not production
  3     | development  | System is used for development, not production
  4     | custom       | System usage is neither production, test nor development

Select System Usage / Enter Index [3]: 

5. Define below information as per your system requirement. Other setting should be the same as we are only changing the database hostname.

  Index | Listen Interface | Description
  -----------------------------------------------------------------------------------------------
  1     | global           | The HANA services will listen on all network interfaces
  2     | internal         | The HANA services will only listen on a specific network interface
  3     | local            | The HANA services will only listen on loopback interface (127.0.0.1)
The recommended value for single-host system is 'local'
Select Listen Interface / Enter Index [3]: 
Enter Certificate Host Name For Host 'NEW-HOSTNAME' [OLD-HOSTNAME]: NEW-HOSTNAME
Enter Source System Administrator (sidadm) Password: 
Enter Target System ID [SID]: 
Enter Target Instance Number [15]: 
Enter Location of Data Volumes [/hana/data/SID]: 
Enter Location of Log Volumes [/hana/log/SID]: 
Enter Location of Data Backups [/hana/shared/SID/HDB15/backup/data]: 
Enter Location of Log Backups [/hana/shared/SID/HDB15/backup/log]: 
Enter Location of Catalog Backups [/hana/shared/SID/HDB15/backup/log]: 
Change the password of the System Database user [n]: 
Restart system after machine reboot? [n]: 

6. Review the summary before you proceed with the execution.

Summary before execution:
=========================

SAP HANA Database
   Rename Parameters
      Installation Path: /hana/shared
      Source System ID: SID
      Target System ID: SID
      Target Instance Number: 15
      Remote Execution: ssh
      Host Name: OLD-HOSTNAME -> NEW-HOSTNAME
      System Usage: development
      Listen Interface: local
      Certificate Host Names: NEW-HOSTNAME -> NEW-HOSTNAME
      Location of Data Volumes: /hana/data/SID
      Location of Log Volumes: /hana/log/SID

Note: SAP HANA Database System will be restarted

7. Press Y to continue. The renaming process will run and will take only few minutes.

Do you want to continue? (y/n): 

Renaming System...
  SAP HANA Lifecycle Management - Database Rename  2.2.43
  Renaming instance...
  Stopping system...
    Stopping 7 processes on host 'OLD-HOSTNAME' (worker):
      Stopping on 'OLD-HOSTNAME': hdbcompileserver, hdbdaemon, hdbindexserver, hdbnameserver, hdbpreprocessor, hdbwebdispatcher, hdbxsengine
    All server processes stopped on host 'OLD-HOSTNAME' (worker).
  Stopping sapstartsrv service...
  Removing sapservices entry...
  Updating system configuration files...
  Renaming instance...
  Configuring environment scripts...
  Creating sapservices entry...
  Starting service (sapstartsrv)...
  Starting instance SID (HDB15) on host 'NEW-HOSTNAME'...
  Starting 7 processes on host 'NEW-HOSTNAME' (worker):
      Starting on 'OLD-HOSTNAME': hdbcompileserver, hdbdaemon, hdbindexserver, hdbnameserver, hdbpreprocessor, hdbwebdispatcher, hdbxsengine
      Starting on 'OLD-HOSTNAME': hdbcompileserver, hdbdaemon, hdbindexserver, hdbpreprocessor, hdbwebdispatcher, hdbxsengine
      Starting on 'OLD-HOSTNAME': hdbdaemon, hdbindexserver, hdbwebdispatcher, hdbxsengine
      Starting on 'OLD-HOSTNAME': hdbdaemon, hdbwebdispatcher, hdbxsengine
      Starting on 'OLD-HOSTNAME': hdbdaemon, hdbwebdispatcher
    All server processes started on host 'NEW-HOSTNAME' (worker).
  Registering Instance Service...
  Updating Component List...
Updating SAP HANA Database Instance Integration on Local Host...
  Regenerating SSL certificates...
  Deploying SAP Host Agent configurations...
SAP HANA Database System renamed
You can send feedback to SAP with this form: https://NEW-HOSTNAME:1129/lmsl/HDBLCM/SID/feedback/feedback.html
Log file written to '/var/tmp/hdb_SID_hdblcm_rename_system_2018-10-15_00.52.33/hdblcm.log' on host 'OLD-HOSTNAME'.

8. Once done, review the log for execution success confirmation. You can bring up your SAP HANA database.

Note

If you have SAP application installed on top of the SAP HANA database, please consider changing the profiles, environment etc.

You May Also Like

Leave a Reply?