Shulou(Shulou.com)06/01 Report--

Trace file / opt/oracle/app/oracle/diag/rdbms/suseora/suseora2/trace/suseora2_ora_36386.trc

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP

Data Mining and Real Application Testing options

ORACLE_HOME = / opt/oracle/app/oracle/product/11.2.0/db

System name: Linux

Node name: usdprac2

Release: 2.6.32.12-0.7-default

Version: # 1 SMP 2010-05-20 11:14:20 + 0200

Machine: x86_64

Instance name: suseora2

Redo thread mounted by this instance: 2

Oracle process number: 299

Unix process pid: 36386, p_w_picpath: oracle@usdprac2

* * 2017-05-08 15 15! 39! 49. 842

* SESSION ID: (2080.60679) 2017-05-08 15 purl 39purl 49.842

* CLIENT ID: () 2017-05-08 15 purl 39purl 49.842

* SERVICE NAME: (suseora) 2017-05-08 15 purl 39purl 49.842

* MODULE NAME: (JDBC Thin Client) 2017-05-08 15 purl 39purl 49.842

* ACTION NAME: () 2017-05-08 15 purl 39purl 49.842

* SESSION ID: (2080.60679) 2017-05-08 15 purl 39purl 49.842

OBJD MISMATCH typ=35, seg.obj=-2, diskobj=8677570, dsflg=0, dsobj=489719, tid=489719, cls=4

DDE: Problem Key 'ORA 600 [ktecgsc:kcbz_objdchk]' was flood controlled (0x2) (incident: 227593)

ORA-00600: internal error code. Parameters: [ktecgsc:kcbz_objdchk], [0], [0], [1], [], []

Input data (nil), 0,0

Formatted dump of block:

Buffer tsn: 7 rdba: 0x0826fc91 (32 amp 2555025)

Scn: 0x00a2.032d48c7 seq: 0x02 flg: 0x04 tail: 0x48c72302

Frmt: 0x02 chkval: 0xc05e type: 0x23=PAGETABLE SEGMENT HEADER

Hex dump of block: st=0, typ_found=1

Query:

1. Query relevant segment information

Col owner format a10

Col object_name format a30

Select object_id, data_object_id, owner, object_name, object_type from dba_objects where data_object_id in (8677570, 489718) or object_id in (8677570, 489718)

two。 Query segment details

Select * from seg$ where file#=32 and block#=2555025

3. Query related data files

Col name format a30

Select name from v$datafile where file#=32

4. Query tablespace information

Select * from v$tablespace where ts#=7

5. Query relevant area information

Select owner,segment_name,partition_name,segment_type,block_id from dba_extents where relative_fno=32 and 2555025 between block_id and block_id+blocks

Select owner,segment_name,partition_name,segment_type,block_id from dba_extents where block_id=

Reason:

After MOS query analysis, this error triggers BUG:19689979.

The BUG is caused by a table partition that is being accessed by truncate or drop.

The object that triggers the BUG is:

SYS@suseora2 > select OWNER,SEGMENT_NAME,PARTITION_NAME,SEGMENT_TYPE,BLOCK_ID from DBA_EXTENTS where RELATIVE_FNO=9 and 424849 between BLOCK_ID and BLOCK_ID+BLOCKS

OWNER SEGMENT_NAME PARTITION_NAME SEGMENT_TYPE BLOCK_ID

-

USDPCENTER T_PERSONALLIB P42 TABLE PARTITION 424832

Solution:

1. Flush shared pool when a problem occurs.

two。 Modify the implied parameter _ part_access_version_by_number to false. (RAC needs to restart each node at the same time to modify this parameter)

The flush pool has been shared so far. The error was not found after flush.

Http://t.askmaclean.com/thread-3747-1-1.html

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.