TNS-12541: TNS:no listener - MCOD

[Former Member]

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

[former_member227283]

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

[Former Member]

Thanks Anil.

1. DJ9 is the database name.

The service name OracleServiceDJ9 already exist.

==> Tnsping DJ9 works perfectly.

2. MDS is the SRM-MDM System - containing MDS and MDIS component.

I want to use DJ9 database for MDS system.

Question :

With the Net Configuration Assistant, what do I have first to create or change ?

1. "Listner Configuration" or "Local Net Service Name configuration" ?

2. Do I have to modify OracleServiceDJ9 or to create a new locat service name called OracleServiceMDS ?

Thanks in advance for your feedback

Best regards

CP2009

[Former Member]

Thanks Anil for your input.

1. DJ9 is an AS_JAVA using DJ9 oracle database on my physical server (srmserv33)

2. On the same physical server (srmserv33), I have installed SRM-MDM Catog and 2 MDM Components (MDS, MDIS).

3. I want to use DJ9 oracle database to save MDS and MDIS data.

Now, as read in my documentation, and as you suggested it to me, I can use the "Net Configuration Assistant" which

modifiy both listner.ora and tnsnames.ora.

In my case :

Listner.ora :

==========

ADMIN_RESTRICTIONS_LISTENER = on

LISTENER =

(ADDRESS_LIST =

(ADDRESS =

(PROTOCOL = IPC)

(KEY = DJ9.WORLD)

)

(ADDRESS=

(PROTOCOL = IPC)

(KEY = DJ9)

)

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = srmserv33)

(PORT = 1527)

)

)

STARTUP_WAIT_TIME_LISTENER = 0

CONNECT_TIMEOUT_LISTENER = 10

TRACE_LEVEL_LISTENER = OFF

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = DJ9)

(ORACLE_HOME = K:\oracle\DJ9\102)

)

)

Tnsnames.ora

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

DJ9.WORLD=

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = sl2srmdev)

(PORT = 1527)

)

)

(CONNECT_DATA =

(SID = DJ9)

(GLOBAL_NAME = DJ9.WORLD)

)

)

So, I have tried to changed listner.ora and tnsames.ora, without success.

Do you have any example of listner.ora and tnsames.ora of 2 SAP systems using the oracle database (DJ9) ?

Thanks in advance for your input

Best regards

CP2009

[Former Member]

Dear all,

DBMS Server = the SID of oracle database.

In my case, it was DJ9 and not the hostname of th server where the database is running,

Best regards

CP2009

[Former Member]

Dear all,

DBMS Server = the SID of oracle database.

In my case, it was DJ9 and not the hostname of th server where the database is running,

Best regards

CP2009

[Former Member]

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,