2017.10.20, Guizhou, a city, Oracle 11.2.0.1 Health insurance-related applications function abnormal can not run, check the database alarm log has the following error:
Fri OCT 20 16:03:04 2017
Trace dumping is performing id=[cdmp_20171020160304]
Fri OCT 20 16:03:05 2017
Sweep [inc][140434]: Completed
Sweep [inc2][140434]: Completed
Fri OCT 20 16:12:40 2017
Errors in File E:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_4756.trc (incident=140155):
ORA-03137:TTC protocol Internal error: [12333] [6] [50] [48] [] [] [] []
Incident Details IN:E:\APP\ADMINISTRATOR\DIAG\RDBMS\ORCL\ORCL\INCIDENT\INCDIR_140155\ORCL_ORA_4756_I140155.TRC
Fri OCT 20 16:12:41 2017
Trace dumping is performing id=[cdmp_20171020161241]
To view the TRC file for the alert log prompt:
2017-10-20 16:12:40.170
SESSION ID: (515.23643) 2017-10-20 16:12:40.170
CLIENT ID: () 2017-10-20 16:12:40.170
SERVICE NAME: (ORCL) 2017-10-20 16:12:40.170
MODULE NAME: () 2017-10-20 16:12:40.170
ACTION NAME: () 2017-10-20 16:12:40.170
Dump continued from FILE:E:\APP\ADMINISTRATOR\DIAG\RDBMS\ORCL\ORCL\TRACE\ORCL_ORA_4756.TRC
ORA-03137:TTC protocol Internal error: [12333] [6] [50] [48] [] [] [] []
========= Dump for incident 140155 (ORA 3137 [12333]) ========
2017-10-20 16:12:40.170
Dbkeddefdump (): Starting incident default dumps (flags=0x2, level=3, mask=0x0)
-----current SQL Statement to this session (SQL_ID=905VD7VNPUH6N)-----
SELECT *
From (select Row_.*, RowNum numrow from (SELECT *
Sid
Code
To_char (month, ' Yyyymm ') as month,
Hisid,
Bill_no,
State
Billdate,
HOSPITAL_ID,
PATIENT_ID,
Patient_name,
Admission_number,
Admission_disease_name,
Disease_name,
Claim_name,
Benefit_name,
Bmino,
Benefit_group_name,
Item_date,
DEPT_ID,
Dept_name,
ITEM_ID,
Item_name,
Item_type,
Physician_name,
Bmi_convered_amount,
Bmi_nopay,
Reject_reson,
REMRK,
Version_no,
Hospital_backs,
Versionstate,
Rule_name,
Back_reson,
Reback_reason,
Processstate,
Is_approval,
NVL (version,1) as version,
NVL (trickprogress,0) as Trickprogress,
NVL (is_retrick,0) as Is_retrick,
PERIOD,
Billex. NUMBER01 as Number01,
Billex. NUMBER02 as Number02,
Billex. NUMBER03 as NUMBER03,
Billex. NUMBER05 as Number05,
Billex. NUMBER06 as Number06,
Billex. NUMBER07 as Number07,
Hospital_remark_detail,
Decode (Bitand ((select SUM (Distinct (NVL (g.rule_bit, 0)) from Gz_list g where G.business_type = ' 0 '), rule_bit), 0,0,1) as B Usiness_type,
Refeedback_reason_detail,
(select SUM (A.reject_money) from Dw_opinion_details B joins Dw_billdetail A on a.id =b.detailid
where B.code=dw_opinions.code and B.version_no=dw_opinions.version_no and B.month=dw_opinions.month) as Sumrejectmoney
From Dw_opinions left join dw_bill_ex billex on dw_opinions.hisid = Billex.billid
where 1=1 and Month =to_date (:P aramMonth0, ' yyyymm ') and hospital_id =:P aramHospitalId1 and version_no =: Versionno2 order By month Desc,sid)) Row_ where rownum <= 10)
where Numrow > 0
Query Oracle Metalink learned that this is a Bug 9445675 (document ID 1361107.1) of Oracle 11.2.0.1 itself, related to the binding variables of the Oracle database
According to the TRC file hints to the SQL, SQL statements do use binding variables, to solve the problem of 3 ways:
1, cancel the database binding variable snooping: Alter system set "_optim_peek_user_binds" =FALSE;
Note Unbind variable snooping has an impact on the database and changes the SQL execution plan
2. Patching the database
PSU 11.1.0.7.8 Patch 12419384 includes patch:9703463
For 11.1.0.7, Patch 9243912
Patch:9703463 can also is applied individually but requires PSU 11.1.0.7.6
PATCH:8625762 may also is applicable to databases version 11.1.0.7
PATCH:18841764 fixes the SQL Loader issue that may affect database version 12.1.0.2
3, upgrade the database to 11.2.0.3 and above version
Because the project function uses emergency, temporarily cancels the database binding variable, the application function is able to use normally, afterwards then does the Oracle 11.2.0.1 to 11.2.0.4 upgrade.
This article is from the "Breeze ai ai" blog, please be sure to keep this source http://3596022.blog.51cto.com/3586022/1975897
Oracle 11.2.0.1 for Windows SERVER2008R2 alarm ORA-03137