cancel
Showing results for 
Search instead for 
Did you mean: 

TNS-12542: TNS:address already in use

Former Member
0 Kudos

Hi,

I am getting the following error when I  ma trying to install  SAP on Orcle DB

and  please find attached log files

________________________________


LSNRCTL for 64-bit Windows: Version 11.2.0.3.0 - Production on 29-MAY-2023 16:00:16

Copyright (c) 1991, 2011, Oracle.  All rights reserved.

Starting tnslsnr: please wait...

TNSLSNR for 64-bit Windows: Version 11.2.0.3.0 - Production
System parameter file is D:\app\Administrator\product\11.2.0\dbhome_1\network\admin\listener.ora
Log messages written to D:\app\Administrator\diag\tnslsnr\ecc6\listener\alert\log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ecc6)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\C11.WORLDipc)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\C11ipc)))
Error listening on: (DESCRIPTION=(ADDRESS=(COMMUNITY=SAP.WORLD)(PROTOCOL=TCP)(HOST=ecc6)(PORT=1521)))
TNS-12542: TNS:address already in use
TNS-12560: TNS:protocol adapter error
  TNS-00512: Address already in use
   64-bit Windows Error: 48: Unknown error

Listener failed to start. See the error message(s) above...

________________________________

Please suggest me how can I fix this issue.

Regards

Kishore Reddy

Accepted Solutions (0)

Answers (7)

Answers (7)

Former Member
0 Kudos

change the listener port to 1525 and manually restart the oracle services or check the tnsping sid in the command prompt before changing the listener port number . probably the port might be used for VNC viewer or some TCP ports in the server or some OS related or application related ports

Former Member
0 Kudos

Hi Kishore,

Please check in the listener.ora on the configured listeners. If you have already the listener configured, Isuggest better you remove all the listener configuration and start afresh.

Regards

Mukunthan

former_member206552
Active Contributor
0 Kudos

Hi Kishore,

is this a new system or was oracle installed before, if so please check and kill any listener process running by stopping the services.

if this is a vinilla system do as Thiago suggested to see if the port is in use

netstat -na | findstr 1521

if the port is in use you have 2 options, changing the port number of the listener or by changing the other application using this port number

Best Regards

Marius

former_member182034
Active Contributor
0 Kudos

hi Kishor,

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ecc6)(PORT=1521)))
Please check after change the port number from 1521 to 1527.

Regards,

former_member188883
Active Contributor
0 Kudos

Hi Kishore,

Refer section Fixing the ORA-12542 on Windows from the link below.

http://www.dba-oracle.com/t_ora_12542_tns_address_already_in_use.htm

Hope this helps.

Regards,

Deepak Kori

thiago_cavalheiro
Active Participant
0 Kudos

Hello Kishore,

Check whether the TCP port 1521 is already in use. You can use the command bellow:

netstat -na | findstr 1521

You may need to free up this port or use another one for the listener.

Best regards,

Thiago

Former Member
0 Kudos

Hi Kishore,

Post contents of D:\app\Administrator\diag\tnslsnr\ecc6\listener\alert\log.xml.

Check if there is already another listener process running and stop this process.

Also use telnet to check if you can access port which will indicate if already in use. Or if there is port conflict in your tnsnames.ora and listener.ora files perhaps i.e. they differ.

Have you tried to test also with tnsping?

Regards,

Johan