HANA MCOS vs MCOD

[Mithran]

Dear Guru's

Happy New Year 2024

I recently installed HANA 2.0 SP05 version in SuSe-Linux. I was able to install additional Tenant Database.
I have 2 additional Tenant Databases with 2 different Instance Number and 2 different SYSTEMDB in same host in my case this one is MCOD or MCOS?.

usually MCOD runs with one SYSTEMDB and multiple Tenant right ? But how come I was able to install & have 2 different SYSTEMDB?

Could you please suggest where am I going wrong ?

How to identify a HANA Database if it is MCOS or MCOD

Adding further MCOS & MCOD both can be installed in HANA 2.0 right ?

Please do the needful

Thanks & Regards,

Mithran

[eason_chen]

Dear customer,

To add additional tenant DB, you just need run a SQL as following in SYSTEMDB.
e.g.
CREATE DATABASE DB0 SYSTEM USER PASSWORD Manager1;

Alternatively, you may refer to following guide.
Create a Tenant Database

Then you could run following SQL in SYSTEMDB to check the available tenant DB in this HANA.
SELECT * FROM M_DATABASES

May I ask how did you add new tenantDB?

Moreover, if you installed multiply HANA instances, you would be able to find different folders from OS.
/usr/sap/<SID>/HD<instance number>

Best Regards,

Eason Chen

[Mithran]

Hi Eason Chen,

Thank you for the reply.

I added additional Tenant DB using hdblcm where now I am having 2 SystemDB & 2 TenantDB.

In case If I want to have multiple tenants under one SystemDB , I have to login to SystemDB and then create an additional TenantDB manually and then install SAP for it?

or i can do the same using hdblcm utility?

Thanks & Regards,

Mithran