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@xxxxxxxxx>
Sent: Sunday, May 26, 2019 12:36:57 AM
To: biswas.sourav@xxxxxxxxxxx; 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@xxxxxxx> 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@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> On Behalf
Of Sourav Biswas
Sent: Friday, May 24, 2019 12:26 PM
To: Oracle Mailinglist <oracle-l@xxxxxxxxxxxxx>
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.**