tns-12541: tns:no listener sap

[former_member300218]

Hi all,

If we try start Oracle Agent Service
from console, we have this error:

And the listener error is:

Any idea?

Thank you in advance.

[former_member300218]

Reinstalling Oracle software solves the problem.

Thank you for your help.

[Former Member]

Hi Mercedes,

tnsnames.ora:

===========

EXTPROC_CONNECTION_DATA.<name>.LOCAL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
) 

>>> DELETE HERE (Begin) <<<

>><worldname>.WORLD =
>>(DESCRIPTION =
>>(ADDRESS_LIST =
>>(ADDRESS = (PROTOCOL = TCP)(HOST = <host>)(PORT = 1521))
>>)
>>(CONNECT_DATA =
>>(SID = <SID>)
>>(SERVER = DEDICATED)
>>)
>> ) 

>>> DELETE HERE (End) <<<

<worldname>.WORLD =
(DESCRIPTION =
(SDU = 32768)
(ADDRESS_LIST =
>> (ADDRESS = (COMMUNITY = SAP.WORLD)(PROTOCOL = TCP)(HOST = <host>)(PORT = 1527)) --> Change the port 1521
)
(CONNECT_DATA =
(SID = <SID>)
(GLOBAL_NAME = <SID>.WORLD)
)
)

Then, restart the listener.

Best regards,

Orkun Gedik

[former_member300218]

Hi all,

If we try start Oracle Agent Service
from console, we have this error:

And the listener error is:

Any idea?

Thank you in advance.

[Former Member]

Hi,

Please check environment variable TNS_ADMIN and add the below entry to the tnsnames.ora file that is used by the <sapsid>adm user.

LISTENER_<DBSSID>.WORLD = (ADDRESS = (COMMUNITY = SAP.WORLD)(PROTOCOL = TCP)(HOST = <hostname>)(PORT = <listener_port>))

Then try to test it with tnsping and let me know the result.

Thanks
Rajat