Upgrade JDBC audit event handlers
If you had configured one or more JDBC audit event handlers, make the following changes to the audit tables' schema:
-
Run the following command on Oracle databases that support AM audit event handlers:
ALTER TABLE am_auditaccess ADD (response_detail CLOB NULL);
This command adds the
response_detail
column to theam_auditaccess
table. -
Run the following commands on MySQL databases that support AM audit event handlers:
ALTER TABLE audit.am_auditconfig CHANGE COLUMN configobjectid objectid VARCHAR(255); ALTER TABLE audit.am_auditaccess ADD COLUMN response_detail TEXT NULL;
The commands change the name of the
configobjectid
column in theam_auditconfig
table toobjectid
and add theresponse_detail
column to theam_auditaccess
table. -
If you use databases other than Oracle or MySQL to support AM audit event handlers, review their schema.
If the
am_auditconfig
table has a column namedconfigobjectid
, change that column’s name toobjectid
.If the
am_auditaccess
table does not have a column namedresponse_detail
, add that column to the table’s schema.