create database service using dbms_service

 exec dbms_service.stop_service(service_name=>'hypstg');

exec dbms_service.delete_service('hypstg');

exec dbms_service.create_service(service_name=>'hypstg', network_name=>'hypstg');

exec dbms_service.start_service('hypstg');

alter system set service_names='hypstg' scope=both;

alter system register;