SapHanaTutorial.Com HOME     Learning-Materials Interview-Q&A Certifications Quiz Online-Courses Forum Jobs Trendz FAQs  
     Explore The World of Hana With Us     
About Us
Contact Us
 Apps
X
HANA App
>>>
Hadoop App
>>>
Tutorial App on SAP HANA
This app is an All-In-One package to provide everything to HANA Lovers.

It contains
1. Courses on SAP HANA - Basics, Modeling and Administration
2. Multiple Quizzes on Overview, Modelling, Architeture, and Administration
3. Most popular articles on SAP HANA
4. Series of Interview questions to brushup your HANA skills
Tutorial App on Hadoop
This app is an All-In-One package to provide everything to Hadoop Lovers.

It contains
1. Courses on Hadoop - Basics and Advanced
2. Multiple Quizzes on Basics, MapReduce and HDFS
3. Most popular articles on Hadoop
4. Series of Interview questions to brushup your skills
Apps
HANA App
Hadoop App
';
Search
Stay Connected
Search Topics
Topic Index
+
-
HANA Admin Basics
+
-
Data Provisioning
+
-
SAP HANA Cockpit
+
-
HANA MDC
+
-
Availability and Scalability

How to Convert HANA System to Support Multitenant Database Containers

In previous article Introduction to SAP HANA Multitenant Database Containers we explained HANA MDC and its architecture. In this article, we will explain how you can convert an SAP HANA System to Support Multitenant Database Containers.

If your system was installed in single-container mode, you can still implement multitenant database containers by converting the system to a multiple-container system. The conversion can be done using the SAP HANA database lifecycle manager (HDBLCM) program in the command-line interface. Converting an SAP HANA system to a multiple-container system is permanent and cannot be reversed.
How to Convert  HANA System to Support Multitenant Database Containers
During the conversion process, the system database and one tenant database are created. The tenant database contains all the data of the original system, including users, system configuration, connection properties (port configuration), and system license. However, it does not contain the backup history.
After conversion, you can create and configure further tenant databases as needed.

Prerequisites

  • The SAP HANA system has been installed with its server software on a shared file system (export options rw, no_root_squash).
  • The host has access to the installation directories and /.
  • The statistics server is not running as a separate server process (statisticsserver), but instead as an embedded service in the master index server. If this is not the case, migrate the statistics server to the embedded statistics service as described in SAP Note 1917938.
  • The SAP HANA system has been installed with the SAP HANA database lifecycle manager (HDBLCM).
  • The SAP HANA database server is up and running.
  • You are logged on as root user or as the system administrator user adm.
  • The difference between the system time set on the installation host and the additional host is not greater than 180 seconds.
  • The operating system administrator (adm) user may exist on the additional host. Make sure that you have the password of the existing adm user, and that the user attributes and group assignments are correct. The SAP HANA database lifecycle manager (HDBLCM) resident program will not modify the properties of any existing user or group.

Follow the below steps to convert HANA System to Support Multitenant Database Containers

Step 1:
Change to the SAP HANA resident HDBLCM directory:
cd //hdblcm
By default, is /hana/shared.

Step 2:
Start the SAP HANA database lifecycle manager interactively in the command line:
./hdblcm --action=convert_to_multidb

Step 3:
Provide the password of the adm user and SYSTEM user of SYSTEMDB user.

Step 4:
Review the summary, and select y to finalize the configuration.

Done!
Your HANA system is a multiple-container system with one system database and one tenant database, both of which are running.




Support us by sharing this article.



Explore More
Close X
Close X

Leave a Reply

Your email address will not be published. Required fields are marked *

Current day month ye@r *

 © 2017 : saphanatutorial.com, All rights reserved.  Privacy Policy