Re: oracle restart

   I suspect that to decide whether a resource was shut down intentionally or not "oracle restart" checks for the presence of files that are normally removed during a "clean" shutdown - typically files that contain a pid, or something as classic as this. Therefore I doubt you can set any attribute.
  What you can possibly do is wrap the regular commands (lsnrctl) into scripts or your own that save files that are normally present only when the resource is up (or crashed) to some location of your own, and have something that restores (possibly selectively) those files when you want to restart everything, whatever happened. But it looks to me rather complicated, not necessarily easy to maintain if something changes in future versions, and all things considered I'd rather script a restart of my own ...

HTH Stephane Faroult
RoughSea Ltd <http://www.roughsea.com>
Konagora <http://www.konagora.com>
RoughSea Channel on Youtube <http://www.youtube.com/user/roughsealtd>

On 12/27/2010 11:50 AM, goran bogdanovic wrote:
> Hi,
>
> I recently checked this new oracle feature and come to a conclusions
> that 'oracle restart' doesn't restart automatically resources (e.g.
> listener) if being stopped manually using regular tools (e.g. lsnrctl).
> In docs I have also found that this is intended behaviour of 'oracle
> restart'
> <>
> Oracle utilities such as SQL*Plus, the Listener Control utility
> (|LSNRCTL|), and |ASMCMD| are integrated with Oracle Restart. If you
> shut down the database with SQL*Plus, Oracle Restart does not
> interpret this as a database failure and does not attempt to restart
> the database. Similarly, if you shut down the Oracle ASM instance with
> SQL*Plus or |ASMCMD|, Oracle Restart does not attempt to restart it.
> <>
>
> Does anyone knows is there any way to change this behaviour for
> specific resource (like setting attribute) ... i.e. even if resource
> has been stopped manually (not using srvctl or crsctl) 'oracle
> restart' will attempt to restart it.
>
> many thanks,
> goran
>

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