MDM Installation _ Oracle Database

[Former Member]

Dear Suppport,

In the installation MDM guide, I do not see any where instructions on how to install Oracle database?

So sar, I have installed the Oracle 920 and installed the Oracle 9207 patch set. While installing the Oracle 920, I have choosed not to build the dafault database.

Is there a procedure on how to build the database (usually NW Installation master builds the databse). Here in MDM, looks liek we are not using the NW Installation Master.

Could you please let me know on how to build the the database for MDM 5.5.

Thank you,

Nikee

[Former Member]

Hi Nikee,

In oracle open the database configuration assistant and

create a new database for general purpose

Mention the Global database name and SID its not mandatory that u keep different names and then specify the password and then start creation.

Now that ur database is created its ready to be used for MDM.

Just check whether u are able to connect to database from windows console

Start --> run --> cmd

sqlplus

connect Oracleusername@Sid;

and then provide password

If it connects that means there is no problem

If there is any problem u need to start the listeners

Start -->> run -->> Services.msc

U need to start the related database services

Even after doing all this the problem persists then

Try starting listeners from

Start -->> run -->> cmd -->> lsnrctl -->> start

Hope dis helps u

Rewards points if found helpful

Regards Tejas.......

Edited by: Tejas Bane on Feb 15, 2008 2:32 PM

[Former Member]

Hai Tejas

Even I am in the process of MDM installation on Windows XP professional.

Now I have installed oracle 10g and oracle patch. So what should be the next step?

is it to install Master Data Servers like

􀁸 MDM Server

􀁸 MDM Import Server

􀁸 MDM Syndication Server

􀁸 MDM Layout Server

and only after that we have to create database as you have specified?.

Please tell the exact steps after the oracle and patch installation.

Thank you in advance.

[Former Member]

After Oracle installation u need to create database and start all the services related to database

Then install the MDM Servers followed by MDM clients

Then do the necessary settings that are needed to configure database from MDM.

The configuration steps for database from MDM is given in MDM installation guide.

Regards Tejas.......

[Former Member]

Hi Nikee,

while installing the oracle database you just have to follow the instruction

appears at the installation. But save Global Database_name & MDM Database_name

and their passwords respectively.

Global database_name & MDM datbase_name should be different.

After completion of the database creation you have to start of the MDM Database listners

that will appear in the SERVICES.msc in the RUN editor.

then you have to establish the connection between the MDM database and the its services through CMD.

in the following order.

services/Password@Database name.

hope dis helps you,

Reward points if found useful.

Swapnil

[Former Member]

Hello swapnil,

I have given global database name as well as sid as same "C25". Did you mean that both should be same?.

> between the MDM database and the its services through CMD.

what is CMD ?

> in the following order.services/Password@Database name

Can you be explain it little more clearly?

Thank you, Swapnil

[Former Member]

Hi Nikee,

Did you got Answer for this question?.

I think in the Installation guide of MDM, under post installation tasks there is a topic " Install Oracle and Create a Database Instance" . I think this will do the trick.

Please let me know if you are successful with this.