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

  • From: Sourav Biswas <biswas.sourav@xxxxxxxxxxx>
  • To: Oracle Mailinglist <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 24 May 2019 16:26:11 +0000

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(12.1.0.2), 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 12.1.0.2 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
+91-9650017306

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 05-2019