Install MDM Server

[Former Member]

Hi

Help me pleace

When SAP MDM Server and Oracle work to same Server we dont have problem

When we install SAP MDM Server and Oracle to different Servers we cannot connect to Oracle

tnsping from Server(where we install SAP MDM Server) to Oracle(other Server) is OK

How we can resolve this problem?

[Former Member · Accepted solution]

Hi,

Can you tell us the exact error it is throwing while connecting MDM Server with Oracle? you can check the reason from the logs table available as a Child of MDM Server in MDM Console. Logs -> Server

Also just try to make an entry of the DBMS server machine in Allow.ip file present in the installable directory of MDM Server under Server folder. If the file does not exists create the same and restart the MDM Server once.

Regards,

Jitesh Talreja

[Former Member]

Tnx All Guru for your ansvers

Really we configured three level landscape:

1-level Oracle DBMS (Solaris)

2-level SAP MDM Server (Windows 2003 Server), Oracle DBMS Client

3-level SAP MDM Console (Windows XP)

Configure connection Oracle Client and Oracle Server:

turn Oracle Saerver listener

install Oracle cliend with sqlplus(Admin) to Windows 2003 Server

reload Windows 2003 Server

copy tnsnames.ora and sqlnet.ora from Oracle Server to Oracle client to "..\NETWORK\ADMIN\"

tnsping to Oracle Server

sqlplus to Oracle Server database

when we do that and all right(connect to Oracle database from SQLplus)

setup SAP MDM Server

reload Windows 2003 Server

install(Win XP) or connect from SAP MDM Console to SAP MDM Server

when to establish a connection whith SAP MDM Server

Run it and turn DBMS connection whith Oracle

Done

[Former Member]

Hi Kanstantsin ,

As far as I could understand your problem.You are facing issues in connecting to the MDM server when your Oracle server is installed at a differnt location.

The MDM architecture is a three tier architecture where

- The MDM Guis are the front end (Presentation layer)

- The MDM server (The application layer)

- The DBMS (The Data base layer)

So the MDM server sits on the database layer and everytime you create a rep on MDM .MDM create a table in the database.So try installing the MDM server and the oracle server on one system.

Also refer to the below link son similar issues:

Also please refer this:

http://help.sap.com/saphelp_mdmgds55/helpdata/EN/43/D7AED5058201B4E10000000A11466F/frameset.htm (MDM documentation)

https://websmp202.sap-ag.de/~form/sapnet?_SHORTKEY=01100035870000717304&;

Hope It Helped

Thanks & Regards

Simona Pinto

[Former Member]

Hi,

As stated above just check the error logs.Also just check the username you are using to connect to Oracle.If it is system then it should work fine.But if you are using some other username with system previleges,Then make that corresponding entry in mds.ini(MDM server settings File) under parameter Oracle DBA Username.

Regards

Nisha