使用Oracle数据库12.2启用统一审计时的ORA-07445

Question

在Oracle数据库12.2中启用以下统一审计策略时，v$alert_log中的ORA-07445和每个新登录的ORA-03114都会出现一个通用错误：

ORA-07445:遇到的异常:核心转储克西斯_evaopn2_设置_利皮武_args()+73 地址:0x218 未映射到对象的地址。

和

ORA-03114:没有连接到甲骨文。

这个错误经常发生在三个经过测试的12.2数据库上。

但是，如果删除了WHEN子句中的上级函数调用，则不会发生错误。这会是12.2的错误吗？此外，想知道这是否是一个有效的解决办法，以删除上层函数调用。

-- create policies
CREATE AUDIT POLICY sox_audit_ddl
  ACTIONS
    CREATE ASSEMBLY,
    CREATE AUDIT POLICY,
    CREATE CLUSTER,
    CREATE CONTEXT,
    CREATE DATABASE LINK,
    CREATE DIMENSION,
    CREATE DIRECTORY,
    CREATE DISK GROUP,
    CREATE EDITION,
    CREATE FLASHBACK ARCHIVE,
    CREATE FUNCTION,
    CREATE INDEX,
    CREATE INDEXTYPE,
    CREATE JAVA,
    CREATE LIBRARY,
    CREATE MATERIALIZED VIEW ,
    CREATE MATERIALIZED VIEW LOG,
    CREATE MATERIALIZED ZONEMAP,
    CREATE OPERATOR,
    CREATE OUTLINE,
    CREATE PACKAGE,
    CREATE PACKAGE BODY,
    CREATE PFILE,
    CREATE PLUGGABLE DATABASE,
    CREATE PROCEDURE,
    CREATE PROFILE,
    CREATE RESTORE POINT,
    CREATE ROLE,
    CREATE ROLLBACK SEGMENT,
    CREATE SCHEMA,
    CREATE SCHEMA SYNONYM,
    CREATE SEQUENCE,
    CREATE SPFILE,
    CREATE SYNONYM,
    CREATE TABLE,
    CREATE TABLESPACE,
    CREATE TRIGGER,
    CREATE TYPE,
    CREATE TYPE BODY,
    CREATE USER,
    CREATE VIEW,
    ALTER ASSEMBLY,
    ALTER AUDIT POLICY,
    ALTER CLUSTER,
    ALTER DATABASE,
    ALTER DATABASE LINK,
    ALTER DIMENSION,
    ALTER DISK GROUP,
    ALTER FLASHBACK ARCHIVE,
    ALTER FUNCTION,
    ALTER INDEX,
    ALTER INDEXTYPE,
    ALTER JAVA,
    ALTER LIBRARY,
    ALTER MATERIALIZED VIEW ,
    ALTER MATERIALIZED VIEW LOG,
    ALTER MATERIALIZED ZONEMAP,
    ALTER OPERATOR,
    ALTER OUTLINE,
    ALTER PACKAGE,
    ALTER PACKAGE BODY,
    ALTER PLUGGABLE DATABASE,
    ALTER PROCEDURE,
    ALTER PROFILE,
    ALTER RESOURCE COST,
    ALTER ROLE,
    ALTER ROLLBACK SEGMENT,
    ALTER SEQUENCE,
    ALTER SESSION,
    ALTER SYNONYM,
    ALTER SYSTEM,
    ALTER TABLE,
    ALTER TRIGGER,
    ALTER TYPE,
    ALTER TYPE BODY,
    ALTER USER,
    ALTER VIEW,
    TRUNCATE CLUSTER,
    TRUNCATE TABLE,
    RENAME,
    DROP ASSEMBLY,
    DROP AUDIT POLICY,
    DROP CLUSTER,
    DROP CONTEXT,
    DROP DATABASE LINK,
    DROP DIMENSION,
    DROP DIRECTORY,
    DROP DISK GROUP,
    DROP EDITION,
    DROP FLASHBACK ARCHIVE,
    DROP FUNCTION,
    DROP INDEX,
    DROP INDEXTYPE,
    DROP JAVA,
    DROP LIBRARY,
    DROP MATERIALIZED VIEW ,
    DROP MATERIALIZED VIEW  LOG,
    DROP MATERIALIZED ZONEMAP,
    DROP OPERATOR,
    DROP OUTLINE,
    DROP PACKAGE,
    DROP PACKAGE BODY,
    DROP PLUGGABLE DATABASE,
    DROP PROCEDURE,
    DROP PROFILE,
    DROP RESTORE POINT,
    DROP ROLE,
    DROP ROLLBACK SEGMENT,
    DROP SCHEMA SYNONYM,
    DROP SEQUENCE,
    DROP SYNONYM,
    DROP TABLE,
    DROP TABLESPACE,
    DROP TRIGGER,
    DROP TYPE,
    DROP TYPE BODY,
    DROP USER,
    DROP VIEW
  WHEN
    'UPPER(SYS_CONTEXT(''USERENV'', ''SESSION_USER'')) IN (''USER_A'', ''USER_B'') AND UPPER(SYS_CONTEXT(''USERENV'', ''OS_USER'')) != ''ORACLE'''
    EVALUATE PER SESSION;

CREATE AUDIT POLICY sox_audit_dml
  ACTIONS
    INSERT,
    UPDATE,
    DELETE
  WHEN
    'UPPER(SYS_CONTEXT(''USERENV'', ''SESSION_USER'')) IN (''USER_A'', ''USER_B'') AND UPPER(SYS_CONTEXT(''USERENV'', ''OS_USER'')) != ''ORACLE'''
    EVALUATE PER SESSION;

CREATE AUDIT POLICY sox_audit_tcl
  ACTIONS
    COMMIT,
    ROLLBACK
  WHEN
    'UPPER(SYS_CONTEXT(''USERENV'', ''SESSION_USER'')) IN (''USER_A'', ''USER_B'') AND UPPER(SYS_CONTEXT(''USERENV'', ''OS_USER'')) != ''ORACLE'''
    EVALUATE PER SESSION;

CREATE AUDIT POLICY sox_audit_dcl
  ACTIONS
    GRANT,
    REVOKE
  WHEN
    'UPPER(SYS_CONTEXT(''USERENV'', ''SESSION_USER'')) IN (''USER_A'', ''USER_B'') AND UPPER(SYS_CONTEXT(''USERENV'', ''OS_USER'')) != ''ORACLE'''
    EVALUATE PER SESSION;

CREATE AUDIT POLICY sox_audit_misc
  ACTIONS
    ANALYZE CLUSTER,
    ANALYZE INDEX,
    ANALYZE TABLE,
    ASSOCIATE STATISTICS,
    AUDIT,
    CHANGE PASSWORD,
    COMMENT,
    DISASSOCIATE STATISTICS,
    EXECUTE,
    FLASHBACK TABLE,
    LOCK TABLE,
    LOGOFF,
    LOGON,
    NOAUDIT,
    PURGE INDEX,
    PURGE TABLE,
    PURGE TABLESPACE,
    SET ROLE,
    SET TRANSACTION
  WHEN
    'UPPER(SYS_CONTEXT(''USERENV'', ''SESSION_USER'')) IN (''USER_A'', ''USER_B'') AND UPPER(SYS_CONTEXT(''USERENV'', ''OS_USER'')) != ''ORACLE'''
    EVALUATE PER SESSION;

-- enable policies
AUDIT POLICY sox_audit_ddl;
AUDIT POLICY sox_audit_dml;
AUDIT POLICY sox_audit_tcl;
AUDIT POLICY sox_audit_dcl;
AUDIT POLICY sox_audit_misc;

Answer 1

ORA-07445: [KXES_EVAOPN2_SETUP_RPISWU_ARGS] WHILE EXECUTING UNIFIED AUDIT POLICY (Bug ID 20918538)
ORA-07445 [KXES_EVAOPN2_SETUP_RPISWU_ARGS] ON CONNECT WITH AUDIT POLICY ENABLED(Bug ID 26777814)
ORA-7445[KXES_EVAOPN2_SETUP_RPISWU_ARGS] ON CONNECT WITH CERTAIN AUDIT POLICY(Bug ID 27754325)
ORA-7445 [KXES_EVAOPN2_SETUP_RPISWU_ARGS+85] CONNECTING TO PDB(Bug ID 20057256)

所有的窃听器仍在调查中。

如果您找到了解决办法(移除上部)，请使用它。