linuxsirҳ LinuxSir.Org | LinuxBSDSolarisUnix | ԴҲ뻶ӭ
վҳ | Ϊҳ | ղ
ڵλãҳ > Linuxݿ >

OracleORA-00600 [4400]ԭ򼰽

ʱ:2017-05-16  Դ:δ֪  :linuxsirҳ

OracleʵάDBAӳOracleݿֱORA-00600: internal error code, arguments: [4400], [48]ԭΪֲʽйء

һORA-600UEtrace´

Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
ORACLE_HOME = /install1/oracle/bill1/product/9.2.0
System name: AIX
Node name: billing1
Release: 3
Version: 5
Machine: 00CB104D4C00
Instance name: bill1
Redo thread mounted by this instance: 1
Oracle process number: 148
Unix process pid: 1363982, image: oracle@billing1 (TNS V1-V3)

*** SESSION ID:(578.13852) 2012-06-04 12:08:44.492
*** 2012-06-04 12:08:44.492
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [4400], [48], [], [], [], [], [], []

Կϵͳaix 5.3db version9208 ʵ
鿴call stack£

----- Call Stack Trace -----
calling  ķ  ķ  ķ  ķ  ķ  ķ  ķcall  ķ  ķ entry  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķargument values in hex  ķ  ķ 
location  ķ  ķ  ķ  ķ  ķ  ķ type  ķ  ķ point  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķķmeans dubious value)  ķ  ķ
-------------------- -------- -------------------- ----------------------------
ksedmp+0148  ķ  ķ  ķ  ķ  ķbl  ķ  ķ  ķ ksedst  ķ  ķ  ķ  ķ  ķ  ķ  ķ 1029555CC 
ksfdmp+0018  ķ  ķ  ķ  ķ  ķbl  ķ  ķ  ķ 01FD46A8  ķ  ķ  ķ  ķ  ķ  ķ
kgeriv+0118  ķ  ķ  ķ  ķ  ķbl  ķ  ķ  ķ _ptrgl  ķ  ķ  ķ  ķ  ķ  ķ  ķ
kgeasi+00cc  ķ  ķ  ķ  ķ  ķbl  ķ  ķ  ķ kgeriv  ķ  ķ  ķ  ķ  ķ  ķ  ķ 000000002  ķ 1100A2128 
  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ 102954750  ķ 7000001B2B78F30 
  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ 000000000 
ktcddt+013c  ķ  ķ  ķ  ķ  ķbl  ķ  ķ  ķ kgeasi  ķ  ķ  ķ  ķ  ķ  ķ  ķ 110006838  ķ 1103923A8 
  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ 113000001130  ķ 200000002 
  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ 100000001  ķ 000000004 
  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ 000000030  ķ 7000001B1B74EE8 
ktcsod+01f8  ķ  ķ  ķ  ķ  ķbl  ķ  ķ  ķ ktcddt  ķ  ķ  ķ  ķ  ķ  ķ  ķ 110006838  ķ 110006978 
  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ 000000000 
kssdch_stage+02b8  ķ  ķbl  ķ  ķ  ķ _ptrgl  ķ  ķ  ķ  ķ  ķ  ķ  ķ
kssdch+0014  ķ  ķ  ķ  ķ  ķbl  ķ  ķ  ķ kssdch_stage  ķ  ķ  ķ  ķ 000000000  ķ 700000000007D98 
  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ 110002F50 
ktcbod+030c  ķ  ķ  ķ  ķ  ķbl  ķ  ķ  ķ kssdch  ķ  ķ  ķ  ķ  ķ  ķ  ķ 11000D618  ķ 000000008 
kssdch_stage+02b8  ķ  ķbl  ķ  ķ  ķ _ptrgl  ķ  ķ  ķ  ķ  ķ  ķ  ķ
kssdch+0014  ķ  ķ  ķ  ķ  ķbl  ķ  ķ  ķ kssdch_stage  ķ  ķ  ķ  ķ 110002F50  ķ 110061758 
  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ 000000009 
ksuxds+1118  ķ  ķ  ķ  ķ  ķbl  ķ  ķ  ķ kssdch  ķ  ķ  ķ  ķ  ķ  ķ  ķ 1000E82E4  ķ 000000000 
ksudel+006c  ķ  ķ  ķ  ķ  ķbl  ķ  ķ  ķ ksuxds  ķ  ķ  ķ  ķ  ķ  ķ  ķ 7000001AB716A20  ķ 100000001 
opilof+03dc  ķ  ķ  ķ  ķ  ķbl  ķ  ķ  ķ 01FD4914  ķ  ķ  ķ  ķ  ķ  ķ
opiodr+08cc  ķ  ķ  ķ  ķ  ķbl  ķ  ķ  ķ _ptrgl  ķ  ķ  ķ  ķ  ķ  ķ  ķ
ttcpip+0cc4  ķ  ķ  ķ  ķ  ķbl  ķ  ķ  ķ _ptrgl  ķ  ķ  ķ  ķ  ķ  ķ  ķ
opitsk+0d60  ķ  ķ  ķ  ķ  ķbl  ķ  ķ  ķ ttcpip  ķ  ķ  ķ  ķ  ķ  ķ  ķhttp://www.oracleplus.net 11000D4C0  ķ 000000000 
  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ 000000000  ķ 000000000 
  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ 000000000  ķ 000000000 
  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ 000000000  ķ 000000000 
opiino+0758  ķ  ķ  ķ  ķ  ķbl  ķ  ķ  ķ opitsk  ķ  ķ  ķ  ķ  ķ  ķ  ķ 000000000  ķ 000000000 
opiodr+08cc  ķ  ķ  ķ  ķ  ķbl  ķ  ķ  ķ _ptrgl  ķ  ķ  ķ  ķ  ķ  ķ  ķ
opidrv+032c  ķ  ķ  ķ  ķ  ķbl  ķ  ķ  ķ opiodr  ķ  ķ  ķ  ķ  ķ  ķ  ķ 3C00000018  ķ 4101FAA40 
  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ FFFFFFFFFFFF8F0  ķ 0A0012010 
sou2o+0028  ķ  ķ  ķ  ķ  ķ bl  ķ  ķ  ķ opidrv  ķ  ķ  ķ  ķ  ķ  ķ  ķ 3C0C000000  ķ 4A0059B20 
  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ FFFFFFFFFFFF8F0 
main+0138  ķ  ķ  ķ  ķ  ķ  ķbl  ķ  ķ  ķ 01FD40E8  ķ  ķ  ķ  ķ  ķ  ķ
__start+0098  ķ  ķ  ķ  ķ bl  ķ  ķ  ķ main  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ 000000000  ķ 000000000 

mosϹڸô:
PURPOSE:  ķ  ķ  ķ  ķ  ķ 
  ķThis article discusses the internal error "ORA-600 [4400]", what  ķit means and possible actions. The information here is only applicable  ķto the versions listed and is provided only for guidance.

ERROR:  ķ  ķ  ķ  ķ  ķ  ķ 
  ķORA-600 [4400] [a] [b] [c] [d] [e]

VERSIONS:
  ķversions 6.0 to 11

DESCRIPTION:

  ķInternal error 4400 means that we are trying to delete a transaction (for  ķexample at logoff time) but the transaction has not yet been marked  ķcompleted.

  ķThis can happen at the remote site in a distributed transaction if the  ķfirst part of the first stage of a two phase commit gets an error before  ķit really starts the protocol.

FUNCTIONALITY:  ķ  ķ 
  ķTRANSACTION CONTROL

IMPACT:  ķ  ķ  ķ  ķ  ķ  ķ
  ķPROCESS FAILURE - but only at logoff so minimal impact
  ķNON CORRUPTIVE - No underlying data corruption.

ĵ˵4400ǸֲʽйأҲٹڷֲʽǰҲдһƪORA-01591: lock held by in-doubt distributed transaction

Ըô󣬶Աcall stack Է֣ȫһ£ĵ˵ôȫԺԣ£

ORA-00600 [4400], [48], [], [], [], [] From a Distributed Transaction [ID 464861.1]

Symptoms
The following error is reported on 9.2.0.5:

ORA-00600: internal error code, arguments: [4400], [48], [], [], [], [], [], []

The call stack is:

ksedmp ksfdmp kgeriv kgeasi ktcddt ktcsod kssdch_stage kssdch ktcbod
kssdch_stage kssdch PGOSF40__ksuxds ksudel kxfprdp opirip opidrv sou2o

Cause
The error is encountered due to Bug 3840810 which was fixed in version 10.1.0.3.

The error is encountered when there is a dblink between 8i and 9i/10g databases. This error is only raised
in the log-off of the local session while trying to delete a transaction but the transaction has not yet
been marked completed. This lack of information is caused by the bug and if there is no process failure due
to this error, it can be ignored since there is no SQL statement/session affected.

This bug has been fixed by architectural changes in 10g and unfortunately is not backportable to 9.2.

If this is an one time occurrence then it can be safely ignored.

ǿԴtraceҵϢ

BH (0x700000134fdd900) file#: 405 rdba: 0x65403498 (405/13464) class 1 ba: 0x700000134764000
  ķset: 84 dbwrid: 3 obj: 343488 objn: 343488
  ķhash: [700000070fead00,700000163feec00] lru: [7000000e8fe6d68,70000013ffe8468]
  ķLRU flags: hot_buffer
  ķckptq: [7000000aefe93d8,700000088fe2dd8] fileq: [7000001b1174040,7000000eefc73e8]
  ķst: XCURRENT md: NULL rsop: 0x0 tch: 5
  ķflags: buffer_dirty gotten_in_current_mode block_written_once
  ķ  ķ  ķ  ķ  ķredo_since_read
  ķLRBA: [0x3e7cf.396e5.0] HSCN: [0x0bac.2f283f13] HSUB: [1] RRBA: [0x0.0.0]
  ķbuffer tsn: 32 rdba: 0x65403498 (405/13464)
  ķscn: 0x0bac.2f283f13 seq: 0x01 flg: 0x02 tail: 0x3f130601
  ķfrmt: 0x02 chkval: 0x0000 type: 0x06=trans data
Block header dump:  ķ0x65403498

Itl  ķ  ķ  ķ  ķ  ķ Xid  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķ  ķUba  ķ  ķ  ķ  ķ Flag  ķLck  ķ  ķ  ķ  ķScn/Fsc
0x01  ķ 0x0040.026.00167771  ķ0x7203e25c.0f91.02  ķC---  ķ  ķķscn 0x0bac.2f26d569
0x02  ķ 0x008c.04b.002ae01f  ķ0x7242e607.0089.07  ķC---  ķ  ķķscn 0x0bac.2f26d709
0x03  ķ 0x0043.04f.00184d78  ķ0x720020a7.e5ff.2f  ķC---  ķ  ķķscn 0x0bac.2f28047f
.......
0x30  ķ 0x0005.041.001d254f  ķ0x228560f5.c941.0e  ķ--U-  ķ  ķķfsc 0x0075.2f282d74
........
0x3f  ķ 0x008e.012.0029e870  ķ0x22801e5b.0444.06  ķC---  ķ  ķķscn 0x0bac.2f26d4de
0x40  ķ 0x0005.000.001d261c  ķ0x228560f5.c941.0a  ķ--U-  ķ  ķķfsc 0x007b.2f282d25
.........
0x61  ķ 0x0020.004.000bc447  ķ0x7203ce74.e107.12  ķC---  ķ  ķķscn 0x0bac.2f26d66a
0x62  ķ 0x0049.04c.001e453a  ķ0x2a42eb96.ffe3.06  ķC---  ķ  ķķscn 0x0bac.2f26d647

LRBA recover㣬checkpointҿԲοoracle checkpoint

ԿfalgCUʾύ˵ģ˵ȷʵûκӰ졣

OracleϢOracle רҳ http://www.linuxidc.com/topicnews.aspx?tid=12