pdb受限解决思路

To solve the issue ,delete the offending statement ( alter user "xxx" ) from PDB_SYNC$ for both CDB and PDB

On CDB root ,make a backup of  PDB_SYNC$  table and delete de offending rows

=====================================================

sqlplus / as sysdba

SQL> col NAME format a30

SQL> col SQLSTMT format a100

SQL> Select CTIME,SQLSTMT,NAME,FLAGS,OPCODE,REPLAY# from PDB_SYNC$;

SQL> create table BKPPDB_SYNC$ as select * from PDB_SYNC$;

SQL> delete from PDB_SYNC$ where SQLSTMT like ('%alter user "xxx"%');

SQL> commit;

On PDB make a backup of  PDB_SYNC$  table and delete de offending rows,stop / start the PDB

===================================================

SQL> alter session set container=PDB;

SQL> col NAME format a30

SQL> col SQLSTMT format a100

SQL> Select CTIME,SQLSTMT,NAME,FLAGS,OPCODE,REPLAY#  from PDB_SYNC$;

SQL> create table BKPPDB_SYNC$ as select * from PDB_SYNC$;

SQL> delete from PDB_SYNC$ where SQLSTMT like ('%alter user "xxx"%');

SQL> commit;

SQL> alter session set container=CDB$ROOT;

SQL> alter pluggable database PDB close;

SQL> alter pluggable database PDB open;