MDM Database Error - "Error initializing database engine"

[Former Member]

Hi,

I installed MDM-Server with Oracle database version 9.2.0.6. When upgrading to SP04 (5.5.34.46) I recognized, that 9.2.0.7 is needed, so I updated to this version.

After installing all of this stuff I receive this message while trying to connect to the database (in MDM-Console):

"Error initializing database engine"

"Cannot get repository list on MDM Server"

MDM-Server and the Oracle database are installed on the same server. I tried using the localinstall of the MDM Console and the remoteinstall of the MDM Console located on the server and get the same errormessage.

I also tried to connect to the database with the Oracle SQL-Developer Client, just to make sure that the logindata is correct, but this works.

Thanks a lot !

Daniel

[Former Member]

Hi Daniel

Seems like this problem never ends!

I can think of 1 more thing!

which version of MDM SP4 are you using?

Because there are two types of download available! if your are using windows XP then you have to download Windows Server on IA32 32bit.

I hope this could be the last solution i could think of!

[Former Member]

Hey Vinod,

I'm using MDM SP04 version 5.5.34.46. It's installed on a Windows 2000 Advanced Edition OS using the 32bit Installer.

Greets,

Daniel

[former_member735747]

This may be silly but its worth a try too...just in case.

Make sure you are using the same id/pwd in your sql client test as you have set in your MDM dbms settings just to make sure its a valid test. If the MDM specific one does not work then it could be that you did not re-create your MDM related id/passwd in your new database. Also double check that you gave it proper permissions (there is a template from the install guide)

Good luck.

[Former Member]

Hi Daniel,

The character set is the root cause. Now you have to change the character set to Unicode Character Set (AL32UTF8). But this can be done only if you create a new database (i guess!).

For reference please go through the MDM SP4 installation guide available in the service market place. www.service.sap.com/ instguidesNW04 → Installation →

SAP MDM → SAP MDM 5.5 Documentation Center:

[Former Member]

Hey Vinod,

I created a new database instance with the AL32UTF8 Characterset, but still no change. Even the errormessage stays the same.

Any more ideas?

Greats

Daniel

[Former Member]

Hi Daniel

I would like some clarifications from your side!

When you upgraded Oracle, You must have created a new database! Did you check the Character Set of the New Database? because for MDM to work properly, You must have the Unicode Character Set (AL32UTF8). Please let me know on this too

Vinod

[Former Member]

Hey Vinod,

my instancename is 'MDM', in the dropdownmenu there is a entry called MDM and I used to take this under SP03, but under SP04 it doesn't work.

Characterset is 'AL16UTF16'. Do you think, that this could cause the connectionproblems?

Greets

Daniel

[Former Member]

Hi Daniel

The Drop Down in the DBMS settings are the Oracle Database instances. So it has got nothing to do with MDM SP3 or SP4. Your problem would definitely get resolved if you could find the correct oracle instance that is running. Now to make it clear the "old" entry which you saw in the DBMS settings drop down might work out, because you had been using that oracle instance for sp3(i guess)! To find which oracle service(by oracle instance i mean the "oracle service") is running

i hope that your OS is Windows!!!!

you 'll have to go to the Start->run->type "services.msc", check the oracle instances running there! It wouold b something like (OracleServiceORCL where "ORCL" is the service name) and try to select the same oracle service name in the DBMS Settings.

Any more clarifications? Provide me the options you get in the DBMS Settings. so that i could help you out.

Vinod

[Former Member]

Hi Daniel

The DBMS Settings in the console could be opened only when a MDM Server is mounted.

As you said that you had upgraded Oracle. Lets say that you created a database with name ORCL. Now You have to goto the Services in Control Panel, to check the service is running. I take it that the service is running because you said that you were able to login thro' sql client. Now all you have to do is , try stopping the oracle service thats created. and restart it again! and

follow the steps

1. Open Console, Mount the MDM Server

2. Right click on it and select DBMS settings

3. The First option is the DBMS server and its a drop down:

if you had the oracle service running say (ORCL) , then you could definitely see the oracle service (ORCL) in the drop Down.

4 The user name and password would be the same as the one when you gave when you created the database(ORCL)

Hope This Helps

Vinod

[Former Member]

Hi Vinod,

I stopped the Oracleservice and restarted it, but nothing changed. I'm still able to logon through SQL Client, but I cannot get a connection with MDM.

Even the errormessage is the same.

This morning I reinstalled the MDM-Server, but again nothing changed.

After reinstallation there was one thing I recognized when trying to connect to the MDM-Database. When I open the DBMS-Settings-Dialog there are menuentries in the dropdown-menu I've never heard of. In fact there is also the "old" entry of the SP03 - Installation, but also some new ones, although the list should be empty, because it's a new installation?

I already tried to connect with the "old" SP03-Entry, but it still doesn't work.

Any further suggestions?

Greats Daniel

[Former Member]

Hi Daniel

The error "Error initializing database engine" comes when the particular oracle serice is not running. But you said that you tried to login thro' the sqlplus client and it worked successfully. Is the oracle instance during the login time in the sqlplus client the same as that in the MDM console?

My point is that if both are same then you should n't be getting the "Error initializing database engine". Go to the DBMS settings in the console and see which oracle instance you have used and try loging using the same instance in the sql client.

please let me know if this helped!

Vinod

[Former Member]

Hey Vinod,

thanks for answering that fast

Well, I didn't change any settings and it worked with SP03, so it should also work with SP04 .... Whats strange is, that I cannot open that DBMS-Settings-Detaildialog, where you can change the data path etc.

Also tried it on several machines with MDM-Console, this DBMS-Settings-Detaildialog never opens. Instead there appears the standarddialog showing a serverlist with the databasetypes.

To make it short: I have no opportunity to change something like data path or database instance.

Any suggestions?

Daniel

[Former Member]

Try initializing the DBMS using the CLIX interface.

CLIX dbInitialize MDMHostSpec DBMSHostSpec

- This Initializes the DBMS for use with the MDM Server. Per the Console reference document, this is the first thing you should do with a DBMS instance that you wish to use for the storage of MDM repositories.

Another thing, the user id, password and the host name are case sensitive.

Check how it is recognized in MDM Console details pane. Use the same case for host name.

Hope this helps