How to auto start Service in non-rac db (12c)
From: Sourav Biswas <biswas.sourav_at_hotmail.com>
Date: Fri, 24 May 2019 16:26:11 +0000
Message-ID: <BM1PR0101MB1394516C9EC950F5E4C44E6FF0020_at_BM1PR0101MB1394.INDPRD01.PROD.OUTLOOK.COM>
Hi All,
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(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
-- http://www.freelists.org/webpage/oracle-lReceived on Fri May 24 2019 - 18:26:11 CEST