資訊專欄INFORMATION COLUMN
問題現(xiàn)象
Wed Aug 20 14:06:50 2022
Errors in file /oracle/app/oracle/diag/rdbms/ywxt/ywxt2/trace/ywxt2_ora_59862.trc (incident=1208525):
ORA-00600: internal error code, arguments:
[kdsgrp1], [], [], [], [], [], [], [], [], [], [], []
問題分析
*** 2022-08-19 10:05:19.829
row 0x0a6a4b9c.19 continuation at
0x0a6a4b9c.19 file# 41 block# 2771868 slot 25 not found 《----- file# 41 block# 2771868 not found
KDSTABN_GET: 0 ..... ntab: 1
curSlot: 25 ..... nrows: 39
kdsgrp - dump CR block dba=0x0a6a4b9c
Block header dump: 0x0a6a4b9c
Object id on Block? Y
seg/obj: 0x1ca0c csc: 0x2a.5e206ae9 itc: 2 flg: E typ: 1 - DATA
brn: 0 bdba: 0xa6a4b80 ver: 0x01 opc: 0
inc: 0 exflg: 0
Itl Xid Uba Flag Lck Scn/Fsc
0x01 0x018e.005.001e0977 0x1d401e36.7073.11 --U- 1 fsc 0x0000.84da8603
0x02 0x06a7.020.000d23ad 0x20c2c6f3.6c1e.09 --U- 1 fsc 0x0007.5e206b67
bdba: 0x0a6a4b9c
ObjectName: Name=SELECT OBJECTID, ENTITYID, METACATEGORY, VIEWLABEL, DRAWFLAG, SHAPE, CREATOR_ID, CREATE_DATE, MODIFIER_ID, MODIFY_DATE, VERSION, SHARDING_ID, REGION_ID, PROJECT_ID, LIFE_STATE_ID, SOURCE_ID, SOURCE_TABLE, IS_PROTECTION_ID, SITE_TYPE_ID, SITE_DEVICE_TYPE, IRMS.X_GIS_POINTSITE.SE_ANNO_CAD_DATA FROM IRMS.X_GIS_POINTSITE WHERE mdsys.sdo_filter(IRMS.X_GIS_POINTSITE.SHAPE, MDSYS.SDO_GEOMETRY(:gtype1,:srid1,NULL,:elem_info1,:ordinates1), querytype=window) = TRUE AND (( ( ( ( SHARDING_
FullHashValue=5ad82e7688f2b341fe75c70cd788cf75 Namespace=SQL AREA(00) Type=CURSOR(00) Identifier=3616067445 OwnerIdn=96
SELECT OBJECTID, ENTITYID, METACATEGORY, VIEWLABEL, DRAWFLAG, SHAPE, CREATOR_ID,
CREATE_DATE, MODIFIER_ID, MODIFY_DATE, VERSION, SHARDING_ID, REGION_ID, PROJECT_ID,
LIFE_STATE_ID, 0, SOURCE_ID, SOURCE_TABLE, MAP_LENGTH, CABLE_TYPE_ID,
IRMS.X_GIS_LINECABLESEG.SE_ANNO_CAD_DATA FROM IRMS.X_GIS_LINECABLESEG WHERE
mdsys.sdo_filter(IRMS.X_GIS_LINECABLESEG.SHAPE, MDSYS.SDO_GEOMETRY(:gtype1,:srid1,NULL,:elem_info1,:ordinates1),
querytype=window) = TRUE AND (( ( SHARDING_ID = 561 AND ( 1 = 1 OR LIFE_STATE_ID IS NULL)) ) AND
( METACATEGORY =OCABLESECTION ))
問題排查
3.1 排查物理損壞
select OBJECTID, a.valid "Error"
from (select OBJECTID , sdo_geom.validate_geometry_with_context(shape,m.diminfo) Valid
from IRMS.X_GIS_POINTSITE, user_sdo_geom_metadata m
where m.table_name = X_GIS_POINTSITE and m.column_name = SHAPE) a
where a.valid != NULL
and a.valid != TRUE
/spool check_valid_geometries.lst
create table val_results (sdo_rowid ROWID, result VARCHAR2(2000));
exec sdo_geom.validate_layer_with_context(IRMS.X_GIS_POINTSITE,SHAPE,VAL_RESULTS);
select * from VAL_RESULTS;
spool off文章版權(quán)歸作者所有，未經(jīng)允許請(qǐng)勿轉(zhuǎn)載,若此文章存在違規(guī)行為，您可以聯(lián)系管理員刪除。
轉(zhuǎn)載請(qǐng)注明本文地址：http://systransis.cn/yun/129116.html
摘要：新晉技術(shù)專家下面是墨天輪部分新晉的技術(shù)專家。大家可以點(diǎn)擊往期閱讀墨天輪技術(shù)專家邀請(qǐng)函了解詳情，申請(qǐng)成為我們的技術(shù)專家，加入專家團(tuán)隊(duì)，與我們一起創(chuàng)建一個(gè)開放互助的數(shù)據(jù)庫技術(shù)社區(qū)。新關(guān)聯(lián)公眾號(hào)墨天輪是一個(gè)開放互助的數(shù)據(jù)庫技術(shù)社區(qū)。 引言 近期我們?cè)贒BASK小程序增加了數(shù)據(jù)庫 MongoDB、Redis、 Elasticsearch、DB2、Weblogic 等新的的專題欄目和一些新的技術(shù)...
摘要：開始程序安裝產(chǎn)品卸裝所有產(chǎn)品，但本身不能被刪除如果第二步執(zhí)行失敗，跳到第三步，大部份第二步是失敗的運(yùn)行，選擇，按鍵刪除這個(gè)入口。下所有刪除下所有刪除下所有刪除運(yùn)行，下所有刪除，刪除所有入口。在運(yùn)行框中輸入，回車。 Oracle11g的安裝教程 同時(shí)解壓縮兩個(gè)zip文件，生成一個(gè)database文件夾，進(jìn)入到database文件夾，點(diǎn)擊setup showImg(https://segm...
閱讀 1435·2023-01-11 13:20
閱讀 1796·2023-01-11 13:20
閱讀 1249·2023-01-11 13:20
閱讀 1988·2023-01-11 13:20
閱讀 4212·2023-01-11 13:20
閱讀 2849·2023-01-11 13:20
閱讀 1468·2023-01-11 13:20
閱讀 3766·2023-01-11 13:20
