MDM not connecting to Oracle.

[Former Member]

HI Everyone,

MDM 7.1 SP06 with Oralce 11g on Windows Server 2008 R2 Environment

Recently we have moved our MDM server from one location to another location (i.e) data center shift.

After this move, we were not able to connect MDM, this issue has been fixed 1 month back by changing new public in tnsnames .ora. After that it was working fine.

Just 1 week back i have restarted the (server) host after that i am not able to connect MDM to Oracle Database.

Kindly note after the restart the problem starts, that means when i entered new public IP in tnsnames.ora that time i didnt restart and just week back i restarted the server so that problem starts.

So i guess server(host) restart become a problem now, new entry in tnsnames.ora did some changes after restart in the system thats why facing this problem.

Anyone knows how i can fix this issue. i did lot of search and investigation but no use and no luck.

Even tried reconfigured the listener and tnsnames.ora but still same problem.

Error:

When i tried to mount the repository in MDM console i am getting the below error.

"Unable to connect with DataBase server"

Can anyone pls help me to fix this issue.

Thanks

Ahmed S

[Former Member]

HI Ahmed,

Please go through

SAP Note 1350635 - "Problem connecting to database from MDM console".

SAP Note 1363797 -" Oracle connection problem".

Please revert with findings.

Thanks,

Ravi

[Former Member]

Dear All,

Thanks for your replies.

Have already tried all the below option for this issue. But no luck still facing issue.

SAP Note 1350635 - "Problem connecting to database from MDM console".

SAP Note 1363797 -" Oracle connection problem".

I guess there is a problem in listener, let me explain in detail.

Actually there are two sap system in this same host.

1st is EP its up and running fine without any issues.

2nd is MDM its making a trouble.

So there is two different database instance 1 belongs to EP and other one belongs to MDM.

there are two listeners in service.msc and only one is up and running the other one is starting to failed.

At the same time both the listeners are not coming up (not starting).

Any other solution?

Thanks

Ahmed S

[Former Member]

Hello,

Please check with SAP note 1543650 for MDM Configuration Assistant Tool.

regards,

Abhishek

[Former Member]

Hi Abisheik,

Already tried this note.

This note already recommended by SAP support. But there also a problem.

I have a doubt.

I didnt do any configuration changes and i did only new public IP in tnsnames.ora then i restarted the server, whats wrong in this activity.

For you information below is the tnsping for MDM

C:\Users\MDMadm>tnsping mdm

TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 18-NOV-2011 14:53:07

Copyright (c) 1997, 2010, Oracle. All rights reserved.

Used parameter files:

E:\oracle\MDM\product\11.2.0\dbhome_1\network\admin\sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = DEFIANCEDEP)(PORT = 1521))) (CONNECT_DATA

= (SERVICE_NAME = MDM)))

TNS-12541: TNS:no listener

C:\Users\MDMadm>

Thanks

Ahmed S

[Former Member]

Hello,

this seems correct,

One last option is to take restart the MDM the server along with the database server.

sequence to follow is

shut down MDM Server

Database server

Start DB server

finally mdm server.

which version MDM you are using.

regards,

Abhishek

[Former Member]

Dear Abhishek,

Sorry for the late reply. Was follow up with SAP.

Still facing the same issue.

SAP request to refer the below NOTE but, no luck still facing same issue.

My MDM version 7.1 SP06.

Any clue.

Thanks

Shafir

[Former Member]

Hello,

Which SAP Note.

check this site for further details service.sap.com/pam

regards,

Abhishek

[Former Member]

Hi Abishek,

Below are the notes.

443867 - ORA-12154 Collective SAP note

34479 Collective note for problems with SQL-Net V2 ORACLE

445038 Problems when accessing Net8 configuration files

thanks

Shafir

[Former Member]

HI

Anyone pls help me with this issues.

Since 1 month im troubleshooting this issue. But noluck.

thanks

Shafir

[Former Member]

Hello,

everything seems correct, please check with the SAP Note provided, they should solve the problem

regards,

Abhishek

[former_member182007]

See below link

hope it helps .

thx

Deep

[Former Member]

Hello,

please the note

https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=1543650

Check if you are able to logon to the DBMS, also check the log in the mdm console, also check for the database entry when you unarchive an repository is it present or not.

If not then you need to check you database connectivity.

regards,

Abhishek