Forum Stats

  • 3,722,123 Users
  • 2,244,225 Discussions
  • 7,849,645 Comments

Discussions

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

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

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], [], [], [], [], [], [], [], [], []

Tagged:

Answers

Sign In or Register to comment.