Problem with MDM - Oracle

[Former Member]

Dear MDM Gurus,

I have installed MDM (5.5 - SP3),Oracle Db and Client (10.2.0.1) (10 g - free from Oracle website ) in one machine.

I mounted the MDM server but when I try to add the DBMS it gives me an error saying "Error in Initializing database engine".

I was planning on using the oracle user SYSTEM to connect from MDM DBMS Settings

Kindly let me know how I can fix this problem.

What are the config required to connect MDM with Oracle.

Appreciate any help.

Thanks.

Jack

P.S :

Guys : I get the following error message

Fatal NI connect error 12541, connecting to:

(DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=JGDPC)(CID=(PROGRAM=C:\PROGRA_1\SAPMDM1.5\Server\mds.exe)(HOST=JGDPC)(USER=SYSTEM)))(ADDRESS=(PROTOCOL=TCP)(HOST=169.254.25.129)(PORT=1521)))

VERSION INFORMATION:

TNS for 32-bit Windows: Version 10.2.0.1.0 - Production

Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production

Time: 01-OCT-2006 02:28:37

Tracing not turned on.

Tns error struct:

ns main err code: 12541

<b> TNS-12541: TNS:no listener</b> ns secondary err code: 12560

nt main err code: 511

TNS-00511: No listener

nt secondary err code: 61

nt OS err code: 0

Thx.

Message was edited by: Jack Jones

[Former Member]

Hello Jack

You are getting an error on either user authentication, no listener configured or not enough permissions.

Either way, I've tried to use MDM SP03 with Oracle 10.2 and after I passed this user issue, I got a message with something like "SAP MDM 5.5 SP03 does not support this database version" or something like that.

After reviewing the PAM I realized that Oracle 10.2 is supported only by SP04, not SP03. You should be using Oracle 9.2

I hope that helps

Alejandro