While creating many PDBs I'll get the following error:
SQL> create pluggable database pdb45 admin user admin identified by ***
ERROR at line 1:
ORA-00603: ORACLE server session terminated by irrecoverable error
ORA-04031: out of shared memory in shared pool
ORA-65169: error encountered while attempting to copy file
/u02/oradata/FREE/pdbseed/undotbs01.dbf
ORA-04031: out of shared memory in shared pool
Process ID: 20446
Session ID: 560 Serial number: 42534
The PDB exists afterwards in v$pdbs but not in dba_pdbs.
SQL> drop pluggable database PDB45 including datafiles;
drop pluggable database PDB45 including datafiles
*
ERROR at line 1:
ORA-65011: Pluggable database PDB45 does not exist.
SQL> create pluggable database PDB45 admin user admin identified by Welcome1_;
create pluggable database PDB45 admin user admin identified by Welcome1_
*
ERROR at line 1:
ORA-65012: Pluggable database PDB45 already exists.
I'm not able to drop or recreate the pluggable database.
In the alertlog I'll get the following error message:
Undo Create of Pluggable Database PDB45 with pdb id - 46.
Script to reproduce:
for (( i=1; i<254; i++ )); do
sqlplus / as sysdba <<EOF
create pluggable database pdb$i admin user admin identified by Welcome1_;
alter pluggable database pdb$i open;
exit
EOF
done