Sync PDB failed with ORA-959

-- Create pluggable database 

SYS@CDB> create pluggable database PDB2_1 admin user PDB2_1_ADM identified by oracle roles=(connect,dba) storage( maxsize unlimited) default tablespace sales create_file_dest='/u01/app/oracle/oradata/CDB/PDB2_1';

 

Pluggable database created.

 

SYS@CDB>show pdbs

 

    CON_ID CON_NAME  OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

  2 PDB$SEED  READ ONLY  NO

  3 PDB1  READ WRITE NO

  4 PDB2  MOUNTED

  5 NCDB  MOUNTED

  6 PDB2_1  MOUNTED

SYS@CDB>alter pluggable database pdb2_1 open;

 

Warning: PDB altered with errors.

 

 

SYS@CDB>select message from pdb_plug_in_violations where name='PDB2_1';

 

 

MESSAGE

--------------------------------------------------------------------------------

Sync PDB failed with ORA-959 during 'CREATE USER c##common_user IDENTIFIED BY *

QUOTA UNLIMITED ON users container = all'

 

SYS@CDB>alter session set container=PDB2_1;

 

Session altered.

 

SYS@CDB>select name from v$tablespace;

 

NAME

------------------------------

UNDOTBS1

SYSTEM

SYSAUX

TEMPTS1

DEFTBS

USERTBS

SALES

 

7 rows selected.

 

SYS@CDB>alter tablespace USERTBS rename to USERS;

 

Tablespace altered.

 

SYS@CDB>conn / as sysdba

Connected.

SYS@CDB>alter pluggable database PDB2_1 close;

 

Pluggable database altered.

 

SYS@CDB>alter pluggable database PDB2_1 open;

 

Pluggable database altered.

 

SYS@CDB>show pdbs

 

    CON_ID CON_NAME  OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

  2 PDB$SEED  READ ONLY  NO

  3 PDB1  READ WRITE NO

  4 PDB2  MOUNTED

  5 NCDB  MOUNTED

  6 PDB2_1  READ WRITE NO