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

From: Chris Taylor <christopherdtaylor1994_at_gmail.com>
Date: Mon, 27 May 2019 06:37:55 -0500
Message-ID: <CAP79kiRp426=GWQLSxX=aroPtefCp0J5sHTPezbwvDDkSeUYwA_at_mail.gmail.com>



Im pretty sure the syntax is:

Alter system set service_names='svc1','svc2' ;

Also see:
dbms_service.create_service('svc1','svc2');

Those quoted strings are important and i believe each svc has to be quoted by itself.

Chris

On Mon, May 27, 2019, 12:59 AM Sourav Biswas <biswas.sourav_at_hotmail.com> wrote:

> 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
>
> ------------------------------
> *From:* kathy duret <katpopins21_at_yahoo.com>
> *Sent:* Sunday, May 26, 2019 12:36:57 AM
> *To:* biswas.sourav_at_hotmail.com; Oracle Mailinglist; Le, Binh T.
> *Subject:* Re: How to auto start Service in non-rac db (12c)
>
> Use srvctl command instead
>
>
> 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
Received on Mon May 27 2019 - 13:37:55 CEST

Original text of this message