BMF–5735: Issue with running Benchmark Factory Capture (4374783)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

BMF–5735: Issue with running Benchmark Factory Capture
Description

The customer is trying to run a BMF Capture using FGAC (Fine-Grained Access Control) but is getting an error message:

Error 'ORA-20103': You have a Mouse trigger to catch trace activity in some schema(s). Please stop it before further processing.
Cause
- The Customer had killed the capture session from the database/backend side.
- The issue comes due to audit policies that were created by BMF is not dropped.
Resolution
1. Start Capturing the session from the BMF application.
2. Ideal way to Stop the capture by using BMF Application. Stop Capture ->
1. Drop Audit policies:
Execute

1) SELECT COUNT ( * ) INTO v_count FROM dba_audit_policies WHERE  policy_name like 'BMF_%';

2) SYS.DBMS_FGA.DROP_POLICY(
                          object_schema    => :v_object_schema,
                          object_name     => :v_object_name,
                          policy_name     => :v_policy_name
                        );
Defect ID

BMF–5735
Additional Information

“If we kill the session from backend/database using alter system kill session ‘,’ immediate; command then we need to manually delete/drop those audit policies which is created by BMF while capturing the session.”