on 05-30-2013 3:13 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi Kishor,
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ecc6)(PORT=1521)))
Please check after change the port number from 1521 to 1527.Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.