使用ERRORSTACK进行错误跟踪及诊断

 oracle供给接口用来确诊oracle的缺点消息。确诊事变不妨在session级树立，也不妨在体例级树立，常常即使要确诊全部缺点，最佳在体例级树立，以次是一个尝试例子，所选事变只以演示为手段:sql> alter system set event='984 trace name errorstack level 10' scope=spfile;system altered.sql> startup force;oracle instance started.total system global area 101782828 bytesfixed size 451884 bytesvariable size 37748736 bytesdatabase buffers 62914560 bytesredo buffers 667648 bytesdatabase mounted.database opened.sql> create table t (name varchar2(10),id number);table created.sql> insert into t values(a,1);insert into t values(a,1) *error at line 1:ora-00984: column not allowed heresql> !

此时的984缺点将会被盯梢，记载到盯梢文献中。查看udump目次，找到trace文献:

[oracle@jumper oracle]$ cd $admin[oracle@jumper udump]$ ls -sorttotal 1020 4 -rw-r--r-- 1 oracle 533 mar 2 16:06 t.sql 4 -rw-r--r-- 1 oracle 522 mar 3 09:44 d.sql 20 -rw-r--r-- 1 oracle 17445 mar 8 11:06 a.log 4 -rw-r----- 1 oracle 3254 mar 14 23:15 conner_ora_30683.trc 4 -rw-r----- 1 oracle 1645 mar 14 23:15 conner_ora_30701.trc 4 -rw-r----- 1 oracle 1638 mar 14 23:16 conner_ora_30719.trc 4 -rw-r----- 1 oracle 1645 mar 16 09:05 conner_ora_18565.trc 976 -rw-r----- 1 oracle 993555 mar 16 09:06 conner_ora_18589.trc[oracle@jumper udump]$ vi conner_ora_18589.trc/opt/oracle/admin/conner/udump/conner_ora_18589.trcoracle9i enterprise edition release 9.2.0.4.0 - productionwith the partitioning optionjserver release 9.2.0.4.0 - productionoracle_home = /opt/oracle/product/9.2.0system name: linuxnode name: jumper.hurray.com.cnrelease: 2.4.21-15.elversion: #1 thu apr 22 00:27:41 edt 2004machine: i686instance name: connerredo thread mounted by this instance: 1oracle process number: 10unix process pid: 18589, image: oracle@jumper.hurray.com.cn (tns v1-v3)*** 2005-03-16 09:06:56.178ksedmp: internal or fatal errorora-00984: column not allowed herecurrent sql statement for this session:insert into t values(a,1)----- call stack trace -----calling call entry argument values in hexlocation type point (? means dubious value)-------------------- -------- -------------------- ----------------------------ksedmp()+269 call ksedst()+0 0 ? 0 ? 0 ? 0 ? 922c89f ? aa642a0 ?ksddoa()+446 call ksedmp()+0 a ? aabdca8 ? b70100b0 ? 3d8 ? 1 ? b7010114 ?ksdpcg()+521 call ksddoa()+0 b70100b0 ? aabdca8 ?ksdpec()+220 call ksdpcg()+0 3d8 ? bfff3d20 ? 1 ?ksfpec()+133 call ksdpec()+0 3d8 ? 3d8 ? aabae7c ? bfff3d54 ? 9835e89 ? aa642a0 ?[oracle@jumper udump]$

有了这个盯梢文献就简单定位和确诊缺点了。