Multiple SAP systems on One database

[Former Member]

Hello,

We are planing to install multiple SAP systems like SM, ERP on one database with multiple DB SIDs, it means each SAP system has its own Oracle instance. We know MCOD has only one DB SID (one oracle instance) for multiple SAP systems.

Is it possible to set up the landscape like this? Is it supported by SAP?

Can any body advice?

Thanks,

Kris

[Former Member]

Kris,

See Fidel Vales's earlier answer. Technically it can be made to work but SAP does not support it. Furthermore, even if you ignore the fact that this setup is unsupported, you wouldn't be getting much benefit from it except saving a few Gigabytes of disk space (which is pretty insiginificant compared with the size of the databases themselves). I would very strongly recommend that you keep to the straight and narrow (either use separate DB SIDs with separate Oracle homes, or MCOD).

Regards,

Mark

[Former Member]

We were thinking to install multiple sap comoponents in one datbase but with multiple DB SIDs (MCOD has one DB SID) and share one ORACLE_HOME. In our case we will have multiple oracle instances (MCOD has one oracle instance).

I understand that SAP doesn't support the setup like this.

Thanks,

Kris

[Former Member]

Hello Fidel,

But as per SAP Note: 105047, the ORACLE_HOME sharing is not permitted. But in MCOD we share common ORACLE_HOME. I am confused about this statement. Can you clarify?

Thanks,

Kris

[Former Member]

MCOD means Multiple Components in One Database, that is several SAP systems sharing one Oracle database.

SAP note 105047, chapter 36, is talking about several Oracle databases sharing one ORACLE_HOME.

hope this helps

[Former Member]

HI

Read the below notes may help you understand better

SAP Note 98252 - Installing two Oracle databases on a host

SAP Note: 350251

Regards

Uday

[Former Member]

Thanks Markus,

But we want to install one DBMS home for all oracle instances for different SAP components. Is it possible?

Thanks,

Kris

[fidel_vales]

>

> Thanks Markus,
> 
> But we want to install one DBMS home for all oracle instances for different SAP components. Is it possible?
> 
> 
> Thanks,
> Kris

Technically, it is possible.

But SAP Does NOT support it. The only method to install one set of binaries (one ORACLE_HOME) that is supported by SAP is to use MCOD (all components are installed in one Database)

[markus_doehr2]

Yes, it's supported - as long as you install the database software for each instance separately.

Markus