isitdevops.com/databases

MODIFY THE 12c SEED DATABASE
============================
This is an initial empty setup
SQL> select name, cdb from v$database;
ORCPDB1 YES

SQL> show pdbs
CON_ID CON_NAME   OPEN MODE  RESTRICTED
——- ———- ———- ———-
2 PDB$SEED   READ ONLY  NO

SQL> alter session set “_oracle_script”=true;

SQL> shutdown immediate

SQL> startup

SQL> select name,open_mode from v$pdbs;
NAME            OPEN_MODE
————— ———-
PDB$SEED        READ WRITE

SQL> show con_name
PDB$SEED

SQL> create tablespace MYTBS1 datafile ‘/oradata/orpcdb1/pdbseed/mytbs1.dbf’ size 200M;

SQL> alter database default tablespace MYTBS1;

SQL> create user devops identified by temp123 default tablespace MYTBS1 password expire;

SQL> shutdown immediate

SQL> startup open read only

SQL> select name,open_mode from v$pdbs;
NAME            OPEN_MODE
————— ———-
PDB$SEED        READ ONLY

SQL> alter session set “_oracle_script”=true;

SQL> show con_name

SQL> create pluggable database MYpdb1 admin user measadmin identified by measadmin file_name_convert=(‘/oradata/orpcdb1/pdbseed/’,’/oradata/orpcdb1/mypdb1/’);

SQL> show pdbs
CON_ID CON_NAME                       OPEN MODE  RESTRICTED
———- —————————— ———- ———-
2 PDB$SEED                       READ ONLY  NO
3 MYPDB1                         MOUNTED

SQL> alter pluggable database Mypdb1 open;

The new database now already has the user and tablespace.