Skip to Content
avatar image
Former Member

Unable to connect with Database Server

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Apr 16, 2010 at 05:53 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 22, 2010 at 11:20 AM

    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

    Add comment
    10|10000 characters needed characters exceeded