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