Skip to Content

Virtual DB hostname not displayed in DBACOCKPIT

Hello,

We have installed several HANA Databases (SPS12.0 and SPS11.2) and different SAP systèmes have been connected : S/4 HANA , SAP ECC EhP8.

The HANA Database is always running on its own server, and the SAP system running on its distinct server.

The SAP system has been connected to HANA through its Virtual IP adress.

For example we just installed a HANA Database on its physical IP adress sapt01hana1

The Virtual IP adress of the HANA server is hanatest

The SAP Netweaver system has been installed and conencted to HANA through its virtual IP adress : hanatest


In hdbusersore there is no mention whatsoever of the physical hostname ,only the virtual hostname

sapt01d01:t01adm 59> hdbuserstore LIST

DATA FILE : /home/t01adm/.hdb/sapt01d01/SSFS_HDB.DAT

KEY FILE : /home/t01adm/.hdb/sapt01d01/SSFS_HDB.KEY

KEY DEFAULT

ENV : hanatest:30015

USER: SAPECC


In the DEFAULT profile, the virtual hostname of the DB has been configured during the installation :

SAPDBHOST = hanatest

Connection from SAP system to virtual hostname of the DB works fine

hdbsql=> \c -n hanatest -i 00 -u SAPECC -p Mypassword

Connected to QHA@sapt01hana1.****.com:30015

I checked with netstat and SAP system is communicating with its DB through the virtual IP adress only

But in SAP screens, only the physical hostname of the DB is displayed, not the virtual hostname :

Here a screenshot of DBACOCKPIT, or System---|Statut.

I do not understand why the virtual hostname is not being picked up

I checked DBCO entries : there was no DEFAULT entry, so I created one pointing to the virtual hostname it did not change anything

Thank you for your attention

DEFAULT.gif (40.9 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Jul 21, 2016 at 12:16 AM

    Hi Raoul,

    This situation is normal. In my case, one application connects to HANA virtual hostname, where HANA is configured in system replication mode. After performing take over, the hostname shows the physical hostname of new primary.

    I just guess the hostname in DBACOCKPIT is get from hostname command in OS.

    Regards,

    Ning

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi,

      In addition to what Ning described, the DEFAULT entry is the actual DEFAULT key from your hdbuserstore.

      So the connection is probably resolving the virtual name to the actual name (maybe an nslookup would show that) and the value is kept within abap kernel modules in global variables.

      Regards,

      Lucas de Oliveira

  • Posted on Jul 21, 2016 at 02:17 PM

    Thank you Ning and Lucas !

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.