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

Thanks Kathy. My environment is Stand alone without Oracle Restart.

Binh Le has identified my issue. His solution has worked out in my case. ""
SQL> alter system set service_names='your_service_name,your_database_instance_name' scope=both;

SQL> alter system register
""

Now, everytime I add a Service, I will ensure I add them to "service_names" parameter.

Thank you Binh!!!

Thanks and Regards,
Sourav Biswas
+91-9650017306

https://docs.oracle.com/database/121/RACAD/GUID-C2D37BAB-DA98-49B4-A777-F2B3AA8D2E7A.htm#RACAD5006<https://apc01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdocs.oracle.com%2Fdatabase%2F121%2FRACAD%2FGUID-C2D37BAB-DA98-49B4-A777-F2B3AA8D2E7A.htm%23RACAD5006&data=02%7C01%7C%7C49f3ff95b6b84d516ff008d6e1442bee%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636944080237161201&sdata=kCX56AjSBvzBNI5Kmz4VKAEofrJ7oLl%2Bq2LWZsCShjc%3D&reserved=0>

make sure the role is set properly

   -role PRIMARY
then set the policy

   -policy AUTOMATIC

for your standby

    -role PHYSICAL_STANDBY

my services come up after a bounce automatically

srvctl works much better than dbms_service IMHO

Kathy Duret

On Friday, May 24, 2019, 1:11:49 PM CDT, Le, Binh T. <Binh.Le_at_lfg.com> wrote:

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: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> On Behalf Of Sourav Biswas Sent: Friday, May 24, 2019 12:26 PM
To: Oracle Mailinglist <oracle-l_at_freelists.org> 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(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

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.**

--
http://www.freelists.org/webpage/oracle-l