Gurus,

Can you enlighten me why ORA errors reflected in our Apps server logs
where not registered in our database alert log?

Thanks.

BlackSwan: Thanks for this, but who will initiate then the resolution of errors-- obviously its the Oracle DBA, right (and usually the blame)? But what would be the part of the Apps group in resolving the issue-- these people would say that the issue lies in the database level not in the Apps level. Thanks again.

BlackSwan: This is a straightforward and revealing infos. But, are you referring that this is the standard? Since most IT Managers in our company had traditional mindset that associate "ORA errors" and "Oracle" solely to the database. Anyway, thank you very much for this.

Best regards,

SQL> select 1/0 from dual;
select 1/0 from dual
        *
ERROR at line 1:
ORA-01476: divisor is equal to zero

. . . most IT Managers in our company had traditional mindset that associate "ORA errors" and "Oracle" solely to the database.

Where I work, we trap the ORA error in our app code. We give the user a more user-friendly error message but we log the actual ORA- error into a log table in the database. This way, we can go back and research application errors after the fact.


Cheers,
Brian