Error Ora-12542
Contents |
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle Books Oracle Scripts Ion Excel-DB Don Burleson Blog ora-12542: tns:address already in use
ORA-12542: TNS:address alreadyTns-00512: Address Already In Use
in use tips Oracle Database Tips by Burleson Consulting August 24, 2015 Question: I am able to make
Tns-12542: Tns:address Already In Use Tns-12560: Tns:protocol Adapter Error
42 and more connections of my Application Users within 8 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
Linux Error: 98: Address Already In Use
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 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 tns-12542 tns-12560 tns-00512 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: Address already in use. There are 2 solutions available: 1.) Increase the free port range: ====================== Start Registry Editor (Regedt32.exe). Locate the following key in the registry: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters On the Edit menu, click Add Value, and then add the following registry value: Value Name: MaxUserPort Data Type: REG_DWORD Value: 65534 Valid Range: 5000-65534 (decimal) Default: 0x1388 (5000 decimal) Description: This parameter controls the maximum port number used when an application requests any avail
Topic Database design Database Admin View All Cloud infrastructure Availability Backup and recovery Export, import and migration Installation, upgrades and patches Oracle performance problems and tuning Oracle security Oracle DBA tools Error messages MySQL database Real Application tns-00512 address already in use windows Clusters (RAC) Applications View All Enterprise and business performance management Implementing and solaris error: 125: address already in use upgrading Oracle apps E-Business Suite Fusion applications Hyperion JD Edwards (JDE) PeopleSoft Siebel and Oracle CRM Data Mgmt tns-12542 tns-12560 tns-00512 linux error 98 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 http://www.dba-oracle.com/t_ora_12542_tns_address_already_in_use.htm patches Oracle performance problems and tuning Oracle security Oracle DBA tools Error messages MySQL 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 http://searchoracle.techtarget.com/answer/ORA-12542-TNS-address-already-in-use-error 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 category Applications Data Mgmt Database Admin Development Fusion Infrastructure Oracle management Sun-Oracle infrastructure Section Problem Solve News Get Started Evaluate Manage Problem Solve Sponsored Communities Q 'ORA 12542: TNS: address already in use' error Sections Share this item with your network: Related Expert Q&A Error affecting nightly batch jobs – SearchOracle Connecting Oracle forms developer to a database – SearchOracle Errors with Oracle on Linux installation – SearchOracle Sponsored News Got Containers? You’ll Need a Way to Monitor Them –Splunk ABC’s of VDI in 2016 –Dell See More Vendor Resourc
Analytics Conference: Oct 18, Mastering SAP BI, Melbourne: Oct 23. ORA-12542: TNS:address already in http://www.forumtopics.com/busobj/viewtopic.php?p=922308 use Search this topic...|Search DI: Installation, Administration, and Connectivities...|Search http://psoug.org/oraerror/ORA-12542.htm Box Select a search Explain These Choices... --------------------Recent Topics (All Forums) Unanswered Posts Register or Login to Post Forum Index -> Data Integrator -> DI: Installation, Administration, and Connectivities Author Message barthodoPrincipal MemberJoined: 18 Apr 2012Posts: 214Location: Munich Posted: Mon already in Nov 26, 2012 7:43 amPost subject: ORA-12542: TNS:address already in use Hi all, i had the situation that all Jobs aborted with Error: ORA-12542: TNS:address already in use We never had this error before, but we found out, that no more port is available in the "NETSTAT" I saw that Salesforce Adapter already in use (so the HTTP-Proxy) connection is blocking thousands of ports. After i restarted Salesforce Adapter i was able to process Jobs again. It seems that Salesforce Adapter is opening Port-Connections and doesn't close them after data was transferred. We also have some Real-Time-Jobs which are sending many real-time requests to Salesforce. Could it be that Salesforce opens a Port for every request but doesn't close it afterwards? How we can avoid that salesforce adapter is filling up the netstat? Is there a parameter to "control" the Port-Closing? Or is this a bug? We have this problem in both environments: 1. Environment: 14.0.1.142 2. Environment: 14.0.3.353 Back to top osrootofosPrincipal MemberJoined: 10 Feb 2012Posts: 148Location: United States Posted: Mon Nov 26, 2012 8:40 pmPost subject: Re: ORA-12542: TNS:address already in use Hi you need to start your listener with unique add. Fixing the ORA-12542 on UNIX/Linux In UNIX, the ORA-12542 error is an easy fix, just re-set
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: ORA-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 170 users online © 2009 psoug.org PSOUG LOGIN Username: Password: Forgot your password?