Unable to connect with Database Server

[Former Member]

Hello gurus,

we have installed SAP MDM server on one AIX server and Oracle database on a different AIX server. In MDM console, I can mount MDM server without problems. But when I right click the MDM server and select "DBMS settings" and fill in the following:

- DBMS server: SID.WORLD

- User name: Oracle database user

- Password: Password of Oracle database user

and click OK, get the following error message: Error retrieving DBMS settings: Unable to connect with Database Server

Is there any skilled guy who has a clue to this? I assume that user, under which SAP MDM runs (SIDadm) should have access to Oracle client directory (/oracle/client/10x_64/instantclient) in order to be able to load libclntsh libraries. But where should this be defined? Should this be put into sidadm user's PATH variable or any other variable (like LIBPATH for example?)

I would like to say that mentioned connection method is working fine when connecting from MDM console to Development system, where where SAP MDM and Oracle run on the same machine.

Thanks and Regards!

Adamst

[Former Member]

Hello all,

I've got this resolved at last.

You need to create tnsnames.ora file even on the host where MDM is installed and define Oracle database host and instance there. Then, MDM user needs to have access to oracle client libraries and needs to have access to this tnsnames.ora file as well. Once you set this up, it will work fine.

Thanks for your help!

Regards

Adamst

[former_member205403]

Hi,

Did you install Oracle client on MDM server. If not please install it and revert with the result..

Please check SAP Note 1350635 - "Problem connecting to database from MDM console" & Note 1363797 -" Oracle connection problem".. Kindly also check the log in MDM console and revert with the result.

Also, Please check Configurations Settings as mention in [MDM installation Document|https://websmp209.sap-ag.de/~sapidb/011000358700001668492008E] from Page no 42 to 45.

Check it and revert with your findings.

Regards,

Shiv