Database Administration (MOSC)

MOSC Banner

Error when AUDIT RENAME ON BY ACCESS WHENEVER SUCCESSFUL

Hello all,

I am getting an error when setting up auditing.

environment - Oracle 19c standalone RedHat 7 x

When running below

AUDIT RENAME ON "USER1"."EXT_BOM_COMPONENTS" BY ACCESS WHENEVER SUCCESSFUL

i get this error.

ORA-39083: Object type AUDIT_OBJ failed to create with error:

ORA-02002: error while writing to audit trail

ORA-01461: can bind a LONG value only for insert into a LONG column


I run the same command on 12c and it works but not the 19c. I do see the audit info being wrote to the audit trail on. I see nothing in the alert logs

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center