Oracle Error Code 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 already tns-12542: tns:address already in use tns-12560: tns:protocol adapter error in use tips Oracle Database Tips by Burleson Consulting August 24, 2015 Question: I am able to make 42 linux error: 98: address already in use 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 error?
Tns-12542 Tns Address Already In Use Windows
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 in
Tns-12542 Tns-12560 Tns-00512
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 available user port from
and SafetyAsset NetworkAsset Operations and MaintenanceCommerceOverviewSubscription tns-12542 tns-12560 tns-00512 linux error 98 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 error listening on: (address=(protocol=tcp)(host=)(port=1521)) AnalysisTreasury and Financial Risk ManagementHuman ResourcesOverviewCore Human Resources and PayrollHuman Capital AnalyticsTalent ManagementTime and Attendance ManagementManufacturingOverviewManufacturing NetworkManufacturing OperationsResponsive http://www.dba-oracle.com/t_ora_12542_tns_address_already_in_use.htm ManufacturingMarketingOverviewMarket with Speed and AgilityUnique Customer ExperiencesReal-Time Customer InsightsR&D/EngineeringOverviewDesign NetworkDesign OrchestrationProject and Portfolio ManagementSalesOverviewCollaborative Quote to CashSales Force AutomationSales Performance ManagementSelling Through Contact CentersServiceOverviewEfficient Field Service ManagementOmnichannel Customer ServiceTransparent Service Process and OperationsSourcing and ProcurementOverviewContingent Workforce https://scn.sap.com/thread/3766064 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 IntelligencePredictive AnalyticsGovernance, Risk, and ComplianceEnterprise Performance ManagementApplication Platform and InfrastructureOverviewApplication PlatformContent and CollaborationInterface ManagementProcess Management and IntegrationData ManagementOverviewBig Data on HadoopData WarehousingDatabase ManagementEnterprise Information ManagementIT ManagementOverviewApplication Lifecycle ManagementIT Infrastructure ManagementSecurity SoftwareOverviewApplication and IT Infrastructure SecurityIdentity, Access and Authentication ManagementBrowse by ProductAnalyticsContent and CollaborationCustomer Relationship ManagementDat
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 http://stackoverflow.com/questions/14778258/oracle-ora-12542-tnsaddress-already-in-use-in-c-sharp About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack 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 already in 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 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 already in use 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 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 5