Skip to Main Content

LiveLabs & Workshops

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Is the Oracle Database In-Memory Advisor 12c also available for 19c?

Jasmin FluriMar 8 2022

The MOS Note (Document 1965343.1 (oracle.com)) says there is an Oracle In-Memory Advisor available for Oracle Database 11.2.0.3 and above. It doesn't say up to which version it is compatible or available.
I tried to install the Oracle In-Memory Advisor (Document 1965343.1 (oracle.com)) on an Oracle Database 19c (19.14) according to the documentation attached in the MOS notes and got the following error (no matter if I installed it in the CDB or the PDB and no matter which tablespace I used):
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'DBMS_IMADVISOR_AWR_AUGMENTTABS' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
ORA-06512: at line 3
From this I assume it's not compatible with 19c.
Is there an Oracle Database In-Memory Advisor available for 19c?
Or is there another possibility to install the 12c In-Memory Advisor on 19c?

This post has been answered by Andy Rivenes-Oracle on Mar 11 2022
Jump to Answer
Comments
Post Details
Added on Mar 8 2022
10 comments
244 views