RE: DBMS_SERVICE create service/start_service and DB Restarts doesn't start service
Date: Wed, 6 Mar 2013 13:42:58 -0600
Message-ID: <F05D8DF1FB25F44085DB74CB916678E88582D51890_at_NADCWPMSGCMS10.hca.corpad.net>
In this case the service was UP before we shutdown the database but not up after the database was restarted.
The service was created using DBMS_SERVICE.CREATE_SERVICE and started using DBMS_SERVICE.START_SERVICE.
I'm fairly certain that it's needs to be added to SERVICE_NAMES because when doing that it automatically starts the service and registers with the listener.
Chris
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Ls Cheng
Sent: Wednesday, March 06, 2013 1:39 PM
To: Taylor Christopher - Nashville
Cc: oracle-l_at_freelists.org
Subject: Re: DBMS_SERVICE create service/start_service and DB Restarts doesn't start service
I am not sure if this applies in Oracle Restart but in RAC when the database is shutdown the service is already stopped when you start the database the services wont start automatically, it saves the service state before database shutdown to decide whether or not start the service when the database starts Regards
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Mar 06 2013 - 20:42:58 CET