Oracle Java.sql.sqlrecoverableexception Io Error Socket Read Timed Out
Contents |
Speaker BureauLog inRegisterSearchSearchCancelError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled.
Io Error Socket Read Timed Out Sql Developer
Please turn JavaScript back on and reload this page. socket read timed out oracle 11g Please enter a title. You can not post a blank message. Please type your oracle.net.ns.netexception: socket read timed out message and try again. More discussions in Java Database Connectivity (JDBC) All PlacesJavaDatabase ConnectivityJava Database Connectivity (JDBC) This discussion is archived 2 Replies
Oracle Database Socket Read Timed Out
Latest reply on Dec 23, 2014 7:43 PM by jschellSomeoneStoleMyAlias JDBC pooling Oracle driver Socket read timed out 2817203 Dec 18, 2014 8:45 PM I run Java EE application on Glassfish server v3 together with Oracle 12 DB on the same machine under Windows Server 2012
Io Error Socket Read Timed Out Vendor Code 17002
64bit. I use latest ojdbc7 driver.Connection pool config:
log in tour help Tour Start here for a quick overview of io error: connection timed out the site Help Center Detailed answers to any questions
Java Sql Sqlexception Socket Read Timed Out Oracle
you might have Meta Discuss the workings and policies of this site About Us java.sql.sqlrecoverableexception: io error: connection timed out Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Database Administrators Questions Tags https://community.oracle.com/thread/3642139 Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute: Sign up Here's how it works: http://dba.stackexchange.com/questions/86460/jdbc-pooling-oracle-driver-socket-read-timed-out Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top JDBC pooling Oracle driver Socket read timed out up vote 2 down vote favorite I run Java EE application on Glassfish server v3 together with Oracle 12 DB on the same machine under Windows Server 2012 64bit. I use latest ojdbc7 driver. Connection pool config:
java.sql.SQLRecoverableException: IO Error: Socket read timed out during adop/adpatch While applying the R12.2 upgrade driver, we faced the issue of WFXLoad.class failing in adworker log but showing up as running on adctrl Control Worker Code Context Filename http://oracleappstechnology.blogspot.com/2014/11/mystery-of-javasqlsqlrecoverableexcepti.html Status ------ -------- ----------------- -------------------------- -------------- 1 Run AutoPatch R120 pl WFXLoad.class Running 2 Run AutoPatch https://scn.sap.com/thread/1470761 R120 pl WFXLoad.class Running 3 Run AutoPatch R120 pl WFXLoad.class Running 4 Run timed out AutoPatch R120 pl WFXLoad.class Running 5 Run AutoPatch R120 pl WFXLoad.class Running 6 Run AutoPatch R120 pl Wait 7 Run AutoPatch R120 pl WFXLoad.class socket read timed Running 8 Run AutoPatch R120 pl WFXLoad.class Running 9 Run AutoPatch R120 pl WFXLoad.class Running 10 Run AutoPatch R120 pl Wait adworker log shows: Exception in thread "main" java.sql.SQLRecoverableException: IO Error: Socket read timed out at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:482) at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:678) at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:238) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:34) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:567) at java.sql.DriverManager.getConnection(DriverManager.java:571) at java.sql.DriverManager.getConnection(DriverManager.java:215) at oracle.apps.ad.worker.AdJavaWorker.getAppsConnection(AdJavaWorker.java:1041) at oracle.apps.ad.worker.AdJavaWorker.main(AdJavaWorker.java:276) Caused by: oracle.net.ns.NetException: Socket read timed out at oracle.net.ns.Packet.receive(Packet.java:341) at oracle.net.ns.NSProtocol.connect(NSProtocol.java:308) at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1222) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:330) ... 8 more This was happening again and again. The DBAs were suspecting network issue, cluster issue, server issue and all the usual suspects. In Database alert log we saw these errors coming every few seconds: Fatal NI connect error 12537, connecting to: (LOCAL=NO) VERSION INFORMATION: TNS for Linux: Version 11.2.0.3.0 - Production Oracle Bequeath NT Protocol Adapter
and SafetyAsset NetworkAsset Operations and MaintenanceCommerceOverviewSubscription Billing and Revenue ManagementMaster Data Management for CommerceOmnichannel CommerceFinanceOverviewAccounting and Financial CloseCollaborative Finance OperationsEnterprise Risk and ComplianceFinancial Planning and AnalysisTreasury and Financial 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 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 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 ManagementData ManagementEnterprise Man