Re: Oracle Data Masking Pack - script generation

The root cause was due to an unpublished OMS/Agent bug that was bundled in RU20. From my SR, learned that the generated script is stored in the OEM repository, but not sure exactly where. The masking script in $ORACLE_HOME/dbs can be edited and rerun. Must first set MGMT$MASK_CHECKPOINT.last_step to the step that failed and the script will pick up from that point. The script reports missing bind variables, which can be ignored.  

Doug

> On 04/30/2024 11:17 AM MST DOUG KUSHNER <dougk5_at_cox.net> wrote:
>
>
> Hoping that someone here is familiar with this OEM pack. We have been using it successfully for several years, but since our target databases have been patched to 19.22 there are issues. The main issue is malformed CREATE INDEX statements in the generated script, but only for function-based indexes. The FBI columns in the generated statements are empty identifiers ("").
>
> So my questions:
> * When a script is generated, where is it stored? Is it in OEM somewhere? The script doesn't get copied to $ORACLE_HOME/dbs of the target database until the run job is scheduled.
> * Can I fix a script residing in $ORACLE_HOME/dbs, then manually run it to resume the masking process? Will it need some sort of wrapper script?
> I opened a SR, but they often don't seem to gain traction until I have solved the issue myself. I looked at packages in OEM, but couldn't find the code that generates the masking script.
>
> TIA,
> Doug
>

--
http://www.freelists.org/webpage/oracle-l