Oracle Database Discussions

Hi

I'm looking for errors in alert.log, I thought that every "ORA-XX" would be a incident in adrci, but "i have missed" some ORAS-XX

I have a wrong job in my test environment which generates an ORA-12012 every 5 minutes. If we chech the alert.log trace we can see that there is a recor every five minutes (more of less)

oooo--oo--oo--oo--oo--oo--oo--oo--oo--oo--oo--oo--oo--oo--oo--oo--oo--oo--oo--oo
adrci> show alert -tail 2
2013-01-31 12:59:01.901000 +01:00
SMCO started with pid=23, OS id=20719
2013-01-31 13:00:23.033000 +01:00
Errors in file /u01/app/oracle/diag/rdbms/xe/XE/trace/XE_j000_20765.trc:
ORA-12012: error on auto execute of job "TEST"."WRONG_JOB"
ORA-04063: package body ""TEST"."WRONG_JOB"" has errors
ORA-06508: PL/SQL: could not find program unit being called: ""TEST"."WRONG_JOB""
ORA-06512: at line 1

2013-01-31 13:05:23.012000 +01:00
Errors in file /u01/app/oracle/diag/rdbms/xe/XE/trace/XE_j000_20989.trc:
ORA-12012: error on auto execute of job "TEST"."WRONG_JOB"
ORA-04063: package body ""TEST"."WRONG_JOB"" has errors
ORA-06508: PL/SQL: could not find program unit being called: ""TEST"."WRONG_JOB""
ORA-06512: at line 1

2013-01-31 13:10:23.012000 +01:00
Errors in file /u01/app/oracle/diag/rdbms/xe/XE/trace/XE_j000_21195.trc:
ORA-12012: error on auto execute of job "TEST"."WRONG_JOB"
ORA-04063: package body ""TEST"."WRONG_JOB"" has errors
ORA-06508: PL/SQL: could not find program unit being called: ""TEST"."WRONG_JOB""
ORA-06512: at line 1
oooo--oo--oo--oo--oo--oo--oo--oo--oo--oo--oo--oo--oo--oo--oo--oo--oo--oo--oo--oo

But, if we look for for incidents

oooo--oo--oo--oo--oo--oo--oo--oo--oo--oo--oo--oo--oo--oo--oo

adrci> show incidents

ADR Home = /opt/oracle/diag/rdbms/xe/XE:
*************************************************************************
INCIDENT_ID PROBLEM_KEY CREATE_TIME
-------------------- ----------------------------------------------------------- ----------------------------------------
23393 ORA 600 [kzsviver:1] 2012-09-27 09:19:55.054000 +02:00
23394 ORA 600 [kzsviver:1] 2012-09-27 09:20:13.540000 +02:00
23409 ORA 600 [kzsviver:1] 2012-09-27 09:56:35.688000 +02:00
23433 ORA 4031 2012-09-27 11:23:31.645000 +02:00
23369 ORA 4031 2012-09-27 11:23:33.117000 +02:00
23395 ORA 4031 2012-09-27 11:23:34.270000 +02:00
23441 ORA 4031 2012-09-27 11:23:35.513000 +02:00
23449 ORA 4031 2012-09-27 11:23:42.932000 +02:00

8 rows fetched
oooo--oo--oo--oo--oo--oo--oo--oo--oo--oo--oo--oo--oo--oo--oo

This ORA-12012 doesn't appears.

¿Anybody knows what is the reason?

thanks