MDM consol can't connect RDBMS

[Former Member]

hi expert,

I want to connect MDM database using MDM console.

MDM and DB are different host.

so I install oracle client on MDM server.

I check connect with sqlplus on MDM server

- sqlplus system/*****@DBSID --> OK

but

when I try to connect to Database with MDM console on MDM server, error occur.

I setup RDBMS setting in MDM consol.

DBMS server : TNSNAME.ora SID

User naem : system

Password : ********

--> unable to connect with database server

so I attach log

===================================================

Failed to load OCI.DLL, received error: 126

Oracle Initialization Failed -- likely missing libraries/dlls

OCI Init returned 0x84020028

OCIErrorGet: pfnOCIErrorGet==NULL

ERROR CODE=-1 ||| Failed to intitialize Oracle shared library.

Last CMD:

DB & Client : 10.2

MDM : 7.1 sp04

any help please

thanks

regards

jun

[Former Member]

Hello,

I had the same problem and could reslove it by adjusting the the files in Home directory.. e.g. dbenv.csh dbenv.sh.

Please check there the entries for Oracle_Home and Oracle_client .

Restart the MDM server Database and also Listener...

Best Regards

Keyvan Sharif

[Former Member]

Dear Lee,

This is a problem with 64 vs 32 bit conflict.

MDM 7.1 requires 64-bit oracle client installed on the MDM server machine.

If you have Oracle 32-bit client installed on MDM server machine, then you get this OCI error.

Regards,

Shaailesh.

[Former Member]

Hello jun

Your MDM Server and your RDBMS server should have the same capacity (in your case 64 bit)

When you connected to RDBMS from SQLPLUS you are check ability to connect from your phisical server to another(not between SAP MDM and RDBMS).

Regards

Kanstantsin Chernichenka