Oracle reports errors (called "exceptions") in Trace Files and Alert Logs. The alert logs are found in $ORACLE_HOME/rdbms/log and are database wide. The trace files are per instance and found in $ORACLE_BASE/admin/SID/bdump/.trc.
