AW: ORA-02002: error while writing to audit trail

From: <ahmed.fikri_at_t-online.de>
Date: Tue, 10 Nov 2020 14:24:41 +0100 (CET)
Message-ID: <1605014681911.1582520.bcfedb0a68c1e76cf0bd0b89edbda799975170cd_at_spica.telekom.de>


unfortunately, actually I didn't have access to MOS (request is sent to our DBA)

I managed to read the trc file ( 0.5M rows): I'm not sure if this is relevant:
ORA-00955: name is already used by an existing object .......
ERROR SIGNALED: no COMPONENT: (null)
...........
ERROR SIGNALED: no COMPONENT: KSE
...........
ERROR SIGNALED: no COMPONENT: ddedmp
...........
ERROR SIGNALED: no COMPONENT: diag_dde

I understand only Bahnhof (I'm developer not DBA).

Best regards
Ahmed

-----Original-Nachricht-----
Betreff: Re: ORA-02002: error while writing to audit trail Datum: 2020-11-10T13:41:44+0100
Von: "Stefan Koehler" <contact_at_soocs.de> An: "ahmed.fikri_at_t-online.de" <ahmed.fikri_at_t-online.de>

Hello Ahmed,
did you have a look at MOS ID #2306515.1?

Sounds like the bug and you should have the corresponding stack trace (for comparison) as an ORA-0600 was raised.

Best Regards
Stefan Koehler

Independent Oracle performance consultant and researcher Website: http://www.soocs.de
Twitter: _at_OracleSK

> ahmed.fikri_at_t-online.de <ahmed.fikri@t-online.de> hat am 10.11.2020 13:27 geschrieben:
>
> Hi all,
>
> I'm getting an 0600 error while importing a dumpfile into a 12.1.0.2 database:
>
> ORA-31671: Worker process DW00 had an unhandled exception.
> ORA-02002: error while writing to audit trail
> ORA-0600: internal error code, arguments: [ktliFlsToLobWrtCbk_4], [116059], [116060], [], [], [], [], [], [], [], [], [],
> ORA-06512: at "SYS.DBMS_SQL", line 1185
> ORA-06512: at "SYS.KUPW$WORKER", line 22784
>
> The system and audit tablespaces seem to have enough free spaces.
>
>
> I'm not sure if the main cause is a bug in the Auditing. I'll try again after turning off the Auditing. But maybe can anyone tell if they encountered a similar bug?
>
> Best regards
> Ahmed


--
http://www.freelists.org/webpage/oracle-l
Received on Tue Nov 10 2020 - 14:24:41 CET

Original text of this message