Create Pluggable seed database

oracle@localhost ~ $ sqlplus
SQL*Plus: Release 12.2.0.1.0 Production on Sat Aug 20 09:28:54 2022
Copyright (c) 1982, 2016, Oracle.  All rights reserved.
Enter user-name: / as sysdba
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 MDB                            READ WRITE NO
SQL> CREATE PLUGGABLE DATABASE MDB2 ADMIN USER PDBADMIN IDENTIFIED BY "monu" DEFAULT TABLESPACE USERS DATAFILE '/u01/app/oracle/oradata/ORCLPDB/MDB2/users01.dbf' SIZE 10M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
FILE_NAME_CONVERT=('/u01/app/oracle/oradata/ORCLPDB/pdbseed/','/u01/app/oracle/oradata/ORCLPDB/MDB2/');  2
CREATE PLUGGABLE DATABASE MDB2 ADMIN USER PDBADMIN IDENTIFIED BY "monu" DEFAULT TABLESPACE USERS DATAFILE '/u01/app/oracle/oradata/ORCLPDB/MDB2/users01.dbf' SIZE 10M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
*
ERROR at line 1:
ORA-65005: missing or invalid file name pattern for file -
/u01/app/oracle/oradata/ORCLPDB/datafile/o1_mf_system_hyshtvwx_.dbf

SQL> alter session set "_oracle_script"=true;
Session altered.

SQL> drop pluggable database "pdb$seed" including datafiles;
drop pluggable database "pdb$seed" including datafiles
*
ERROR at line 1:
ORA-65025: Pluggable database PDB$SEED is not closed on all instances.

SQL> alter pluggable database "pdb$seed" close immediate;

Pluggable database altered.

SQL> drop pluggable database "pdb$seed" including datafiles;

Pluggable database dropped.

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         3 MDB                            READ WRITE NO
SQL> alter session set "_oracle_script"=false;

Session altered.

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         3 MDB                            READ WRITE NO
SQL> alter pluggable database MDB close;

Pluggable database altered.

SQL> alter pluggable database MDB open read only;

Pluggable database altered.

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         3 MDB                            READ ONLY  NO
SQL> create pluggable database "pdb$seed" from MDB
file_name_convert=('/u01/app/oracle/oradata/ORCLPDB/B7B35179C39187CFE055000000000001/datafile/','/u01/app/oracle/oradata/ORCLPDB/pdbseed/')
;  2    3
create pluggable database "pdb$seed" from MDB
*
ERROR at line 1:
ORA-01276: Cannot add file
/u01/app/oracle/oradata/ORCLPDB/pdbseed/o1_mf_system_hysj6qb2_.dbf.  File has
an Oracle Managed Files file name.

SQL> create pluggable database "pdb$seed" from MDB
file_name_convert=('/u01/app/oracle/oradata/ORCLPDB/B7B35179C39187CFE055000000000001/datafile/o1_mf_temp_hysj6qc1_.dbf','/u01/app/oracle/oradata/ORCLPDB/pdbseed/seedtemp.dbf',
'/u01/app/oracle/oradata/ORCLPDB/B7B35179C39187CFE055000000000001/datafile/o1_mf_users_hysj7mlg_.dbf','/u01/app/oracle/oradata/ORCLPDB/pdbseed/seedusers.dbf',
'/u01/app/oracle/oradata/ORCLPDB/B7B35179C39187CFE055000000000001/datafile/o1_mf_undotbs1_hysj6qc0_.dbf','/u01/app/oracle/oradata/ORCLPDB/pdbseed/seedundo.dbf',
'/u01/app/oracle/oradata/ORCLPDB/B7B35179C39187CFE055000000000001/datafile/o1_mf_system_hysj6qb2_.dbf','/u01/app/oracle/oradata/ORCLPDB/pdbseed/seedsystem.dbf',
'/u01/app/oracle/oradata/ORCLPDB/B7B35179C39187CFE055000000000001/datafile/o1_mf_sysaux_hysj6qbv_.dbf','/u01/app/oracle/oradata/ORCLPDB/pdbseed/seedsysaux.dbf') ;  2    3    4    5    6

Pluggable database created.

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       MOUNTED
         3 MDB                            READ ONLY  NO
SQL>
====================To change the PDB parameter ==== 

Connect to PDB  

alter session set container=MDB

alter system set open_cursore=300 scope=both;

===================To check the pluggable DB limit =========

select PROPERTY_NAME,PROPERTY_VALUE,DESCRIPTION,CON_ID FROM cdb_properties WHERE property_name = 'MAX_PDB_STORAGE'
SQL> /

PROPERTY_NAME        PROPERTY_VALUE                   DESCRIPTION                                            CON_ID
-------------------- -------------------------------- -------------------------------------------------- ----------
MAX_PDB_STORAGE      UNLIMITED                        Maximum Space Usage of Datafiles and Local Tempfil          3
                                                      es in Container