CODEWITHSUNDEEP
oracle-databaseoracle12c
Ley Gail
Ley Gail

Reputation: 55

upgrade your database to Oracle Database 12c ERROR

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 ?

Upvotes: 2

Views: 754

Answers (2)

Rahul Tripathi
Rahul Tripathi

Reputation: 172458

From the Orcale docs 3.24.1.4 Bug 16654392:

Workaround: 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.

Automatic SQL Tuning Advisor can be configured at the CDB level only.

You can configure the following automated maintenance tasks at the CDB or PDB level:

  • Optimizer Statistics gathering
  • Segment Advisor

Upvotes: 0

Hard Worker
Hard Worker

Reputation: 1121

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.

Upvotes: 1

Related Questions