{2 マルチテナント}OracleNet経由でPDBに接続

https://docs.oracle.com/cd/F19136_01/multi/administering-pdbs-with-sql-plus.html#GUID-245289C5-75BC-4CD9-861F-FEAAA42064AC

select NAME,PDB from cdb_services order by NAME,PDB;

cdh
cd network/admin

vim listener.ora

LISTENER_orcl =
  (ADDRESS_LIST=
       (ADDRESS=(PROTOCOL=tcp)(HOST=mmm111)(PORT=1524)))

lsnrctl stop LISTENER_orcl
lsnrctl start LISTENER_orcl
lsnrctl status LISTENER_orcl

vim tnsnames.ora

LISTENER_orcl= 
 (DESCRIPTION = 
  (ADDRESS=(PROTOCOL=tcp)(HOST=mmm111)(PORT=1524)))

pdb11 =
  (DESCRIPTION=
  (ADDRESS=(PROTOCOL=tcp)(HOST=mmm111)(PORT=1524))
  (CONNECT_DATA=
     (SERVICE_NAME=pdb11.example.com)))

show parameter listener
alter system set local_listener=LISTENER_orcl;
show parameter listener

sqlplus system/oracle@pdb11

show con_name

lsnrctl status listener_orcl