Skip to Content
avatar image
Former Member

Unable to connect with Database server in MDM

Hi Experts,

I have installed the MDM server 7.1 on windows 64 bit box, but installed MDM console (32 bit).

Getting the issue like below

Can anybody please help me out to fix the issue.

Thanks in advance,

Bhaskar N

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Aug 22, 2014 at 03:43 AM

    Hi Bhaskar

    we just met this problem last month,make sure that the user you use to connect to DB has the authorization,and mostly it is the DB connection problem, check the tnsnames.ora,sqlnet.ora file is set right.

    or you can just use the tool mdm_configAssistant,follow the result report and check your settings.then the problem might be resolved. the use of the  MDM Configuration Assistant, refer to the note1543650.

    hope it helps.

    best regards

    Stephen

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,Bhaskar

      sorry to reply late,the above issue is the login credentials problem,make sure the user and password you use is correct,by the way ,try not to use the "administrator",use the DBMS user,like “system” for oracle,“sa” for sql server,if it still does not work,try another user which is the user you assigned when installing MDM on the DB.

      best regards

      Stephen

  • avatar image
    Former Member
    Aug 21, 2014 at 11:14 AM

    Dear

    Check you database is up

    check the listener service

    use command R3trans -d it should be 0

    if not solved share logs DEV_W0,disp_work dev_ms

    Regards

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello Bhaskar,

      Please find a solution for similar issue in below sdn link :

      http://scn.sap.com/thread/1662569

      It says below:

      *************************

      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.

      *************************

      Please let us know if it helps!

      Regards,

      Deepa.

  • avatar image
    Former Member
    Aug 21, 2014 at 12:36 PM

    dear

    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.


    do the following

    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.

    Add comment
    10|10000 characters needed characters exceeded