Manage PDB Service Names

Click on the link below for a tutorial on Oracle Multitenant Architecture - Managing PDB Service Names. This link points to  a YouTube video.

Watch a YouTube video on Oracle 18c Multitenant Architecture - Manage PDB Service Name

Examples

select name from all_services;

alter session set container=pdb1;

select name from v$active_services;

exec DBMS_SERVICE.CREATE_SERVICE('sales_svc','sales_svc');

exec DBMS_SERVICE.DELETE_SERVICE('sales_svc');

exec DBMS_SERVICE.CREATE_SERVICE('sales_svc','sales_svc');

select name from all_services;

select name from v$active_services;

exec DBMS_SERVICE.START_SERVICE('sales_svc');

select name from v$active_services;