oracle怎么从cdb切到pdb,Oracle 数据库中,如何从CDB$ROOT进入到PDB?

慕雪6173905

1 连接到CDB和普通实例一样的连接。 指定ORACLE_SID 以后可以使用OS认证，也可以使用密码进行连接。[oracle@Ora12c /]$ echo $ORACLE_SIDcndba[oracle@Ora12c /]$ sqlplus / as sysdbaSQL*Plus: Release 12.1.0.1.0 Production onMon Apr 28 11:33:43 2014Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to:Oracle Database 12c Enterprise EditionRelease 12.1.0.1.0 - 64bit ProductionWith the Partitioning, OLAP, AdvancedAnalytics and Real Application Testing optionsSQL> conn system/oracleConnected.SQL>--查看CDB中可用的service：SQL> COLUMN name FORMAT A30SQL> SELECT name,pdb2 FROM v$services3 ORDER BY name;NAME PDB------------------------------------------------------------SYS$BACKGROUND CDB$ROOTSYS$USERS CDB$ROOTcndba CDB$ROOTcndbaXDB CDB$ROOTpcndba2 PCNDBA2pdbcndba PDBCNDBA6 rows selected.--通过lsnrctl 也可以判断：[oracle@Ora12c /]$ lsnrctl serviceLSNRCTL for Linux: Version 12.1.0.1.0 -Production on 28-APR-2014 11:35:31Copyright (c) 1991, 2013, Oracle. All rights reserved.Connecting to(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))Services Summary...Service "cndba" has 1instance(s).Instance "cndba", status READY, has 1 handler(s) for thisservice...Handler(s):"DEDICATED" established:0 refused:0 state:readyLOCAL SERVERService "cndbaXDB" has 1instance(s).Instance "cndba", status READY, has 1 handler(s) for thisservice...Handler(s):"D000" established:0 refused:0 current:0 max:1022 state:readyDISPATCHER (ADDRESS=(PROTOCOL=tcp)(HOST=Ora12c)(PORT=14696))Service "pcndba2" has 1instance(s).Instance "cndba", status READY, has 1 handler(s) for thisservice...Handler(s):"DEDICATED" established:0 refused:0 state:readyLOCAL SERVERService "pdbcndba" has 1instance(s).Instance "cndba", status READY, has 1 handler(s) for thisservice...Handler(s):"DEDICATED" established:0 refused:0 state:readyLOCAL SERVERThe command completed successfully[oracle@Ora12c /]$通过这些service，就可以远程连接CDB。--EZCONNECTC:\Users\Dave>sqlplussystem/oracle@192.168.1.10:1521/cndbaSQL*Plus: Release 11.2.0.1.0 Production on 星期三 4月 30 11:36:48 2014Copyright (c) 1982, 2010, Oracle. All rights reserved.连接到:Oracle Database 12c Enterprise EditionRelease 12.1.0.1.0 - 64bit ProductionWith the Partitioning, OLAP, AdvancedAnalytics and Real Application Testing optionsSQL>--通过TNSNAMES.ORA连接：在tnsnames.ora 中配置如下：cndba =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.10)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = cndba)))--连接：C:\Users\Dave>sqlplussystem/oracle@cndbaSQL*Plus: Release 11.2.0.1.0 Production on 星期三 4月 30 11:40:01 2014Copyright (c) 1982, 2010, Oracle. All rights reserved.连接到:Oracle Database 12c Enterprise EditionRelease 12.1.0.1.0 - 64bit ProductionWith the Partitioning, OLAP, AdvancedAnalytics and Real Application Testing optionsSQL>2 在不同Container database中切换在12c的架构中，因为有CDB和 PDB的存在，所以会有很多不同的container，所以在连接到不同的container时，就需要进行切换。--查看当前的container：SQL> show con_nameCON_NAME------------------------------CDB$ROOTSQL> SELECT SYS_CONTEXT('USERENV','CON_NAME') FROM dual;SYS_CONTEXT('USERENV','CON_NAME')--------------------------------------------------------------------------------CDB$ROOTSQL> set lin 140SQL> select con_id, dbid,guid, name , open_mode from v$pdbs;CON_ID DBID GUID NAME OPEN_MODE---------- ------------------------------------------ ---------- ----------2 4088301206 F7C1E3C96BBF0585E0430A01A8C05459 PDB$SEED READ ONLY3 426143573F7C209EB1DFC0854E0430A01A8C0B787 PDBCNDBA READ WRITE4 1231796139 F812DE1B6A8F363AE0430A01A8C0C759 PCNDBA2 READ WRITE--切换container：SQL> alter session setcontainer=pcndba2;Session altered.SQL> show con_nameCON_NAME------------------------------PCNDBA23 连接到PDB--EZCONNECT:C:\Users\Dave>sqlplussystem/oracle@192.168.1.10:1521/pcndba2SQL*Plus: Release 11.2.0.1.0 Production on 星期三 4月 30 11:54:30 2014Copyright (c) 1982, 2010, Oracle. All rights reserved.连接到:Oracle Database 12c Enterprise EditionRelease 12.1.0.1.0 - 64bit ProductionWith the Partitioning, OLAP, AdvancedAnalytics and Real Application Testing optionsSQL>--TNSNAMES.ora在tnsnames.ora 中添加如下内容：pcndba =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.10)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = pcndba2)))C:\Users\Dave>sqlplussystem/oracle@pcndbaSQL*Plus: Release 11.2.0.1.0 Production on 星期三 4月 30 11:55:50 2014Copyright (c) 1982, 2010, Oracle. All rights reserved.连接到:Oracle Database 12c Enterprise EditionRelease 12.1.0.1.0 - 64bit ProductionWith the Partitioning, OLAP, AdvancedAnalytics and Real Application Testing optionsSQL>