RE: How to auto start Service in non-rac db (12c)
Date: Fri, 24 May 2019 18:10:51 +0000
Message-ID: <DM6PR08MB5626E9A47928B468F7520C35F2020_at_DM6PR08MB5626.namprd08.prod.outlook.com>
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-lReceived on Fri May 24 2019 - 20:10:51 CEST