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>