Database Reference
In-Depth Information
IF err_msg NOT LIKE '%Message '||err_num||' not found%' THEN
DBMS_OUTPUT.PUT_LINE (err_msg);
counter:=counter+1;
END IF;
END LOOP;
DBMS_OUTPUT.PUT_LINE (counter || ' events found.');
END;
/
Unfortunately it is impossible to access the additional information reported by
oerr
in the
cause and action sections with PL/SQL. However, the additional information is in the
Oracle
Database Error Messages Guide
. Following is an example of running the script
oerr.sql
:
$ sqlplus system/
manager@ten.oradbpro.com
@oerr.sql
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, Real Application Clusters, Oracle Label Security and Data
Mining options
ORA-10000: control file debug event, name 'control_file'
ORA-10001: control file crash event1
ORA-10002: control file crash event2
ORA-10003: control file crash event3
ORA-10004: block recovery testing - internal error
ORA-10005: trace latch operations for debugging
…
ORA-10998: event to enable short stack dumps in system state dumps
ORA-10999: do not get database enqueue name
713 events found.
The source code depot includes a full list of events in the range 10000 to 10999 for releases
Oracle9
i
, Oracle10
g
, and Oracle11
g
.
Source Code Depot
Table 35-2 lists this chapter's source files and their functionality.
Table 35-2.
OERR Utility Source Code Depot
File Name
Functionality
events_10g.txt
List of Oracle10
g
events in the range 10000 to 10999
events_11g.txt
List of Oracle11
g
events in the range 10000 to 10999
events_9i.txt
List of Oracle9
i
events in the range 10000 to 10999
oerr.sh
Retrieves and counts all events (event numbers) of a DBMS release
oerr.sql
PL/SQL script which retrieves and counts all events
