Skip to Content
author's profile photo Former Member
Former Member

TNS-12541: TNS:no listener - MCOD

Dear SAP,

I have installed 2 SAP systems in the SAME physical server using the SAME database (MCOD) :

1. Physical server : sl2srmdev

2. SAP system : DJ9 (AS-JAVA)

3. SRM-MDM Catalog : MDS (2 components MDS and MDIS).

Installation steps :

1. I have installed DJ9 oracle database

2. I have then installed DJ9 AS-JAVA

3. I have then installed MDS and MDIS as SRM-MDM Component Catalog 3.0.

Now, I want to use DJ9 database for DJ9 AS-JAVA and MDM componnents (MDS02 + MDIS03 instances).

For that, I have to modify the tnsnames.ora and listner.ora file and add an entry for MDS.

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

DJ9.WORLD=

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = sl2srmdev)

(PORT = 1527)

)

)

(CONNECT_DATA =

(SID = DJ9)

(GLOBAL_NAME = DJ9.WORLD)

)

)

sl2srmdev.WORLD=

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS =

(PROTOCOL = TCP)

(HOST = sl2srmdev)

(PORT = 1521)

)

)

(CONNECT_DATA =

(SERVICE_NAME = OracleServiceDJ9)

)

)

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

1. tnsping DJ9 works perfectly.

2. tnsping sl2srmdev does not work and return the following error :

TNS-12541: TNS:no listener.

In the documentation, it is written :

1. <net service name specified in the MDM Console as DBMS server> =

For me, the net service name = sl2srmdev ?

2. SERVICE_NAME = OracleServiceDJ9 ?

Thanks in advance for your help

Best regards

CP2009

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jun 12, 2010 at 04:52 AM

    Dear,

    If we have onle one database you dont need to edit listener file, MCOD means database same.

    1. tnsping DJ9 works perfectly.
    2. tnsping sl2srmdev does not work and return the following error :
    TNS-12541: TNS:no listener.

    Database name is DJ9 so working perfectly, there is no DB name sl2srmdev so ot working its hostname.

    Hope it will help.

    Regards,

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 12, 2010 at 05:10 PM

    Hi,

    Try to create tnsname entry using ORACLE NET CONFIGURATION ASSISTANCE which is very handy.

    Once the service is created, try provide the same service for MDS.

    Thanks

    Anil

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.