AW: ORA-02002: error while writing to audit trail
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-lReceived on Tue Nov 10 2020 - 14:24:41 CET