[Tuning Pack] ORA-13716: Diagnostic Package License is needed for using this feature

Estava efetuando uma análise da performance de um determinado banco de dados Oracle, quando na execução do ADDM obtive o seguinte erro :”ORA-13716: Diagnostic Package License is needed for using this feature.”. O erro por si só já reporta solução : é necessário a  licença do determinado pacote para a execução correta da tarefa. E, no meu caso, foi o pacote “Tuning Pack”.
Após o cliente comprar a licença, habilitei o parâmetro  control_management_pack_access de NONE para DIAGNOSTIC+TUNING e, com isso, pude finalizar uma de minhas análises.

Assim, segue  a execução:

• Erro reportado durante  a execução do ADDM:

begin
*
ERROR at line 1:
ORA-13716: Diagnostic Package License is needed for using this feature.
ORA-06512: at "SYS.PRVT_SMGUTIL", line 52
ORA-06512: at "SYS.PRVT_SMGUTIL", line 35
ORA-06512: at "SYS.PRVT_ADVISOR", line 7360
ORA-06512: at "SYS.PRVT_ADVISOR", line 7404
ORA-06512: at "SYS.PRVT_ADVISOR", line 7463
ORA-06512: at "SYS.DBMS_ADVISOR", line 101
ORA-06512: at line 12

• Verificação do parâmetro  control_management_pack_access (Pacote “Tuning Pack”):

SQL> show parameters control_management_pack_access 

control_management_pack_access string NONE

• Mudando o  parâmetro control_management_pack_access de NONE para DIAGNOSTIC+TUNING:

SQL> ALTER SYSTEM SET control_management_pack_access='DIAGNOSTIC+TUNING' SCOPE=BOTH;

System altered.

• Verificação do parâmetro  control_management_pack_access (Pacote “Tuning Pack”) novamente:

SQL> show parameters control_management_pack_access

control_management_pack_access string DIAGNOSTIC+TUNING

Após isso, pude retornar às análises do ambiente.

brunors

*The views expressed here are my own and do not represent those of my employer.*

Hello, I’m Bruno — a dual citizen of Brazil and Sweden. I bring a global perspective shaped by experiences in both South America and Europe, with a strong focus on collaboration and innovation across cultures. I am a Computer Scientist, PhD Candidate in Information and Communication Technologies, focusing on Data Science and Artificial Intelligence, and hold dual Master’s degrees in Data Science and Cybersecurity. With over fifteen years of international experience spanning Brazil, Hungary, and Sweden, I have collaborated with global organizations such as IBM, Playtech, and Oracle, as well as contributed remotely to projects across multiple regions. My professional interests include Databases, Cybersecurity, Cloud Computing, Data Science, Data Engineering, Big Data, Artificial Intelligence, Programming, and Software Engineering,  all driven by a deep passion for transforming data into strategic business value.