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.
Hi! I am Bruno, a Brazilian born and bred, and I am also a naturalized Swedish citizen. I am a former Oracle ACE and, to keep up with academic research, I am a Computer Scientist with an MSc in Data Science and another MSc in Software Engineering. I have over ten years of experience working with companies such as IBM, Epico Tech, and Playtech across three different countries (Brazil, Hungary, and Sweden), and I have joined projects remotely in many others. I am super excited to share my interests in Databases, Cybersecurity, Cloud, Data Science, Data Engineering, Big Data, AI, Programming, Software Engineering, and data in general.
(Continue reading)
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.