Connect MDM components (MDM, MDIS) with Oracle (MCOD)

[Former Member]

Hello!

I successfully installed SRM-MDM Catalog with MDS and MDIS and MDM console

(scenario: SAP EHP4 ERP system with SRM server, SAP EP EHP1 and SRM-MDM Catalog).

Now I would like to integrate MDM with Oracle.

On the server I allready have 2 Oracle instances (SAP EHP4 ABAP and Portal).

So I have MCOD Oracle installation.

What are the technical steps (oralce steps) to connect MDM components with Oracle?

(editing tnsnames.ora, creating/modifying tablespaces)

kind regards

[Former Member]

Hi,,

please check page 234-242 in console guide

http://help.sap.com/saphelp_nwmdm71/helpdata/en/4b/71608566ae3260e10000000a42189b/MDMConsole71.pdf

Thanks,

sudhanshu

[Former Member]

Hi!

Thank you very much!

My current situation:

Oracle software was installed and updated to version 10.2.0.4 by previous ABAP and Portal system.

Now I installed MDM with MDM ans MDIS.

So I have ABAP, Portal and MDM components on the same windows server.

Now I would like to connect my MDM components to Oracle.

Questions:

1) Which oracle post installation steps do I need, when I allready installed Oracle and have 2 oracle separate instances on the same server (MCOD)?

a) modification of TNSNAMES.ORA

b) creation of new oracle users for MDM/modification of environment variables for MDM OS users

b) creation of new database instance or integration of MDM into existing ABAP or Portal oracle instance

Thank you very much!

kind regards