I'm running the below query in a 12c database
SQL> select dbms_sqltune.report_sql_monitor(type=>'active') from dual;
ERROR:
ORA-13971: Component "sqlmonitor" unknown
ORA-06512: at "SYS.DBMS_SQLTUNE", line 16211
ORA-06512: at "SYS.DBMS_SQLTUNE", line 16307
ORA-06512: at "SYS.DBMS_SQLTUNE", line 16638
ORA-06512: at line 1
According to Doc ID 1679985.1, I should run SQL>@ORACLE_HOME/rdbms/admin/execrept.sql. But that sql exists in 11g but not 12c. I look in 11g and found that it does this...
exec prvt_report_tags.register_common_tags(TRUE);
exec prvt_report_registry.register_clients;
I can not find an equivalent script anywhere in the 12c admin directory. Does anyone know what to do for a 12c database that is experiencing the ora-13971 when running the dbms_sqltune.report_sql_monitor function?