Thursday, 16 July 2020

HDB Daemon does not start after Hana host rename failed

Problem: 

Hana host rename is attempted and failed.
Rename fails with hdbdaemon not starting.

Solution:
Hana rename generally touches the following files during rename.Give a check if it really has changed the old hostname in all the locations.

Configuring user home '/hana/shared/SID/home'
   ---------------------------------------------------------
 INFO:     /hana/shared/SID/home/.cshrc already exists -> overwriting
 INFO:     Copy /hana/shared/SID/global/hdb/install/support/CSHRC to /hana/shared/SID/home/.cshrc
 INFO:     /hana/shared/SID/home/.sapsrc.sh already exists -> overwriting
 INFO:     Copy /hana/shared/SID/global/hdb/install/support/SAPSRC.SH to /hana/shared/SID/home/.sapsrc.sh
 INFO:     /hana/shared/SID/home/.sapsrc.csh already exists -> overwriting
 INFO:     Copy /hana/shared/SID/global/hdb/install/support/SAPSRC.CSH to /hana/shared/SID/home/.sapsrc.csh
 INFO:     /hana/shared/SID/home/.bashrc already exists -> overwriting
 INFO:     Copy /hana/shared/SID/global/hdb/install/support/BASHRC to /hana/shared/SID/home/.bashrc
INFO:     /hana/shared/SID/home/.profile already exists -> overwriting
 INFO:     Copy /hana/shared/SID/global/hdb/install/support/PROFILE to /hana/shared/SID/home/.profile
 INFO:     /hana/shared/SID/home/.sapenv.csh already exists -> enhancing
 INFO:       File /hana/shared/SID/home/.sapenv.csh is up to date
 INFO:     /hana/shared/SID/home/.sapenv.sh already exists -> enhancing
 INFO:       File /hana/shared/SID/home/.sapenv.sh is up to date


INFO:   ---------------------------------------------------------

 INFO:   Updating system configuration files...
 INFO:     Updating '/hana/shared/SID/global/hdb/install/config/sapprofile.ini'
 INFO:       Value 'SAPLOCALHOST' in section '' is up to date. ('SIDhdb00')
 INFO:       Value 'DIR_PROFILE' in section '' is up to date. ('/usr/sap/SID/SYS/profile')
   File '/hana/shared/SID/global/hdb/install/config/sapprofile.ini' is up to date
 Updating '/hana/shared/SID/profile/DEFAULT.PFL'
 INFO:       File '/hana/shared/SID/profile/DEFAULT.PFL' is up to date
 INFO:   Adjusting instance...
 INFO:     Updating instance configuration files for host (SIDhdb00)...
 INFO:       Updating '/hana/shared/SID/profile/SID_HDB00_SIDhdb00'
 INFO:         File '/hana/shared/SID/profile/SID_HDB00_SIDhdb00' is up to date
 INFO:       Updating '/hana/shared/SID/HDB00/SIDhdb00/sapprofile.ini'
INFO:         File '/hana/shared/SID/HDB00/SIDhdb00/sapprofile.ini' is up to date

check the entries in /usr/sap/sapservices file. It should contain the updated entries



Option 1When the database is online or nameserver service is active, check system view M_TOPOLOGY_TREE for topology information. Run on SYSTEMDB for MDC.
SELECT * FROM M_TOPOLOGY_TREE

Option 2: When database is down, use hdbnsutil to collect topology information.

hdbnsutil -exportTopology <filename>

Option 3: From fullsysteminfodump (KBA 1732157 for FSID collection) you can read topology from topology.txt. In system replication environment topology.txt of secondary site is empty, because nameserver is not really active.

Option 4: Starting with SAP HANA 2.0 SPS 03 the topology is periodically dumped to the SAP HANA trace file directory using JSON format and the following file name notation: nameserver_topology_<host>.json


Export the topology using the command


Export:

hdbnsutil -exportTopology myExport.txt

Import:

hdbnsutil -importTopology myExport.txt

Follow snote 2606272 - HANA: How to read topology

No comments:

Post a Comment