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

From: Sourav Biswas <>
Date: Fri, 24 May 2019 16:26:11 +0000
Message-ID: <BM1PR0101MB1394516C9EC950F5E4C44E6FF0020_at_BM1PR0101MB1394.INDPRD01.PROD.OUTLOOK.COM>

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

Received on Fri May 24 2019 - 18:26:11 CEST

Original text of this message