Oracle12c如何连接到CDB和PDB.docx
- 文档编号:10725026
- 上传时间:2023-02-22
- 格式:DOCX
- 页数:7
- 大小:51.71KB
Oracle12c如何连接到CDB和PDB.docx
《Oracle12c如何连接到CDB和PDB.docx》由会员分享,可在线阅读,更多相关《Oracle12c如何连接到CDB和PDB.docx(7页珍藏版)》请在冰豆网上搜索。
Oracle12c如何连接到CDB和PDB
Oracle12c如何连接到CDB和PDB
Oracle12c如何连接到CDB和PDB
1连接到CDB
和普通实例一样的连接。
指定ORACLE_SID以后可以使用OS认证,也可以使用密码进行连接。
[oracle@Ora12c/]$echo$ORACLE_SID
cndba
[oracle@Ora12c/]$sqlplus/assysdba
SQL*Plus:
Release12.1.0.1.0ProductiononMonApr2811:
33:
432014
Copyright(c)1982,2013, Oracle.Allrightsreserved.
Connectedto:
OracleDatabase12cEnterpriseEditionRelease12.1.0.1.0-64bitProduction
WiththePartitioning,OLAP,AdvancedAnalyticsandRealApplicationTestingoptions
"D000"established:
0refused:
0current:
0max:
1022state:
ready
DISPATCHER Ora12c,pid: 10085> (ADDRESS=(PROTOCOL=tcp)(HOST=Ora12c)(PORT=14696)) Service"pcndba2"has1instance(s). Instance"cndba",statusREADY,has1handler(s)forthisservice... Handler(s): "DEDICATED"established: 0refused: 0state: ready LOCALSERVER Service"pdbcndba"has1instance(s). Instance"cndba",statusREADY,has1handler(s)forthisservice... Handler(s): "DEDICATED"established: 0refused: 0state: ready LOCALSERVER Thecommandcompletedsuccessfully [oracle@Ora12c/]$ 通过这些service,就可以远程连接CDB。 --EZCONNECT C: \Users\Dave>sqlplussystem/oracle@192.168.1.10: 1521/cndba SQL*Plus: Release11.2.0.1.0Productionon星期三4月3011: 36: 482014 Copyright(c)1982,2010,Oracle.Allrightsreserved. 连接到: OracleDatabase12cEnterpriseEditionRelease12.1.0.1.0-64bitProduction WiththePartitioning,OLAP,AdvancedAnalyticsandRealApplicationTestingoptions SQL> --通过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@cndba SQL*Plus: Release11.2.0.1.0Productionon星期三4月3011: 40: 012014 Copyright(c)1982,2010,Oracle.Allrightsreserved. 连接到: OracleDatabase12cEnterpriseEditionRelease12.1.0.1.0-64bitProduction WiththePartitioning,OLAP,AdvancedAnalyticsandRealApplicationTestingoptions SQL> 2在不同Containerdatabase中切换 在12c的架构中,因为有CDB和PDB的存在,所以会有很多不同的container,所以在连接到不同的container时,就需要进行切换。 --查看当前的container: SQL>showcon_name CON_NAME ------------------------------ CDB$ROOT SQL>SELECTSYS_CONTEXT('USERENV','CON_NAME')FROMdual; SYS_CONTEXT('USERENV','CON_NAME') -------------------------------------------------------------------------------- CDB$ROOT SQL>setlin140 SQL>selectcon_id,dbid,guid,name,open_modefromv$pdbs; CON_IDDBIDGUIDNAMEOPEN_MODE ------------------------------------------------------------------------ 24088301206F7C1E3C96BBF0585E0430A01A8C05459PDB$SEEDREADONLY 3426143573F7C209EB1DFC0854E0430A01A8C0B787PDBCNDBAREADWRITE 41231796139F812DE1B6A8F363AE0430A01A8C0C759PCNDBA2READWRITE --切换container: SQL>altersessionsetcontainer=pcndba2; Sessionaltered. SQL>showcon_name CON_NAME ------------------------------ PCNDBA2 3连接到PDB --EZCONNECT: C: \Users\Dave>sqlplussystem/oracle@192.168.1.10: 1521/pcndba2 SQL*Plus: Release11.2.0.1.0Productionon星期三4月3011: 54: 302014 Copyright(c)1982,2010,Oracle.Allrightsreserved. 连接到: OracleDatabase12cEnterpriseEditionRelease12.1.0.1.0-64bitProduction WiththePartitioning,OLAP,AdvancedAnalyticsandRealApplicationTestingoptions SQL> --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@pcndba SQL*Plus: Release11.2.0.1.0Productionon星期三4月3011: 55: 502014 Copyright(c)1982,2010,Oracle.Allrightsreserved. 连接到: OracleDatabase12cEnterpriseEditionRelease12.1.0.1.0-64bitProduction WiththePartitioning,OLAP,AdvancedAnalyticsandRealApplicationTestingoptions SQL>
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- Oracle12c 如何 连接 CDB PDB