aodu(At Oracle Database Utility)之ora600

ORA-600是Oracle数据库内部错误代码表示，参数不同，表示的类型也不一样，可能是Cache Layer，Transaction Layer等。aodu的ora600函数，提供基本的搜索功能。用法为：ora600 <错误代码> ，ora600 <关键字的前两个字母>

ora600 <错误代码>

[root@ohs1 linux]# ./aodu
At Oracle Database Utility,Release 1.1.0 on Tue Jun 14 13:33:33 2016
Copyright (c) 2014, 2015, Robin.Han.  All rights reserved.
http://ohsdba.cn
WeChat:ohsdba
Cell:186-9589-1286
E-Mail:375349564@qq.com

AODU> ora600 4000
         ****Transaction Layer****
         BaseCode=4000,Function module=server/txn,source=ktu.c, Description=Kernel Transaction Undo.
AODU> ora600 3000
         ****Cache Layer****
         BaseCode=3000,Function module=server/rcv,source=kcra.c, Description=Kernel Cache Redo Application/Access
AODU>

ora600 <关键字的前两个字母>

 Error=kta,Function Module=space/spcmgmt,Description=support for DML locks and temporary tables associated with table access

 Error=ktb ktbt ktc,Function Module=txn/lcltx,Description=transaction control operations at the block level : locking block, allocating space within the block , freeing up space, etc.

 Error=ktec ktef ktehw ktein ktel kteop kteu,Function Module=space/spcmgmt,Description=extent concurrency operations; ktef - extent format; ktehw - extent high water mark operations; ktein - extent  information operations; ktel - extent support for sql loader; kteop - extent operations : add extent to segment, delete extent, resize extent, etc. kteu - redo support for operations changing segment header / extent map

 Error=ktf,Function Module=txn/lcltx,Description=flashback support

 Error=ktfb ktfd ktft ktm,Function Module=space/spcmgmt,Description=ktfb - support for bitmapped space manipulation of files/tablespaces;  ktfd - dictionary-based extent management; ktft - support for temporary file manipulation; ktm - SMON operation

 Error=ktp ktpr ktr ktri,Function Module=txn/lcltx,Description=ktp - support for parallel transaction operation; ktpr - support for parallel transaction recovery; ktr - kernel transaction read consistency; ktri - support for dbms_resumable package

 Error=ktsa ktsap ktsau ktsb ktscbr ktsf ktsfx ktsi ktsm ktsp ktss ktst ktsx ktt kttm,Function Module=space/spcmgmt,Description=support for checking and verifying space usage

 Error=ktu ktuc ktur ktusm,Function Module=txn/lcltx,Description=internal management of undo and rollback segments

 Error=kcb kcbb kcbk kcbl kcbs kcbt kcbw kcbz,Function Module=cache,Description=manages Oracle buffer cache operation as well as operations used by capabilities such as direct load,has clusters,etc.

 Error=kcc kcf,Function Module=rcv,Description=manages and coordinates operations on the control file(s)

 Error=kcit,Function Module=context/trigger,Description=internal trigger functionality

 Error=kck,Function Module=rcv,Description=compatibility related checks associated with the compatible parameter

 Error=kcl,Function Module=cache,Description=background lck process which manages locking in a RAC or parallel server multiple instance environment

 Error=kco kcq kcra kcrf kcrfr kcrfw kcrp kcrr kcs kct kcv,Function Module=rcv,Description=various buffer cache operation such as quiesce operation,managing fast start IO target,parallel recovery operation,etc.

AODU> ora600 kcb
         Invalid keywords/it is not in list
AODU>

注意：为了程序的易维护性，程序中只做了前2个字符匹配模式。加入关键是kcb开头的，可以使用kc搜索即可

ora-600的解释

[oracle@ohs1 ~]$ oerr ora 600

00600, 00000, "internal error code, arguments: [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s]"
// *Cause: This is the generic internal error number for Oracle program
//         exceptions. It indicates that a process has encountered a low-level,
//         unexpected condition. The first argument is the internal message
//         number. This argument and the database version number are critical in
//         identifying the root cause and the potential impact to your system.
//
// *Action: Visit My Oracle Support to access the ORA-00600 Lookup tool
//          (reference Note 600.1) for more information regarding the specific
//          ORA-00600 error encountered.
//
//          An Incident has been created for this error in the Automatic
//          Diagnostic Repository (ADR). When logging a service request, use
//          the Incident Packaging Service (IPS) from the Support Workbench
//          or the ADR Command Interpreter (ADRCI) to automatically package the
//          relevant trace information (reference My Oracle Support Note 411.1).
//
//          The following information should also be gathered to help determine
//          the root cause:
//             - changes leading up to the error
//             - events or unusual circumstances leading up to the error
//             - operations attempted prior to the error
//             - conditions of the operating system and databases at the time
//               of the error
//
//          Note: The cause of this message may manifest itself as different
//          errors at different times. Be aware of the history of errors that
//          occurred before this internal error.

ora-700不常见，可以了解下

[oracle@ohs1 ~]$ oerr ora 700

00700, 00000, "soft internal error, arguments: [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s]"
// *Cause:  Internal inconsistency that will not crash a process
// *Action: Report as a bug - the first argument is the internal error.
[oracle@ohs1 ~]$