楼主不要被PDB吓住。
建好pdb之后,lsnrctl stat 看监听状态
会有类似于下面的内容:
Service "pdb2" has 1 instance(s).
Instance "cdb", status READY, has 1 handler(s) for this service...如果想连到pdb2,新建一个连接串
pdb2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = pdb2)
)
)
然后用这个连接串来连接pdb2就可以了。
如果是在sqlplus里使用下面的语句来切换pdb
alter session set container=pdb2;
建好pdb之后,lsnrctl stat 看监听状态
会有类似于下面的内容:
Service "pdb2" has 1 instance(s).
Instance "cdb", status READY, has 1 handler(s) for this service...如果想连到pdb2,新建一个连接串
pdb2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = pdb2)
)
)
然后用这个连接串来连接pdb2就可以了。
如果是在sqlplus里使用下面的语句来切换pdb
alter session set container=pdb2;
lsnrctl stat 运行之后出现这个提示