MDM 71 - mdm console and clix - unable to connect to database server

[Former Member]

Hi,

environment, MDM 7.1, AIX 6, Oracle 10.2.0.4 (installed as part of a standalone java AS)

i've an issue. I have installed MDM 71 via sapinst, before that I installed a standalone java application server. During the installation, i gave the 'oracle client', 'oracle home' and 'oracle sqlplus utility' to be those of the oracle database installed for the java AS.

After sapinst completed I tested my connection to the database via

tnsping <SID> = OK

sqlplus system/passwd@<SID> = OK

When i start up the mdm console (7.1.02.90) i can mount the MDM server, BUT when I try to configure the database settings i get

error 'unable to connect to database server'

I get the same error when i use clix dblist

Error: 0x84020004, Unable to connect with Database Server

Has anybody got any ideas.

[former_member224735]

To see why the MDM is not able to connect to database, do the following:

% cd /usr/sap/<SID>/MDSxx/log

% ls -ltr

You will find last updated log file with name like MDS_LogXXUX101224X164953.csv

% tail -100 MDS_LogXXUX101224X164953.csv

You will see the reason for not being able to connect. If the reason is:

",MDSAdminServerXGetAvailableReps,Oracle_DBConnection.cpp,205,,,,server_user,server_global,,,

2011-09-23T06:10:48.933,6 ,24,"Service 'SID', Schema 'system', ERROR CODE=12154 ||| ORA-12154: TNS:could not resolve the connect identifier specified

OCI Attach, try again ...

Then edit the /oracle/SID/112_64/network/admin/tnsnames.ora with entry like following:

SID.WORLD =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = hostname)

(PORT = PORT_NO)

)

)

(CONNECT_DATA =

(SID = SID)

(GLOBAL_NAME = SID.WORLD)

)

)

then issue:

tnsping SID

If result is like

Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = SAP.WORLD) (PROTOCOL = TCP) (HOST = hostname) (PORT = PORT_NO))) (CONNECT_DATA = (SID = SID) (GLOBAL_NAME = SID.WORLD)))

OK (0 msec)

[Former Member]

Hi,

Please check the user permissions on the Database with which you are trying to connect to the database.

This should resolve your problem.

Regards.

[Former Member]

Hi Nandim,

Please refer below link:

[]

I hope I am able to solve your issue

Thanks & Regards

Dilmit Chadha