I have upgrade my database to Oracle Database 12c Release 1 (12.1) and then plug it into a CDB, the automatic SQL Tuning Advisor generates the following error:
ORA-65040: operation not allowed from within a pluggable database
what could be the problem ?
Connect to the PDB where you see the ORA-65040 error for the automatic SQL Tuning Advisor, use the DBMS_SCHEDULER.DROP_PROGRAM('AUTO_SQL_TUNING_PROG') procedure to delete the existing old AUTO_SQL_TUNING_PROG program, and then run the execsqlt.sql script to re-create it. You can find the script in the ORACLE_HOME/admin directory.