Oracle12c如何连接到CDB和PDB.docx

Oracle12c如何连接到CDB和PDB1 连接到CDB和普通实例一样的连接。 指定ORACLE_SID 以后可以使用OS认证，也可以使用密码进行连接。oracleOra12c /$ echo $ORACLE_SIDcndbaoracleOra12c /$ 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 也可以判断：oracleOra12c /$ lsnrctl serviceLSNRCTL forLinux: 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 successfullyoracleOra12c /$通过这些service，就可以远程连接CDB。-EZCONNECTC:UsersDavesqlplussystem/oracle192.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:UsersDavesqlplussystem/oraclecndbaSQL*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 optionsSQL2 在不同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:UsersDavesqlplussystem/oracle192.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:UsersDavesqlplussystem/oraclepcndbaSQL*Plus: Release 11.2.0.1.0 Production on 星期三 4月 30 11:55:50 2014Copyright (c) 1