SQL Ports for HANA 2.0 to connect system database and tenant database

 in MDC, hdbuserstore keys need to be set based on the SQL port.

• Keys for Systemdb must be set using SQL port 3<02>13
• Keys for Tenant DB must be set using SQL port 3<02>13@<Tenant_DB>

here <02> is instance number.

Determine Ports for SAP HANA Cockpit and Cockpit Manager

 The ports for SAP HANA cockpit and the cockpit manager can be determined in the XS console after the cockpit installation.

Prerequisites

• You are logged in as <sid>adm user.
• You know the XS organization manager user password. The password matches the master password, which is set during installation.

Context

Ports, through which the SAP HANA cockpit and the cockpit manager can be accessed, are assigned automatically by the installer. Once the cockpit installation is successfully completed, information about host and ports is displayed. If this information is no longer available, you can execute the following commands in the XS console to determine ports.

You can also assign free ports to SAP HANA cockpit during installation. For more information, see SAP Note 2389709 in Related Information.

Procedure

1. Change to the directory that contains the XS Advanced installation:

   cd <sapmnt>/<SID>/xs/bin

   By default, <sapmnt> is /hana/shared.
2. Log on to the SAP HANA XS advanced runtime. To do this, use the following command:

   ./xs-admin-login

3. Enter the XS organization manager user password.
4. Display a list of the applications running in the current space. In the command shell, run the following command:

   xs apps

   A list of all running apps is displayed. Information on host and ports are displayed in the urls column. The SAP HANA cockpit is listed as cockpit-web-app. The cockpit manager is listed as cockpit-admin-web-app.

   Output Code

   Getting apps in org "HANACockpit" / space "SAP" as COCKPIT_ADMIN...
   Found apps:
   
   name                      requested state   instances   memory    disk          urls
   ----------------------------------------------------------------------------------------------------------------------
   auditlog-db               STOPPED           0/1         16.0 MB   <unlimited>   <none>
   auditlog-server           STARTED           1/1         256 MB    <unlimited>   https://<hostname>:51002
   auditlog-broker           STARTED           1/1         64.0 MB   <unlimited>   https://<hostname>:51003
   deploy-service            STARTED           1/1         280 MB    <unlimited>   https://<hostname>:51004
   auditlog-odata            STARTED           1/1         128 MB    <unlimited>   https://<hostname>:51005
   component-registry-db     STOPPED           0/1         16.0 MB   <unlimited>   <none>
   auditlog-ui               STARTED           1/1         64.0 MB   <unlimited>   https://<hostname>:51007
   product-installer         STARTED           1/1         256 MB    <unlimited>   https://<hostname>:51006
   hrtt-service              STARTED           1/1         512 MB    <unlimited>   https://<hostname>:51009
   sqlanlz-svc               STARTED           1/1         256 MB    <unlimited>   https://<hostname>:51010
   sqlanlz-ui                STARTED           1/1         128 MB    <unlimited>   https://<hostname>:51011
   hrtt-core                 STARTED           1/1         512 MB    <unlimited>   https://<hostname>:51012
   sapui5_fesv2              STARTED           1/1         256 MB    <unlimited>   https://<hostname>:51015
   sapui5_fesv3              STARTED           1/1         256 MB    <unlimited>   https://<hostname>:51025
   cockpit-adminui-svc       STARTED           1/1         128 MB    <unlimited>   https://<hostname>:51022
   cockpit-collection-svc    STARTED           1/1         768 MB    <unlimited>   https://<hostname>:51016
   cockpit-hdb-svc           STARTED           1/1         768 MB    <unlimited>   https://<hostname>:51018
   cockpit-hdbui-svc         STARTED           1/1         128 MB    <unlimited>   https://<hostname>:51020
   cockpit-landscape-svc     STARTED           1/1         128 MB    <unlimited>   https://<hostname>:51019
   cockpit-persistence-svc   STARTED           1/1         768 MB    <unlimited>   https://<hostname>:51017
   cockpit-telemetry-svc     STARTED           1/1         768 MB    <unlimited>   https://<hostname>:51026
   cockpit-xsa-svc           STARTED           1/1         768 MB    <unlimited>   https://<hostname>:51024
   cockpit-admin-web-app     STARTED           1/1         128 MB    <unlimited>   https://<hostname>:51023
   cockpit-web-app           STARTED           1/1         512 MB    <unlimited>   https://<hostnam

SAP HANA COCKPIT Notes 5: HOW to find SAP HANA COCKPIT AND COCKPIT MANAGER ports in HANA cockpit installed system

HOW to find SAP HANA COCKPIT AND COCKPIT MANAGER ports

Once the cockpit installation is successfully completed, information about host and ports is displayed. If this information is no longer available, you can execute the following commands in the XS console to determine ports.