Oracle 12c多租戶常用管理命令有哪些

139次閱讀

沒有評論

共計 2971 個字符，預計需要花費 8 分鐘才能閱讀完成。

這篇文章給大家分享的是有關 Oracle 12c 多租戶常用管理命令有哪些的內容。丸趣 TV 小編覺得挺實用的，因此分享給大家做個參考，一起跟隨丸趣 TV 小編過來看看吧。

– 進入 cdb
sqlplus /nolog
conn sys/sys as dba

– 查看數據庫基本信息
select name,cdb from v$database;

– 查看容器的相關信息
select con_id,name from v$containers;

– 查看數據文件的路徑
select con_id,file_name from cdb_data_files order by 1;

– 顯示當前連接容器信息
show con_id con_name user

– 顯示所有 pdb
show pdbs

–start 和 stop 根容器

– 啟動數據
–CDB
sqlplus / as sysdba
startup

–PDB(所有 PDB)
alter pluggable database all open;
– 啟動 pdb1 庫
alter pluggable database pdb1 open;

– 關閉數據庫
–CDB
shutdown immediate

–pdb1
alter pluggable database pdb1 close;
alter pluggable database pdb1 close immediate;
– 關閉所有 pdb
alter pluggable database all close immediate;

– 創建公用用戶 (sys 和 system 在可插拔中就是自動創建的公用用戶)
sqlplus / as sysdba
create user c#dba identified by alex;

– 創建公用角色
sqlplus / as sysdba
create role c##dbaprivs container=all;

grant dba to c##dbaprivs container=all;

– 公用角色給公用用戶
grant c##dbaprivs to c#dba container=all;

– 切換容器
alter session set container=ehrpdb;
– 切換回根容器
alter session set container=cdb$root;

–2 創建可插拔數據庫
–2.1 克隆種子容器
create pluggable database cpcdb
admin user cpcadm identified by cpcadm
file_name_convert=(/oracle/app/oracle/oradata/edw/pdbseed , /oradata/edw/cpcdb/datafile/

–2.2 直接創建數據庫
CREATE PLUGGABLE DATABASE hrdb
ADMIN USER hrdba IDENTIFIED BY hrdba
STORAGE (MAXSIZE 100G MAX_SHARED_TEMP_SIZE 2G)
DEFAULT TABLESPACE hrdb DATAFILE /oradata/EDW/hrdb/datafile/hrdb001.dbf SIZE 512M AUTOEXTEND on next 8M maxsize 10G;

CREATE PLUGGABLE DATABASE cpcdb
ADMIN USER cpcdba IDENTIFIED BY cpcdba
STORAGE (MAXSIZE 100G MAX_SHARED_TEMP_SIZE 2G)
DEFAULT TABLESPACE tbscpc DATAFILE /oradata/EDW/cpcdb/datafile/tbscpc001.dbf SIZE 512M AUTOEXTEND on next 8M maxsize 10G;

–2.3 創建數據案例

create pluggable database cpcdb
admin user cpcadm identified by cpcadm
file_name_convert=(/oracle/app/oracle/oradata/edw/pdbseed , /oradata/edw/cpcdb/datafile/

create pluggable database ncdb
admin user ncadm identified by ncadm
file_name_convert=(/oradata/edw/pdbseed , /oradata/edw/ncdb/datafile/

CREATE PLUGGABLE DATABASE ncdb
ADMIN USER ncdba IDENTIFIED BY ncdba
STORAGE (MAXSIZE 100G MAX_SHARED_TEMP_SIZE 2G);

– 訪問 ncdb 的插拔數據庫
sqlplus sys/ncdba@oraerp:1521/ncdb as sysdba

– 關閉 PDB 數據庫
alter pluggable database ncdb close immediate;
alter pluggable database hrdb close immediate;
alter pluggable database cpcdb close immediate;
alter pluggable database edwpdb close immediate;
– 刪除 PDB 數據庫
DROP PLUGGABLE DATABASE ncdb INCLUDING DATAFILES;
DROP PLUGGABLE DATABASE hrdb INCLUDING DATAFILES;
DROP PLUGGABLE DATABASE cpcdb INCLUDING DATAFILES;
DROP PLUGGABLE DATABASE edwpdb INCLUDING DATAFILES;

– 創建 pdb 案例
–1、cpcdb
create pluggable database cpcdb
admin user cpcadm identified by cpcadm
file_name_convert=(/oradata/edw/pdbseed/ , /oradata/edw/cpcdb/

–2、ncdb
create pluggable database ncdb
admin user ncadm identified by ncadm
file_name_convert=(/oradata/edw/pdbseed/ , /oradata/edw/ncdb/

–3、hrdb
create pluggable database hrdb
admin user hradm identified by hradm
file_name_convert=(/oradata/edw/pdbseed/ , /oradata/edw/hrdb/

alter pluggable database all open;

– 登錄 cpcdb
$sqlplus sys/Oracleedw13@192.168.2.218:1531/cpcdb as sysdba

$sqlplus sys/OraEdw!23@192.168.1.105:1533/ncdb as sysdba – 含有！需要單獨輸入密碼

感謝各位的閱讀！關于“Oracle 12c 多租戶常用管理命令有哪些”這篇文章就分享到這里了，希望以上內容可以對大家有一定的幫助，讓大家可以學到更多知識，如果覺得文章不錯，可以把它分享出去讓更多的人看到吧！

正文完