Internal Error 3113
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-03137 Ttc Protocol Internal Error 12333
ORA-03137: TTC ora-03137: ttc protocol internal error : [3120] protocol internal error Oracle Database Tips by Burleson Consulting May 16, 2016 Question: What causes the ORA-031237 error? Errors ora-03137: ttc protocol internal error : [12209] in file /opt/oracle/diag/rdbms/trace/OMNIDB2_ora_2729.trc: ORA-03137: TTC protocol internal error : [12333] [4] [195] [2] Answer: The oerr utility shows this for the ORA-03137 error: ORA-03137 TTC protocol internal error: [%s] [%s] [%s] [%s]
Ora-03137: Ttc Protocol Internal Error : [3149]
[%s] [%s] [%s] [%s]"Cause: TTC protocol internal error.Action: Contact Oracle Support As we see, there is an associated trace file and this file will have more information on the ORA-03137 error. This is usually a bug. This is an internal error and you need to open a SR on MOSC. In 11g, there is fix by upgrading to Oracle 11.1.0.7. and a workaround by
Ora-03137: Ttc Protocol Internal Error 12c
setting "_optim_peek_user_binds"=false. Set this parameter ON LY with the consent of MOSC. Solarwinds notes this on the ORA-03137 "Although upgrading to database version 11.1.0.7 has been confirmed to have solved this issue in a high number of cases, error ORA-03137 [12333] accompanied by Protocol Violation messages may still occur intermittently in database versions prior to 11.2, including database 10.2.0.4 and 11.1.0.7. This has been reported in unpublished bug:8625762 ORA-3137 [12333] due to bind data not read from wire, in which case ORA-3137 [12333] can occur intermittently for SQL which uses user binds due to bind data being left unread on the Net connection. The bug suggests the workaround of setting "_optim_peek_user_binds"=false to avoid this problem (workaround to be used with caution as it can affect execution plans chosen by CBO), and also provides the fix by the application of Patch:8625762" MOSC References: - ORA-600 [12333] / ORA-03137 [12333] Troubleshooting [ID 828123.1] - NOTE:752297.1 - ORA-03137: TTC Protocol Internal Error : [12333] Using JDBC Driver- NOTE:35928.1 - ORA-600 [12333] "Fatal Two-Task Protocol Violation" - ORA-7445 [kxsOpenACursor()+1087] & ORA-03137 [12209] Errors [MOSC ID 1325759.1] - MOSC patch 9703463 for ORA-03137. - Bug #7
Life (7) 其他 (6) 读书 (1) Nosql (1) hadoop (1) Oracle rdbms (278) 11gR2 (22) ASM (28) backup & rcovery (72) EM Cloud Control 12c (1) Goldengate (13) mangement (57) Materialized Views (3) oracle database 12c (6) oracle ora-03137: ttc protocol internal error : [1010] internal (23) rac & dg (32) troubleshooting (45) tunning (12) Unix/linux
What Is Ttc Protocol
(4) 未分类 (1) Archives 2016 年十月 2016 年八月 2016 年七月 2016 年五月 2016 年四月 2016 年三月 2016 年二月 ora-03137: ttc protocol internal error : [3113] [] [] [] [] [] [] [] 2016 年一月 2015 年十二月 2015 年十一月 2015 年十月 2015 年九月 2015 年八月 2015 年七月 2015 年六月 2015 年五月 2015 年四月 2015 年三月 2015 年二月 2015 年一月 2014 年十二月 2014 http://www.dba-oracle.com/t_ora_03137_ttc_protocol_internal_error.htm 年十一月 2014 年十月 2014 年九月 2014 年八月 2014 年七月 2014 年六月 2014 年五月 2014 年四月 2014 年三月 2014 年二月 2014 年一月 2013 年十二月 2013 年十月 2013 年九月 2013 年八月 2013 年七月 2013 年六月 2013 年五月 2013 年四月 2013 年三月 2013 年二月 2013 年一月 2012 年十二月 2012 年十一月 2012 年十月 2012 年九月 2012 年八月 2012 年七月 2012 年六月 2012 http://www.killdb.com/2015/06/22/ora-03137-ttc-protocol-internal-error-3113-in-11-2-0-4.html 年五月 2012 年四月 2012 年三月 2012 年二月 2012 年一月 2011 年十二月 2011 年十一月 2011 年十月 2011 年九月 2011 年八月 2011 年七月 2011 年六月 Tag Cloud 3D 10.2.0.4 10.2.0.5 11.2.0.3 11.2.0.4 amdu ASM bbed dbms_rowid file directory Goldengate instance crash kclchkblk_4 kfed linux odu ORA-00202 ORA-00283 ORA-00312 ora-00600 ora-00600 2662 ora-00600 4194 ORA-00604 ORA-00704 ORA-01110 ORA-01190 ORA-01547 ora-01555 ORA-08102 ORA-12012 ORA-15078 ORA-15080 ORA-15196 ORA-27072 oracle oracle 12c oracle psu oracle rac psu rman strace wallet x$kffxp [6006] [kccpb_sanity_check_2] [kdsgrp1]WP Cumulus Flash tag cloud by Roy Tanck requires Flash Player 9 or better. 最新评论drop用户hang住解决思路 | SEARU.ORG 在 About Oracle Hanganalyze 上的评论ron 在 耗时一周的某客户Oracle RAC(4 TB ASM) 数据库恢复记录 上的评论oracle asm 剖析系列(2)PST/FST/allocator tabe | Burning 在 asm 添加disk时,ctrl+C导致diskgroup无法mount 上的评论oracle asm 剖析系列(1) –disk header | Burning 在 oracle asm 剖析系列(1) -disk header 上的评论sqlora 在 Insert into is very slowly,why ? 上的评论wang 在 ora-00600 [kgeade_is_0] 上的评论ivanwu 在 某客户的5TB RAC 恢复小记 上的评论Cedrik Morano 在 Step by Step oracle database 10gR2 upgrade to 11.2.0.2 上的评论测试页面 | The quieter you become,the more you are able to hear. 在 通过调整_lm_cache_res_cleanup解决shared Pool问题 上的
and https://scn.sap.com/thread/2004962 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 internal error 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 ttc protocol internal 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 Coll