RE: How to auto start Service in non-rac db (12c)

From: Le, Binh T. <>
Date: Fri, 24 May 2019 18:10:51 +0000
Message-ID: <>

exec dbms_service.create_service(service_name=>'your_service_name', network_name=>'your_service_name');
-- Start service

exec dbms_service.start_service('your_service_name','your_database_instance_name');
-- Stop the Service

exec dbms_service.stop_service('your_service_name');

  • Delete Service exec dbms_service.delete_service(service_name=>'your_service_name');
  • Disconnect all session related to service exec dbms_service.disconnect_session('your_service_name')

SQL> alter system set service_names='your_service_name,your_database_instance_name' scope=both;

SQL> alter system register;

From: <> On Behalf Of Sourav Biswas Sent: Friday, May 24, 2019 12:26 PM
To: Oracle Mailinglist <> Subject: How to auto start Service in non-rac db (12c)

***This email is from an external source. Only open links and attachments from a Trusted Sender.*** Hi All,

After creating and starting service using DBMS_SERVICE package, I'm able to see the service in dba_services and v$active_services views.

However, after bouncing the database(, I have to manually start the service.

I wanted to know whether there is an option to auto-start this service along with database, or is this how it is supposed to be.

Note: This is standalone non-CDB database without Oracle Restart configured.

By the way, I also reviewed the options mentioned in Doc ID 2006021.1, but mine is non-CDB.

Please suggest.

Best Regards,
Sourav Biswas
Notice of Confidentiality: **This E-mail and any of its attachments may contain Lincoln National Corporation proprietary information, which is privileged, confidential, or subject to copyright belonging to the Lincoln National Corporation family of companies. This E-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this E-mail, you are hereby notified that any dissemination, distribution, copying, or action taken in relation to the contents of and attachments to this E-mail is strictly prohibited and may be unlawful. If you have received this E-mail in error, please notify the sender immediately and permanently delete the original and any copy of this E-mail and any printout. Thank You.**

Received on Fri May 24 2019 - 20:10:51 CEST

Original text of this message