PDB创建#SEED$PDB

1 开启OMF

show parameter db_create
alter system set db_create_file_dest='/data/cdba';
show parameter db_create

2 创建PDB

show pdbs
create pluggable database pdba admin user pdba_admin identified by oracle;
show pdbs
select con_id, name from v$datafile;
select con_id, name from v$containers;
select con_id, name, open_mode from v$pdbs;
select con_id, file_name from cdb_data_files;
select con_id, pdb_id, pdb_name, status from cdb_pdbs;

select dbid, name, open_mode, cdb, con_id from v$database;
select con_id, dbid, con_uid, guid, name from v$containers;

3 打开PDB

show pdbs
alter pluggable database pdba open;
show pdbs
select con_id, name from v$containers;
select con_id, pdb_id, pdb_name, status from cdb_pdbs;

4 查看监听注册服务

!lsnrctl status