Inmemory advisor gives ORA-20001 An In-Memory Advisor AWR augment exists for DBID xx but...s

Hi,

I am testing various configuration with inmemory advisor. I have no problem running the advisor if the workload and advisor is on the same host. However, I have difficult when AWR is from another datbase.

Environment setup: Oracle 21.7 x64 OEL8.4, standalone (both source and target)

Source: CDB: lblpo (DBID 3880079782) , PDB, secure21 (4067763069)

Target: CDB: PO21

I use swingbench to create workload on (PDB) secure21. Then run both @?/rdbms/admin/awrextr.sql and imadvisor_wr_augment_import.sql

Sample Dumps:

[oracle@down2 tmp]$ ls -lah *.dmp

-rw-r-----. 1 oracle oinstall 7.4M Aug 6 07:46 awrdat_1_2.dmp

-rw-r-----. 1 oracle oinstall 13M Aug 6 07:41 imadvisor_awr_augment.dmp