拔出和插入一个插件数据库合并两个容器数据库和容器管理，课程第69次（2017-03-24星期五）

botang · 发表于 2017-3-25 00:08:44

本帖最后由 botang 于 2017-3-25 00:11 编辑

上完1Z0-063第3章（各种方法创建多租户数据库，拔出和插入插件库）
上完1Z0-063第4章（管理多租户数据库）
进行1Z0-063第5章
1Z0-052共19章（上完19章），1Z0-053共21章（上完21章），1Z0-063多租户部分共9章（上完4章）
总共上完全部49章中的44章

select pdb_name , status , guid, con_id from cdb_pdbs;
select name , open_mode , con_id from v$pdbs;
alter pluggable database pdb_orcl2 open;
select name from v$datafile;
declare
v_1 boolean ;
begin
v_1 := dbms_pdb.check_plug_compatibility('/home/oracle/pdb1_1.xml','pdb1_1');
if v_1 then
dbms_output.put_line('YES');
else
dbms_output.put_line('NO');
end if;
end;
select message, action from pdb_plug_in_violations pdb
where pdb.NAME='PDB1_1';
select message, action from pdb_plug_in_violations pdb
where pdb.NAME='PDB_ORCL2';
create pluggable database pdb1_1
using '/home/oracle/pdb1_1.xml' nocopy;
select name , open_mode , con_id from v$pdbs;
select pdb_name , status , con_id from cdb_pdbs;
alter pluggable database pdb1_1 open ;
---
select name , open_mode , con_id from v$pdbs;
select pdb_name , status , con_id from cdb_pdbs;
alter pluggable database all open;
create or replace trigger open_all_pdbs
after startup on database
begin
execute immediate 'alter pluggable database all open';
end;
select name , open_mode , con_id from v$pdbs;
select pdb_name , status , con_id from cdb_pdbs;
alter pluggable database all open;
create or replace trigger open_all_pdbs
after startup on database
begin
execute immediate 'alter pluggable database all open';
end;
---
---
select ispdb_modifiable
from v$parameter p
where p.name='optimizer_use_sql_plan_baselines';
select ispdb_modifiable , value,con_id
from v$parameter p
where p.name='optimizer_use_sql_plan_baselines';
select ispdb_modifiable , value,con_id
from v$system_parameter p
where p.name='optimizer_use_sql_plan_baselines';
select * from database_properties;
(SELECT property_name, property_value
FROM
database_properties
WHERE property_name LIKE 'DEFAULT_%TABLE%';
)
select t.tablespace_name , con_id
from cdb_tablespaces t ;
create tablespace cdata datafile '/u01/app/oracle/oradata/cdb2/cdata_01.dbf'
size 10M;
ALTER DATABASE DEFAULT TABLESPACE CDATA ;
select tablespace_name , con_id from cdb_tablespaces
where contents='TEMPORARY';
CREATE TEMPORARY TABLESPACE TEMP_ROOT
TEMPFILE '/u01/app/oracle/oradata/cdb2/temproot_01.dbf'
SIZE 500M ;
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP_ROOT ;
select * from database_properties;
CREATE USER c##u IDENTIFIED BY x;
select username , default_tablespace, temporary_tablespace ,con_id
from cdb_users where username='C##U' order by con_id;

复制代码