Durante a criação de um profile para posteriormente associar um usuário criado ao mesmo, recebi o seguinte erro “ORA-65140: invalid common profile name”. Isto acontece quando se tenta criar um profile sem o prefixo c## no CDB em um banco de dados Oracle 12c. Para resolver este problema, basta simplesmente adicionar o prefixo antes do nome do profile e reexecutar o comando.
Com isso, seguem os exemplos:
- Tentativa de criar o usuário sem o prefixo c## no CDB:
SQL>CREATE PROFILE teste LIMIT PASSWORD_REUSE_MAX UNLIMITED PASSWORD_REUSE_TIME UNLIMITED; CREATE PROFILE teste * ERROR at line 1: ORA-65140: invalid common profile name
- Criação com sucesso do profile com o prefixo c##:
SQL> create profile c##teste limit PASSWORD_REUSE_MAX UNLIMITED PASSWORD_REUSE_TIME UNLIMITED; 2 Profile created.
- Associando um determinado usuário ao profile criado:
SQL> alter user BRUNORS profile c##teste; User altered.
- Apagando o profile criado:
SQL> drop profile C##TESTE; Profile dropped.
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)