There are 4 main levels of setting Errorstack:
0 Dump Error stack only (level 0 has been deprecated)
1 Dump the error stack and the function call stack
2 Level 1 + processstate
3 level 2 + Context area (show all cursors, highlighting current cursor)
Errorstack can be set at the instance or session level, or in a parameter file, which is triggered only when a specific error occurs
The client system has the following ORA-01438 error, indicating that the accuracy of the data exceeds the allowable value, is the task of the background job scheduling: Mon Jul 10:27:31 2009Errors in file/admin/erpdb/bdump/erpdb1_j000_ 447020.trc:ora-12012:error on auto execute of job 22ora-01438:value larger than specified precision allowed for this COL Umnora-06512:at "ERP. Timrdu ", line 13ora-06512:at Line 1 trace file in the default does not record the specific SQL, binding variables and other information, we can be errorstack for background tracking, to obtain more detailed information, to perform the following sql:alter system Set events= ' 1438 trace name Errorstack forever,level 10 '; then you can manually execute the following stored procedure, get the trace file, and then close the trace: Alter system set events= ' 1438 trace Name Errorstack off '; in Oracle 10g, such operations are logged to the log file: Mon Jul 10:48:39 2009OS pid:541528 executed alter system set events ' 1438 trace name Errorstack forever,level ' Mon Jul 10:56:06 2009Errors in file/admin/erpdb/udump/erpdb1_ora_267056.t Rc:ora-01438:value larger than specified precision allowed for this columnmon Jul 10:56:08 2009Trace dumping are perfor Ming Id=[cdmp_20090713105608]mon Jul 10:57:15 2009OS pid:541528 executed alter system set events ' 1438 trace name Erro Rstack off ' next analysisObtained trace files, you can get SQL text clues to find the root problem. itpub has a very classical and detailed analysis: http://www.itpub.net/thread-956435-1-1.html in Oracle management often encounter some errors, but do not know the cause of the situation, How do you know what caused the mistake? You can use the following methods to find out why
[Email protected]:/backup/>exp system/robcxqrvuglue9ep file=/backup/oradata/rman/hketc.dmp DIRECT=y owner= Hketcexport:release 10.2.0.4.0-production on Wed Jan 5 12:09:55 2011
Copyright (c) 1982, Oracle. All rights reserved. Connected to:oracle Database 10g Enterprise Edition Release 10.2.0.4.0-64bit productionwith The partitioning, Data Mini NG and Real application testing optionsexport done in ZHS16GBK character set and UTF8 NCHAR character Setserver uses UTF8 Character Set (possible charset conversion) About to export specified users .... exporting Pre-schema procedural objects and actions. Exporting foreign function library names for user hketc. Exporting public type synonyms. Exporting private type synonyms. Exporting object type definitions for user hketcabout to export hketc ' s objects .... Exporting database links. Exporting sequence numbers. Exporting cluster definitionsexp-00056:oracle error 1031 encounteredora-01031:insufficient privilegesEXP-00000: Export terminated unsuccessfully
This is an error in the exp under Oracle 10G, can only see 1031, but do not know where is out of the 1031 at this time can be run in Sqlplus
Alter system set Events ' 1031 trace name errorstack Level 3 '; Turn on the trace for 1031 and then execute it again exp goes to Udump to see the TRC file produced, which has a ksedmp: Internal or fatal errorora-01031:insufficient Privilegescurrent SQL statement for this session:select URL, LOCAL, Strippe D_val from SYS. Ku$_xmlschema_view WHERE owner_name =: OWNER
The problem arises because of the SQL above.
From for notes (Wiz)
Using Errorstack to track ORA-01438 and ORA-01031 errors
