DBMS_SERVICE package for managed service in oracle
In Oracle, you can also create service on database through package.
For creation of Service:
exec dbms_service.create_service ( service_name => 'SERVICE1' , network_name => 'SERVICE1');
Check the service status:
select service_id , name, network_name,creation_Date from dba_services;
Start the service:
Stop the service:
Delete the service:
Service must be stopped before deletion command.
Disconnect the session from service: