Skip to Content
avatar image
Former Member

How to create the oracle database for MDM

Hello Friends,

I am new to MDM technology. I have been asked to install MDM 5.5 on windows with oracle database.

i have gone through the installation guides and master guide of MDM. But in the installation the procedure is not given to create the data base after oracle installation. i want to know do i need to create the database manually if yes then what should be the DBSID of the database and schema name etc.

Please help.

Thanks,

Manoj

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Aug 20, 2007 at 06:27 AM

    Hi Manoj,

    After Installing Oracle and MDM 5.5 Perform the following steps .

    1. Go to Console and Mount the MDM Server then for this server Right Click and Select "DBMS Settings" from the context menu.

    2. Give the DBMS server name and User Credentials: Login and Password for your DBMS Server.

    3. Then Right Click on the MDM Server and select "Unarchive Repository" from the context menu and give the DBMS User Credentials.

    4. Then select the repository from the "Archive" list and Give it a suitable "Repository Name". and Click on "Finish".

    This will create database of the repository specified.

    Please revert back if you have any queries

    Thanks and Regards,

    <b>Sagar Sonje

    Mark Helpful Answers</b>

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 20, 2007 at 12:03 PM

    Hi,

    Before I could help, may I ask you to run the <b>Oracle Administration Assistant</b> (Start -> Programs -> ...) and tell me if there are some databases in the tree on the left under the <b>Databases</b> node?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 20, 2007 at 12:23 PM

    Hi,

    No there is no database.

    Thanks,

    Manoj

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi, Aliaksandr

      Do we need Oracle Client installation in case described above? MDM installation guide states that "You might need to install both DBMS and client of Oracle if you plan to host Oracle on the same machine as MDM." It's not clear whether should we install Client in any case or there are some situations when we are able to skip this step?

      Vadim