oracle12c 多租户治理四(容器毗邻切换)
一、本地毗邻
1.1、说明
alter session 切换容器的语法
ALTER SESSION SET CONTAINER = container_name [SERVICE = service_name]
For container_name, specify one of the following:
• CDB$ROOT to switch to the CDB root
• PDB$SEED to switch to the CDB seed
• A PDB name to switch to the PDB
When the current container is the root, you can view the names of the PDBs in a CDB by querying the DBA_PDBS view
1.2、毗邻cdb
[oracle@oracle18c1 admin]$ ps -ef |grep pmon
oracle 3739 1 0 20:39 ? 00:00:00 ora_pmon_mycdb
oracle 9642 3635 0 22:03 pts/0 00:00:00 grep --color=auto pmon
[oracle@oracle18c1 admin]$ export ORACLE_SID=mycdb
[oracle@oracle18c1 admin]$ sqlplus / as sysdba
SQL*Plus: Release 18.0.0.0.0 - Production on Sat May 16 22:03:11 2020
Version 18.3.0.0.0
Copyright (c) 1982, 2018, Oracle. All rights reserved.
Connected to:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.3.0.0.0
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
2 PDB$SEED READ ONLY NO
3 MYPDB1 READ WRITE NO
4 MYPDB2 READ WRITE NO
5 YOUPDB MOUNTED
1.3、cdb和pdb间的切换
1、切换到seed容器
SQL> alter session set container=PDB$SEED;
Session altered.
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
2 PDB$SEED READ ONLY NO
2、由seed容器切换到mypdb1
SQL> alter session set container=mypdb1;
Session altered.
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
3 MYPDB1 READ WRITE NO
3、由mypdb1切换到根cdb
SQL> alter session set container=CDB$ROOT;
Session altered.
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
2 PDB$SEED READ ONLY NO
3 MYPDB1 READ WRITE NO
4 MYPDB2 READ WRITE NO
5 YOUPDB MOUNTED
二、远程毗邻
1、毗邻cdb
[oracle@oracle18c1 admin]$ sqlplus sys/Pa44w0rd@192.168.5.40:1521/mycdb as sysdba
SQL*Plus: Release 18.0.0.0.0 - Production on Sat May 16 22:10:58 2020
Version 18.3.0.0.0
Copyright (c) 1982, 2018, Oracle. All rights reserved.
Connected to:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.3.0.0.0
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
2 PDB$SEED READ ONLY NO
3 MYPDB1 READ WRITE NO
4 MYPDB2 READ WRITE NO
5 YOUPDB MOUNTED
2、毗邻mypdb1
[oracle@oracle18c1 admin]$ sqlplus sys/Pa44w0rd@192.168.5.40:1521/mypdb1 as sysdba
SQL*Plus: Release 18.0.0.0.0 - Production on Sat May 16 22:10:42 2020
Version 18.3.0.0.0
Copyright (c) 1982, 2018, Oracle. All rights reserved.
Connected to:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.3.0.0.0
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
3 MYPDB1 READ WRITE NO
每一份赞赏源于明白
赞赏
0人进行了赞赏支持
0
珍藏
诚信在线 www.nzg8.com自与农展馆合作以来,拓展了业务战线,深化了服务体系,整合了群体,在未来的2019年,将能更好地为诚信在线娱乐网的会员提供更优质的服务。
网友评论
最新评论
@澳洲幸运5官网(a55555.net) 在当日商务部召开的例行新闻公布会上,新闻谈话人岑岭进一步透露,现在正在抓紧推进《电子商务“十四五”计划》的体例事情,设计今年下半年出台。为支持新型消费的生长,商务部还将会同有关部门加速国际消费中央都会的培育建设,培育一批标志性商圈,打造一刻钟的便民生涯消费圈,新建刷新一批便利店、菜市场、早餐店、维修点等便民商业设施。不会这样吧
@澳洲幸运5官网(a55555.net) 觉得缺点什么