My Blog

Creating profiles in Multi-tenant – ORA-65140

by admin on 24th March 2014 1 comment

Just a quick blog entry, as this caught one of our guys out this morning. When you have a 12c Mutli-tenant environment, common profiles must start with C## in their naming…

SQL> create profile dbsnmp_profile limit password_life_time unlimited;
create profile dbsnmp_profile limit password_life_time unlimited

*

ERROR at line 1:
ORA-65140: invalid common profile name

SQL> create profile c##dbsnmp_prof limit password_life_time unlimited;

Profile created.

SQL> alter user dbsnmp profile c##dbsnmp_prof;

User altered.

adminCreating profiles in Multi-tenant – ORA-65140

1 comment

Join the conversation
  • lxx - 26th November 2016 reply

    do u know why?

Join the conversation