Re: oracle restart

  • From: Stephane Faroult <sfaroult@xxxxxxxxxxxx>
  • To: goran00@xxxxxxxxx
  • Date: Mon, 27 Dec 2010 12:27:14 +0100

Goran,

   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
>

Other related posts: