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

[mamartins]

It seems that you have a hybrid solution.

It's possible to have several HANA instances running on the same host, each one with it's own SID, own instance number, own SYSTEMDB database, separate file system folder and TCP/IP ports.

Obviously, each one of those instances can have one or more tenant databases...

[Mithran]

Hi m14927,

Thank yuu for the reply.

Yes As you said, I have 2 different SID which has its own SystemDB.
For Example:
SystemDB & Tenant DB for SID -> ABC
SystemDB & tenant DB for SID -> XYZ

Above scenario also comes under MDC right? or is it MCOS?

So in future if i want to have one SystemDB and multiple Tenants under one SystemDB - Do I have to manually login from SystemDB and then create a tenant DB? will it not work if i perform using hdblcm ?

Thanks & Regards,

Mithran