Using Dbms_service to manage Oracle's services (single instance)

----Create a new service, Pmon will automatically (dynamically) register to Tnslsnr after creation, the service created is not permanent and will be lost after the database restarts.

To persist requires the use of ALTER system set service_names= ' xx ', ' SSX ';

EXEC dbms_service. Create_service (' Hlj ', ' hlj.oracle.com ');

EXEC dbms_service. Create_service (' Hlj ', ' Hlj ');

-----Start the Service

EXEC dbms_service. Start_service (' Hlj ');

------Close Service

EXEC dbms_service. Stop_service (' Hlj ');

------Delete Service (only temporarily deleted, the database will be restored after reboot)

EXEC dbms_service. Delete_service (' Hlj ');

-------Disconnect

EXEC dbms_service. Disconnect_session (' Hlj ');

Using Dbms_service to manage Oracle's services (single instance)