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.
*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.
Ola Bruno, segue a minha pergunta em ingles:
Does this imply license costs? And how much? Does one need an enterprise edition?
As of my experience, Oracle accepts well that admins or developers activate license options.
And invoices the license costs after next license audit.
I.e. I do not see a legal problem with “just changing control_management_pack_access parameter” but rather financial ones.
Hello Daniel, thanks for your comment I totally agree with you. I have worked for some customers that just allowed to change this parameter to enable the option mentioned in the post once they have had the license. According to my experience it is always good to check if the customer allows it before enable and always try to be clear about the additional cost after the audit.
Kind regards, Bruno Reis.