Database Error 12542
Contents |
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! tns-12542 tns address already in use windows Oracle PostersOracle Books Oracle Scripts Ion Excel-DB Don Burleson
Tns-12542: Tns:address Already In Use Tns-12560: Tns:protocol Adapter Error
Blog
ORA-12542: TNS:address already in linux error: 98: address already in use use tips Oracle tips by Burleson August 24, 2015 Question: I am able to make 42 and more connections of my Application Users within 8Tns-12542 Tns-12560 Tns-00512
terminals. When 9th terminal connects I'm getting the ORA-12542 error: Error ORA-12542: TNS:address already in use What is the solution to the ORA-12542 error? Answer: The docs note this on the ORA-12542 error: ORA-12542: TNS:address already in use Cause: Specified listener address is already being used. Action: Start your listener with tns-00512: address already in use a unique address. Fixing the ORA-12542 on UNIX/Linux In UNIX, the ORA-12542 error is an easy fix, just re-set the listener to run on a different port or add to the queue size for the listener in your listener.ora file. listener=(address= (protocol=tcp) (host=myhost) (port=2241) (queuesize=60) ) Fixing the ORA-12542 on Windows The error "ORA-12542: TNS:address already in use" is rare on UNIX but very common on Windows crapware and /net platforms, and this may be a bug. See MOSC Note:252614.1, and search for bugs relating to ORA-12542. It may have to do with a memory leak. On Windows, user SJH suggests this solution for the ORA-12542 error: [The ORA-12542 TNS address in use error] is caused due to the fact that the free ports in the windows client has been exhausted and it is trying to make use of a port which is in TIME_WAIT state which gives the error TNS-12542
on OracleWhere is this place located?All Places SAP on Oracle This discussion
Tns-12542 Tns-12560 Tns-00512 Linux Error 98
is locked 7 Replies Latest reply: Jun
Ibm/aix Risc System/6000 Error: 67: Address Already In Use
26, 2013 9:49 PM by boopathy v Tweet TNS-12542: TNS:address already in solaris error: 125: address already in use use Kishore Reddy May 30, 2013 4:13 PM Currently Being Moderated Hi,I am getting the following error when I ma http://www.dba-oracle.com/t_ora_12542_tns_address_already_in_use.htm 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:16Copyright (c) 1991, 2011, Oracle. All rights reserved.Starting tnslsnr: please wait...TNSLSNR for 64-bit Windows: Version 11.2.0.3.0 - ProductionSystem http://scn.sap.com/thread/3367446 parameter file is D:\app\Administrator\product\11.2.0\dbhome_1\network\admin\listener.oraLog messages written to D:\app\Administrator\diag\tnslsnr\ecc6\listener\alert\log.xmlListening 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 errorListener failed to start. See the error message(s) above... ________________________________Please suggest me how can I fix this issue.RegardsKishore Reddy 13921Views Re: TNS-12542: TNS:address already in use Johan Van Zyl May 30, 2013 6:43 PM (in response to Kishore Reddy) Currently Being Moderated 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 p
CloudFlare Ray ID: 2ed98d40146858d3
Library mySQL Code Library PHP Code Library JavaScript Code Library Oracle Terms & Definitions Oracle Error Codes PSOUG Community Blogs Oracle Jobs Board PSOUG Forum Oracle User Group Directory Free Oracle Magazines Online Learning Center PSOUG Presentations Advanced Code Search News and Events Sponsors Page Submit Code Contact Us Oracle Error: TNS-12542 Error Description: TNS:address already in use Error Cause: Specified listener address is already being used. Action: Start your listener with a unique address. There haven't been any comments added for this error yet. You may add one if you like. Add a comment Name: Email: URL: Chars left:1000 (1000 max) (No HTML, but newlines will be preserved) Home : Code Library : Sponsors : Privacy : Terms of Use : Contact Us 198 users online © 2009 psoug.org PSOUG LOGIN Username: Password: Forgot your password?