Focus On Oracle

Installing, Backup & Recovery, Performance Tuning,
Troubleshooting, Upgrading, Patching, Zero-Downtime Upgrade, GoldenGate

Oracle Exadata ,Oracle ODA, Oracle ZDLRA


当前位置: 首页 » 技术文章 » AODU

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 <关键字的前两个字母>

AODU> ora600 kt
 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

AODU> ora600 kc
 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 ~]$


关键词:aodu 

相关文章

aodu(At Oracle Database Utility)之optim
aodu(At Oracle Database Utility)之asm(二)
aodu(At Oracle Database Utility)之asm(一)
aodu(At Oracle Database Utility)之rac(二)
aodu(At Oracle Database Utility)之rac(一)
aodu(At Oracle Database Utility)之ora600
aodu(At Oracle Database Utility)之asmdisk
aodu(At Oracle Database Utility)之unwrap
aodu(At Oracle Database Utility)之rdba
aodu(At Oracle Database Utility)之drux
aodu(At Oracle Database Utility)之time
aodu(At Oracle Database Utility)之odlog
Top