Hana DB switch for DR setup

[former_member1242819]

Hello Experts,

I have a few questions related to the HANA DR setup.

In our landscape the HANA Primary and Secondary instance was not installed using any Virtual hostname. I understand that to be able to switch to the secondary site all we need to do is perform a take over and stop replication on the Primary. My question here is how do we make the application server connect to the Secondary Hana DB. Changing only the SAPDBHOST parameters in the DEFAULT.PFL will not help.Please let me know what else needs to be changed.

Regards,

Raj

[Former Member · Accepted solution]

I think the problem you have is that the application server is pointing against the primary.

If you run hdbuserstore list you sould se what it uses to conect to the HANA

DATA FILE       : /home/prdadm/.hdb/xxxxxxx/SSFS_HDB.DAT

KEY DEFAULT

ENV : xxxx.acme.com:XXXXX

USER: XXXXXX

You can change it with:

hdbuserstore SET <KEY><ENV> <USERNAME> <PASSWORD>

For more information see:

hdbuserstore Commands - SAP HANA Security Guide - SAP Library

Hope it's a little help on the way

//Tommy

[former_member1242819 · Accepted solution]

Thank you Tommy.

Best Regards,

Raj