A technical troubleshooting blog about Oracle with other Databases & Cloud Technologies.

Creating pluggable database from seed, when pdb$seed in in mount state and open state.

1 min read
SQL> show pdbs
 
    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       MOUNTED
         3 PDB1                           READ WRITE NO
         4 DEV                            READ WRITE NO
SQL> create pluggable database PDB2 ADMIN USER SALAM identified by Oracle create_file_dest='+DEV_DG_FLASH';
create pluggable database PDB2 ADMIN USER SALAM identified by Oracle create_file_dest='+DEV_DG_FLASH'
*
ERROR at line 1:
ORA-65036: Pluggable database PDB$SEED not open in required mode
 
SQL> alter pluggable database PDB$SEED open read only;
 
Pluggable database altered.
 
SQL> show pdbs
 
    CON_ID CON_NAME               OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY    NO
         3 PDB1                               READ WRITE  NO
         4 DEV15                             READ WRITE  NO
SQL> create pluggable database PDB2 ADMIN USER SALAM identified by Oracle create_file_dest='+DEV_DG_FLASH';       
 
Pluggable database created.
 
SQL> show pdbs
 
    CON_ID CON_NAME               OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY     NO
         3 PDB1                               READ WRITE   NO
         4 DEV                                 READ WRITE   NO
         7 PDB2                               MOUNTED

In the above , first we tried to create a new pluggable database PDB2 from seed when PDB$SEED was in mount state. Then we opened the PDB$SEED and created PDB2 from seed succesfully.