HANA Tenant DB Port Change

[Former Member]

Hi Experts

I am new to SAP HANA MDC concept and now in a trouble.

We have installed HANA SP09 REV96. Initially we have created one tenant and found it was created on one of the appliance host. After reading SAP Help document we then found that we need to execute command specifying both nodes.

Then we created one more tenant w/o mentioning preferred port but with proper server details. It was created successfully and we installed SAP BW on top of that.

Now we noticed that index servers of 2nd Tenant DB has different ports on 2 appliances host (as one of the host already hosting one Tenant DB before we created 2nd tenant).

So we want to change the port on one of the host to make thing homogeneous. We have dropped that 1st Tenant DB and restarted HANA DBs but still those ports have diff values on different host.

Please guide me how can I fix this issue?

Correct / Helpful answer will be rewarded.

Regards

Partha

[sadanand_bhat]

Hello Partha,

Refer CREATE DATABASE - SAP HANA SQL and System Views Reference - SAP Library

which talks about how to specify and host and port details for creating tenant databases.

Hope this helps!

Regards,

Saddy

[Former Member]

Check the SCN link below.

http://scn.sap.com/community/it-management/alm/software-logistics/blog/2015/01/08/hana-mdc-using-mul...

With MDC, HANA assigns the port automatically.