Oracle 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! ora-12542: tns:address already in use Oracle PostersOracle Books Oracle Scripts Ion Excel-DB Don Burleson Blog tns-12542: tns:address already in use tns-12560: tns:protocol adapter error
ORA-12542: TNS:address already in use linux error: 98: address already in use tips Oracle Database Tips by Burleson Consulting August 24, 2015 Question: I am able to make 42 and more connections of my Application Users within tns-12542: tns:address already in use windows 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 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 withTns-12542 Tns-12560 Tns-00512
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: Address alrea
and SafetyAsset NetworkAsset Operations and solaris error: 125: address already in use MaintenanceCommerceOverviewSubscription Billing and Revenue ManagementMaster Data Management for CommerceOmnichannel ibm/aix risc system/6000 error: 67: address already in use CommerceFinanceOverviewAccounting and Financial CloseCollaborative Finance OperationsEnterprise Risk and ComplianceFinancial Planning and AnalysisTreasury and Financial http://www.dba-oracle.com/t_ora_12542_tns_address_already_in_use.htm Risk ManagementHuman ResourcesOverviewCore Human Resources and PayrollHuman Capital AnalyticsTalent ManagementTime and Attendance ManagementManufacturingOverviewManufacturing NetworkManufacturing OperationsResponsive ManufacturingMarketingOverviewMarket with Speed and AgilityUnique Customer ExperiencesReal-Time Customer InsightsR&D/EngineeringOverviewDesign NetworkDesign OrchestrationProject and Portfolio ManagementSalesOverviewCollaborative http://scn.sap.com/thread/3367446 Quote to CashSales Force AutomationSales Performance ManagementSelling Through Contact CentersServiceOverviewEfficient Field Service ManagementOmnichannel Customer ServiceTransparent Service Process and OperationsSourcing and ProcurementOverviewContingent Workforce ManagementDirect ProcurementSelf-Service ProcurementServices ProcurementStrategic Sourcing and Supplier ManagementSupply ChainOverviewDemand ManagementDemand NetworkLogistics NetworkManufacturing Planning and SchedulingResponse NetworkResponse and Supply ManagementSales, Inventory, and Operations PlanningTransportation ManagementWarehouse ManagementSustainabilityOverviewEnvironment, Health, and SafetyProduct Safety and Stewardship NetworkBrowse by IndustryAerospace and DefenseAutomotiveBankingChemicalsConsumer ProductsDefense and SecurityEngineering, Construction, and OperationsHealthcareHigh TechHigher Education and ResearchIndustrial Machinery and ComponentsInsuranceLife SciencesMediaMill ProductsMiningOil and GasProfessional ServicesPublic SectorRetailSports and EntertainmentTelecommunicationsTravel and TransportationUtilitiesWholesale DistributionBrowse Platform and TechnologyAnalyticsOverviewBusiness IntelligencePre
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads http://stackoverflow.com/questions/14778258/oracle-ora-12542-tnsaddress-already-in-use-in-c-sharp with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack http://psoug.org/oraerror/ORA-12542.htm Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Oracle ORA-12542: TNS:address already in use in C# up vote 0 down vote favorite I have an application that makes many connections to both SQL and Oracle DBs. Oracle connection throws this exception many times. I did a search and already in found this link http://www.forumtopics.com/busobj/viewtopic.php?p=925784 It looks like a .net issue in Windows as described below "[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." My questions are: 1> Is it possible in .NET to specify the local port range for making connections, e.g., one already in use range of ports dedicate to SQL server connection, and another range of ports to Oracle. 2> How ports are allocated to connections in .Net? So, Time_Wait ports will not be reallocated. 3> For oracle connections, my local ports are allocated with port numbers starting from very high numbers, e.g., 50000, but with SQL Server connections, my local ports start from 5000. Why is that? 4> How to solve this problem? Thanks in advance. Edit: We also experience Timed out exception in the SQLServer connections. I think they are related. c# .net windows oracle tns share|improve this question edited Feb 11 '13 at 10:05 asked Feb 8 '13 at 17:40 Helic 337316 1 How many ports are you using? Looks like you are not properly closing your connections. –Ben Feb 11 '13 at 10:15 @Ben, about 50 ports open for SQLSever connections, 10 for Oracle connections, which is not a very big number. But the number for the ports in Time_Wait state is very high, about 800 for SQLSever connections and 200 for Oracle ones maximum. –Helic Feb 12 '13 at 16:28 are you using connection pooling? Sounds like maybe you have it turned off. System should be reusing connections for most scenarios. Alternatively if every connection string is different (or under a different user context) the connection pooling will be ineffective. –Ben Feb 12 '13 at 16:43 @Ben Yes, the connection pool was turned off. If I turn it on, th
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 68 users online © 2009 psoug.org PSOUG LOGIN Username: Password: Forgot your password?