Wednesday, 19 February 2020

How to install HANA license by OS command

How to install HANA license by OS command

For single container system, you can follow below steps to install the license directly.

While for MDC system, you have to decide where the license needs to be installed. Generally, install system level license, you need to connect to system database.

And for tenant level license, you can connect to the specific tenant database to perform below steps.



1.Logon as sidadm user, connect to the Database via hdbsql.

For single container system, please try below command:

> hdbsql -n <hostname>:3<instance no.>15 -i <instance no.> -u <DB username> -p <password>


For MDC system, please try connecting to the system DB by below command:

> hdbsql -n <hostname>:3<instance no.>13 -i <instance no.> -u <DB username> -p <password>

To install license in a specific tenant, please maintain the SQL port of the tenant DB in the command accordingly.

> hdbsql -n <hostname>:3<instance no.><tenant SQL port> -i <instance no.> -u <DB username> -p <password>


2.Enable multiline mode in hdbsql


    hdbsql <DB name>=> \mu

3.Enter statement  
       SET SYSTEM LICENSE ‘<License File content>’

Please note to add quotation mark outside the content of the license file you just downloaded.


4.Execute the statement by command: \g

     hdbsql <DB name>=> \g




Remarks:
Install the new license via hdbsql cannot replace the old license. Please consider to delete the old license key before installing the new one.
You can also delete license keys by executing the SQL statement UNSET SYSTEM LICENSE ALL.

No comments:

Post a Comment

How to Manually Disable SAML 2.0 for SAP URL

 SAML 2.0 authentication is enabled in an AS ABAP system, but for some particular ICF services, you want to disable the SAML 2.0 authenticat...