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.
*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.