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,

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-l

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

This message: [ Message body ]
Next message: dimensional.dba_at_comcast.net: "RE: Got an available Sr Oracle DBA position in Orlando, FL if interested"
Previous message: Noveljic Nenad: "scalar subquery costing"
Next in thread: Le, Binh T.: "RE: How to auto start Service in non-rac db (12c)"
Reply: Le, Binh T.: "RE: How to auto start Service in non-rac db (12c)"
Maybe reply: Sourav Biswas: "Re: How to auto start Service in non-rac db (12c)"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message