Oracle12c如何连接到CDB和PDB.docx

1、Oracle12c如何连接到CDB和PDBOracle12c如何连接到CDB和PDB 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 right

2、s reserved.Connected to:Oracle Database 12c Enterprise EditionRelease 12.1.0.1.0 - 64bit ProductionWith the Partitioning, OLAP, AdvancedAnalytics and Real Application Testing optionsD000 established:0 refused:0 current:0 max:1022 state:readyDISPATCHER (ADDRESS=(PROTOCOL=tcp)(HOST=Ora12c)(PORT=14696)

3、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 refu

4、sed: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 Data

5、base 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 = DEDIC

6、ATED)(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, Advan

7、cedAnalytics 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

8、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-切换contai

9、ner：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 Da

10、tabase 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 = DEDIC

11、ATED)(SERVICE_NAME = pcndba2)C:UsersDavesqlplussystem/oraclepcndbaSQL*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