Error 12542
Contents |
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this ora-12542: tns:address already in use page. Please enter a title. You can not post a blank message. linux error: 98: address already in use Please type your message and try again. More discussions in Oracle Database Express Edition (XE) All PlacesDatabaseDatabase tns-12542: tns:address already in use tns-12560: tns:protocol adapter error Application DevelopmentOracle Database Express Edition (XE) This discussion is archived 1 Reply Latest reply on Apr 25, 2016 4:31 PM by clcarter TNS-12542: TNS:address already in use Tim Faitsch
Tns-12542 Tns Address Already In Use Windows
Apr 24, 2016 11:43 AM I'm running EPM 11.1.2.4.009 on Linux. Was working fine up until yesterday. Now when I try to start EPM it fails. It looks like the reason is that the XE database has an issue. When I try to start the database now I see this in /u01/app/oracle/diag/tnslsnr/localhost/listener/trace/listener.log:Sat Apr 23 17:03:56 2016Error listening on: (ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521))23-APR-2016 tns-12542 tns-12560 tns-00512 17:03:56 * service_register * XE * 12542TNS-12542: TNS:address already in useTNS-12560: TNS:protocol adapter error TNS-00512: Address already in use Linux Error: 98: Address already in use23-APR-2016 17:03:58 * service_update * XE * 023-APR-2016 17:04:03 * service_died * XE * 1253723-APR-2016 17:04:05 * ping * 0Can someone point me in the right direction on how to troubleshoot this?Thanks,Tim I have the same question Show 0 Likes(0) 638Views Tags: none (add) This content has been marked as final. Show 1 reply 1. Re: TNS-12542: TNS:address already in use clcarter Apr 25, 2016 4:31 PM (in response to Tim Faitsch) Tim Faitsch wrote: ...TNS-12542: TNS:address already in use A listener has already been started or some other process has that port. Try and see if its a listener, also check netstat output and verify if it is the listener using that port:ps -ef |egrep lsnr oracle
error TNS-12542 like below. [grid@DC-DB-01 ~]$ lsnrctl start listener2 solaris error: 125: address already in use LSNRCTL for Linux: Version 11.2.0.1.0 - Production on
Error Listening On: (address=(protocol=tcp)(host=)(port=1521))
19-SEP-2010 11:41:48 Copyright (c) 1991, 2009, Oracle. All rights reserved. Starting /u01/app/11.2.0/grid/bin/tnslsnr: please
Ibm/aix Risc System/6000 Error: 67: Address Already In Use
wait... TNSLSNR for Linux: Version 11.2.0.1.0 - Production System parameter file is /u01/app/11.2.0/grid/network/admin/listener.ora Log messages written to /u01/app/11.2.0/grid/log/diag/tnslsnr/DC-DB-01/listener2/alert/log.xml Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER2))) Listening https://community.oracle.com/thread/3922469 on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=DC-DB-01)(PORT=1522))) Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=DC-DB-01-vip)(PORT=1522))) TNS-12542: TNS:address already in use TNS-12560: TNS:protocol adapter error TNS-00512: Address already in use Linux Error: 98: Address already in use Listener failed to start. See the error message(s) above... The XML log file shows following message.
Topic Database design Database Admin View All Cloud infrastructure Availability Backup and recovery Export, import and migration Installation, upgrades and patches Oracle performance http://searchoracle.techtarget.com/answer/ORA-12542-TNS-address-already-in-use-error problems and tuning Oracle security Oracle DBA tools Error messages MySQL database Real Application Clusters (RAC) Applications View All Enterprise and http://www.ora00600.com/wordpress/scripts/sqlnet/tns-12542-tns-address-already-in-use/ business performance management Implementing and upgrading Oracle apps E-Business Suite Fusion applications Hyperion JD Edwards (JDE) PeopleSoft Siebel and Oracle CRM Data already in Mgmt View All BI (business intelligence) Data quality Data warehousing Metadata Database Admin View All Cloud infrastructure Availability Backup and recovery Database design Export, import and migration Installation, upgrades and patches Oracle performance problems and tuning Oracle security Oracle DBA tools Error messages MySQL already in use database Real Application Clusters (RAC) Development View All BPEL in Oracle Open Source SQL Java / J2EE Stored procedures XML PL/SQL Fusion View All Oracle and BEA Application Server Data and application integration SOA (service-oriented architecture) Infrastructure View All Cloud computing infrastructure Exadata and Exalogic Grid computing Oracle on Linux Operating system Oracle hardware decisions Virtual machine Oracle management View All certification Oracle acquisitions Business process management Market analysis DBA jobs training and certification Small businesses Regulatory compliance Outsourcing Oracle on demand and SaaS Oracle strategy and product roadmap Oracle support services Oracle vs. SAP Oracle Web 2.0 Sun-Oracle infrastructure View All Oracle cloud computing Oracle OS Oracle virtualization Topics Archive View All Oracle DBA jobs Oracle Resources Training and certification Tutorials, tips and FAQs Please select a cate
receiving the TNS-12542 error message intermittently from an application server when attempting to connect to the DB. TNS-12542: TNS:address already in use The first thing to do is check that the ping is OK: Pinging 10.60.40.40 with 32 bytes of data: Reply from 10.60.41.55: bytes=32 time<1ms TTL=128 Reply from 10.60.41.55: bytes=32 time=-23ms TTL=128 Reply from 10.60.41.55: bytes=32 time<1ms TTL=128 Reply from 10.60.41.55: bytes=32 time<1ms TTL=128 This shows that there is a configuration issue with the server or some kind of network problem. In our case, it was because a patch needed to be applied to the Windows OS in order to resolved. After this issue was identified and fixed, the problem still persisted. I checked the listener log and found that there were as many as 47 connections per second coming in from the server where the problem was reported. Sending this many connections to a listener per second is going to overload it and is likely to cause issues. So, we fixed the issue with the application spamming the server with this many connections and the error was no longer reported. Once you have resolved this error, you may encounter another issue which is much more commonly encoutered, ORA-12154: TNS: could not resolve service name. This is a very common error and there are many causes and different resolutions to this problem. I would recommend reading my article on it to resolve it. Like it, share it... Category: SQL Net Related Posts IPC vs TCP Connectivity Using TNSNames ORA-12154: TNS: could not resolve service name WARNING: inbound connection timed out (ORA-3136) Comments (1) Trackback URL | Comments RSS Feed Leave a Reply Cancel reply Your email address will not be published. Required fields are marked *Comment Name * Email * Website Most Popular Posts ORA-04021: timeout occurred while waiting to lock object ORA-29278 ORA-16433: The database must be opened in read/write mode Monitoring TEMP Space Usage in Oracle Monitor Oracle UNDO ORA-06512: at line Error Messages ORA-31623: a job is not attached to this session via the specified handle Name: Email: **CHECK JUNK EMAIL FOLDER**We will never sell your details Pages Welcome to ORA00600.com Information Become an Oracle DBA Report Contact ORA00600.com FAQs Oracle DBA Directory of Articles Oracle DBA Jobs Privacy Policy Recent Posts Oracle 11g Create Tablespace Oracle Quick Links Log in Entries RSS Comments RSS WordPress.org ORA00600 © 2016 ORA00600. All rights