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

Hi all,

after disabling the auditing, it works.
The job is supposed to run only on lower environment (DEVs). So we can afford disabling auditing.

Thanks and regards
Ahmed

-----Original-Nachricht-----
Betreff: AW: ORA-02002: error while writing to audit trail Datum: 2020-11-10T14:25:51+0100
Von: "ahmed.fikri_at_t-online.de" <ahmed.fikri_at_t-online.de> An: "list, oracle" <oracle-l_at_freelists.org>

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



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