【无标题】

Oracle 19C 学习笔记

OEM管理地址 Oracle Enterprise Manager Database Express URL:
https://localhost:5500/em

–创建PDB，模板只能用种子库PBDSEED
–create pluggable database 数据库 admin user 用户名 identified by 密码 file_name_convery(‘源插件数据库名’,‘新建的插件数据库名’);
create pluggable database hr admin user hr identified by hr file_name_convert=(‘pdbseed’,‘hrpdb’);

–克隆PDB
create pluggable database test2 from test file_name_convert=(‘test’,‘test2’);

–删除PDB
–alter pluggable database pdb数据库名 close [immediate];
alter pluggable database test2 close;
drop pluggable database test2 including datafiles;

–给PDB用户赋权
alter session set container = hr;
grant dba,resource,connect to hr;

–开启指定PDB
alter pluggable database test open;

–关闭指定插件数据库
alter pluggable database hr close;

–批量开启所有插件数据库
alter pluggable database all open;

–批量关闭所有插件数据库
alter pluggable database all close;

–查看PDB是否保存启动状态
select * from dba_pdb_saved_states;

–开启PDB自启动
–只有在数据库处于open状态时，PDB才会启动
–在根容器下或PDB下执行均可
alter pluggable database hr save state;

–取消PDB自启动
alter pluggable database hr discard state;

–进入PDB管理
alter session set container = hr;

–注册监听服务
alter system register;

–查看密码是否大小写敏感
show parameter sensitive

NAME TYPE VALUE

---

sec_case_sensitive_logon boolean TRUE

–查看角色
dba_role_privs