Database compare showing diff in Unified audit policies

Toad for Oracle
1

Hello All,
Im running toad 17.0.3
cdb/pdb configuration.

I ran a database compare and noticed it showed a diff in unified audit policies. Said existed in 1 PDB but not its corresponding PDB.
I did a manual chance and see the same policies in both PDB's.

image
image1201×799 138 KB

below returns identical outputs on both PDB's
select distinct POLICY_NAME from AUDIT_UNIFIED_POLICIES order by 1;
ORA_ACCOUNT_MGMT
ORA_CIS_RECOMMENDATIONS
ORA_DATABASE_PARAMETER
ORA_DV_AUDPOL
ORA_DV_AUDPOL2
ORA_LOGON_FAILURES
ORA_RAS_POLICY_MGMT
ORA_RAS_SESSION_MGMT
ORA_SECURECONFIG

any suggestions?
Thanks
Dave

2

Is this something that we may have fixed in version 17.1, latest release?

3

Im not sure. It takes a month or so to get updated software approved.
Are you able to reproduce? this are oracle defaults, the ones that are custom didnt show as a difference or missing.

4

I (almost) always use the latest version, and in this case, I cannot re-produce the issue.
I have two PDBs, one DEV and the other TEST, and my DB Compare shows changes in the Standard Actions clause of my SecureConfig audit policy, per below.

image
image1112×868 46.6 KB

5

ok, its not showing a diff in the policy. its saying it doesnt exist at all.

Thanks
Dave

6

Hi Dave,

Sorry for the delay. I just got back from vacation. I just tested this in Toad version 17.0 and I don't see any problems.

Can you provide a "Create Unified Audit Policy" script on one or more of the UAPs that are not appearing?

Also please let me know the database version of both source and target database

Thanks

-John