Oracle 12c Multi-tenant configuration and modification of CDB and PDB parameters

1. Configuring CDB instance parameters, affecting CDB and all PDB
The parameters for the CDB configuration routines are not as varied as those for non-CDB databases. The alter system command is used to set initialization parameters and to modify some database configurations with the ALTER DATABASE command.
ALTER SYSTEM SET parameter_name=value container=all;
Note: After using Container=all, CDB is the same as the PDBs parameter. PDBs can set the same parameter locally to a different value, overwriting the value set by the Container=all.

2. Modify CDB
The ALTER database command and NON-CDB databases are the same, but some can affect CDB and all the PDB, some only valid for CDB, specific crossing Internet cafes!

3. Configuring PDB Instance Parameters
If Container=all is set in CDB, the parameters of the PDB will inherit the previous value, but the PDB local parameter can be modified in the PDB container by alter system, overriding (precedence) the parameters inherited from CDB.
3.1 View PDBs support for modified parameters
Show Con_name;
Col value for A30;
Col name for A35;
Select name, value from v$system_parameter WHERE ispdb_modifiable = ' TRUE ' of order by name;
3.2 Modifying PDB instance Parameters
alter system set Parameter_name=value; is equivalent to the ALTER SYSTEM SET parameter_name=value container=current;

4. Modify the PDB
Conn/as SYSDBA
ALTER SESSION SET CONTAINER = pdb1;
--Default Edition for PDB.
ALTER pluggable DATABASE DEFAULT EDITION = ora$base;
--Default tablespace type for PDB.
ALTER pluggable DATABASE SET DEFAULT bigfile tablespace;
ALTER pluggable DATABASE SET DEFAULT smallfile tablespace;
--Default tablespaces for PDB.
ALTER pluggable DATABASE DEFAULT tablespace users;
ALTER pluggable DATABASE DEFAULT temporary tablespace temp;
--Change the global name. This would change the container name and the
--Name of the default service registered with the listener.
ALTER pluggable DATABASE OPEN RESTRICTED force;
ALTER pluggable DATABASE RENAME global_name to Pdb1a.localdomain;
ALTER pluggable DATABASE CLOSE IMMEDIATE;
ALTER pluggable DATABASE OPEN;
--time zone for PDB.
ALTER pluggable DATABASE SET time_zone= ' GMT ';
-Make datafiles in the PDB offline/online and make storage changes.
ALTER pluggable DATABASE datafile '/u01/app/oracle/oradata/cdb1/pdb1/pdb1_users01.dbf ' OFFLINE;
ALTER pluggable DATABASE datafile '/u01/app/oracle/oradata/cdb1/pdb1/pdb1_users01.dbf ' ONLINE;
ALTER pluggable DATABASE datafile '/u01/app/oracle/oradata/cdb1/pdb1/pdb1_users01.dbf '
RESIZE 1G autoextend on NEXT 1M;
--Supplemental logging for PDB.
ALTER pluggable DATABASE ADD supplemental LOG DATA;
ALTER pluggable DATABASE DROP supplemental LOG DATA;

Oracle 12c Multi-tenant configuration and modification of CDB and PDB parameters