unable to modify database

[Former Member]

hi,

i'm unable to perform the following operations:

unarchive a repository

create a new repository

create a new repository from schema

duplicate repository

i'm getting the error "unable to modify database".

I have tried restarting the MDM server but the problem persists.

This problem has never occured before. Has someone faced this issue before? if yes then could you kindly provide the cause and resolution?

I'm on SP05 patch2 HF1 (build 5.5.42.57). MDM is running on Oracle.

Thanks in advance

SwarnaDeepika

Edited by: SwarnaDeepika on Apr 15, 2008 11:11 AM

[Former Member · Accepted solution]

Hi Swana,

<Unable to Modify Datbase>

This error occurs due to a problem with the database on which MDM server is seated.

You can try one of these options to correct this problem:

- Check the oracle data base Listener configuration

- Stop and start the oracle service from the system on which it is installed.

Start->Program->oracle->

- After doing this stop and start the MDM service.

- Then try performing the above activities.

It should work.I had faced the similar error.

Hope it helps

Kindlt reawrd points if found useful

Thanks

Simona

[Former Member · Accepted solution]

hello ,

i am facing the same problem but with little modification.

i am getting the same error,but when i delete an existing

repository i am able to create a new one.

let me know if you need more clarifiaction.

regards,

vinay singh

[Former Member]

Hi Swarna,

Can u tell me the error message while doing the unarchiving the repository.

first tell me u mounted the repository r not.

i thinking it will ask database user id and password.

Lets try this ID sa and password sa.

If not let me know. i will clarify uour doubt

Regards

hari

[Former Member]

Hi hari

While unarchiving i'm getting the same error, "unable to modify database". Yes the repository is mounted. Since mine is a Oracle server i've given the user as "system" and corresponding password. Nothing seems to work!!

Regards

Swarna

[Former Member]

Hi,

It seems to that it is your database problem.

which version you installed Oracle 9i.

Before re installing the database please check your database services.

If not let me know.

Regards

Hari

[Former Member]

Hi

please check the DBMS settings also for the MDM server.Otherwise restore the default settings.It may work.

BR

Ravi

[Former Member]

Hi,

I havent changed the default settings, they are still the same. Is this a problem specific for this version?

Regards

Swarna