Re: Look for error in Oracle log

Hi Gus,

I am using an Oracle 12.2.0.1.0 version. It has the v$diag_alert_ext.

I got the message :

select INST_ID, to_char (ORIGINATING_TIMESTAMP, 'DD-MM-YYYY HH24:MI') data, PROCESS_ID, MESSAGE_TEXT
from v$diag_alert_ext
where trim(process_id) = '3524';

Thanks
Eriovaldo

2017-07-23 10:54 GMT-03:00 Gus Spier <gus.spier_at_gmail.com>:

> You don't actually which version of Oracle you're using.
> If the view, v$diag_alert_ext is available, try:
>
> select message_type, originating_timestamp, message_text from
> v$diag_alert_ext where message_type in (2,3,4) and originating_timestamp >
> sysdate - 2
>
> If you run a describe on v$diag_alert_ext, you will see fields for trace
> file and other tantalizing columns. Let us know how it works out for you.
>
> As an additional alternative, take a look at ADRCI (automatic diagnostic
> repository command interpretor) for another way to winkle out your
> information.
>
> Good luck!
>
> Gus
>
> On Sun, Jul 23, 2017 at 9:44 AM, Eriovaldo Andrietta <
> ecandrietta_at_gmail.com> wrote:
>
>> Hi,
>>
>> I got this error :
>>
>> BEGIN
>> *
>> ERROR at line 1:
>> ORA-03113: end-of-file on communication channel
>> Process ID: 3524
>> Session ID: 1161 Serial number: 23073
>>
>> The last success command occured : ###### : 23-07-2017 02:29:1717
>>
>> How and where can I search the error ?
>> in alert ? incident ? trace ?
>>
>> I tried some queries without sucess, like that :
>>
>> select to_char (ORIGINATING_TIMESTAMP, 'DD-MM-YYYY HH24:MI') data,
>> message_text
>> from x$dbgalertext
>> where ORIGINATING_TIMESTAMP > (SYSDATE -1)
>> and message_text like '%ORA-03113%' ;
>>
>>
>> Any suggestion ?
>>
>> Regards
>> Eriovaldo
>>
>>
>>
>

--
http://www.freelists.org/webpage/oracle-l