Skip to Main Content

ORA-02002 error while writing to audit trail in Pluggable Database 19.7

chileme88Sep 30 2020

Hi all,
I've a 2nodes rac 19.7 Oracle Database (3 pdb: MW BI2 SC).
I made a new big tbs for the AUD$ table in pdb MW:
CREATE BIGFILE TABLESPACE "DBAAUDIT_BIGTBSDAT" DATAFILE SIZE 10G AUTOEXTEND ON NEXT 1G MAXSIZE UNLIMITED;

And after I moved the table in the new tbs:
BEGIN DBMS_AUDIT_MGMT.SET_AUDIT_TRAIL_LOCATION(
audit_trail_type => DBMS_AUDIT_MGMT.AUDIT_TRAIL_AUD_STD,
audit_trail_location_value => 'DBAAUDIT_BIGTBSDAT');
END;
/
and enabled the cleanup:
BEGIN
DBMS_AUDIT_MGMT.INIT_CLEANUP(
audit_trail_type => DBMS_AUDIT_MGMT.AUDIT_TRAIL_AUD_STD,
default_cleanup_interval => 24 /* hours */);
END;
/

Now sometimes (random time) some application (MW application) crash with the error:
ora-02002 error while writing to audit trail
sometimes follow by 1 of this error:
ORA-22275 invalid lob locator specified
ORA-65501: locator from 'Ú
ORA-00600: internal error code, arguments: [kollGetContainerId: locator size], [0], [30], [], [], [], [], [], [], [], [], []

Comments
Post Details
Added on Sep 30 2020
2 comments
295 views