12c connect to pdb through service
Lsnrctl serviceLSNRCTL for Linux: Version 12.1.0.2.0-Production on 06-MAR-2018 06:52:45Copyright (c) 1991, 2014, Oracle. All rights reserved.Connecting to (DESCRIPTION= (ADDRESS= PROTOCOL=TCP) (HOST=orcl) (PORT=1521)) Services Summary...Service "cdb1" has 1 instance (s). Instance "cdb1", status READY, has 1 handler (s) for this service... Handler (s): "DEDICATED" established:0 refused:0 state:ready LOCAL SERVERService "cdb1XDB" has 1 instance (s). Instance "cdb1", status READY, has 1 handler (s) for this service... Handler (s): "D000" established:0 refused:0 current:0 max:1022 state:ready DISPATCHER (ADDRESS= (PROTOCOL=tcp) (HOST=roidb01) (PORT=17408)) Service "pdb11" has 1 instance (s). Instance "cdb1", status READY, has 1 handler (s) for this service... Handler (s): "DEDICATED" established:0 refused:0 state:ready LOCAL SERVERThe command completed successfully$SQL > set line 120SQL > select name,network_name,pdb from v$services NAME NETWORK_NAME PDB-- sales Sales1 PDB11pdb11 pdb11 PDB11cdb1XDB cdb1XDB CDB$ROOTcdb1 cdb1 CDB$ROOTSYS$BACKGROUND CDB$ROOTSYS$USERS CDB$ROOT6 rows selected.SQL > SQL > alter session set container=pdb11 Session altered.SQL > select name,network_name,pdb from v$services NAME NETWORK_NAME PDB-- sales Sales1 PDB11 # # manually created service pdb11 pdb11 PDB11SQL > exec dbms_service.start_service ('sales') # # launch Service PL/SQL procedure successfully completed.SQL > $lsnrctl service;LSNRCTL for Linux: Version 12.1.0.2.0-Production on 06-MAR-2018 06:58:04Copyright (c) 1991, 2014, Oracle. All rights reserved.Connecting to (DESCRIPTION= (ADDRESS= PROTOCOL=TCP) (HOST=orcl) (PORT=1521)) Services Summary...Service "cdb1" has 1 instance (s). Instance "cdb1", status READY, has 1 handler (s) for this service... Handler (s): "DEDICATED" established:0 refused:0 state:ready LOCAL SERVERService "cdb1XDB" has 1 instance (s). Instance "cdb1", status READY, has 1 handler (s) for this service... Handler (s): "D000" established:0 refused:0 current:0 max:1022 state:ready DISPATCHER (ADDRESS= (PROTOCOL=tcp) (HOST=roidb01) (PORT=17408)) Service "pdb11" has 1 instance (s). Instance "cdb1", status READY, has 1 handler (s) for this service... Handler (s): "DEDICATED" established:0 refused:0 state:ready LOCAL SERVERService "sales1" has 1 instance (s). # # Service has registered Instance "cdb1", status READY, has 1 handler (s) for this service... through pmon Handler (s): "DEDICATED" established:0 refused:0 state:ready LOCAL SERVERThe command completed successfully$$sqlplus sys/oracle@roidb01:1521/sales1 as sysdba # # connect to pdbSQL*Plus by service name: Release 12.1.0.2.0 Production on Tue Mar 6 06:58:39 2018Copyright (c) 1982, 2014, Oracle. All rights reserved.Connected to:Oracle Database 12c Enterprise Edition Release 12.1.0.2.0-64bit ProductionWith the Partitioning, OLAP Advanced Analytics and Real Application Testing optionsSQL > show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED- 3 PDB11 READ WRITE NOSQL > # # commands for creating, starting, and shutting down services The service is lost after restart. You can test SQL > exec dbms_service.start_service ('sales') by yourself. PL/SQL procedure successfully completed.SQL > SQL > exec dbms_service.stop_service ('sales'); PL/SQL procedure successfully completed.SQL > exec dbms_service.delete_service (' sales'); PL/SQL procedure successfully completed.SQL > exec dbms_service.create_service ('sales','sales1'); PL/SQL procedure successfully completed.