Skrevet av Emne: Oracle: How to cancel a pending 'shutdown immediate'  (Lest 12299 ganger)

ATC

  • Gjest
Oracle: How to cancel a pending 'shutdown immediate'
« på: 07. August 2009, 14:36 pm »
  • [applaud]0
  • [smite]0
  • Idle clients are preventing 'shutdown immediate' from actually shutting doen the instance. Issuing another command like 'shutdown abort' fails with a string of error messages:
    ORA-24324: service handle not initialized
    ORA-24323: value not allowed
    ORA-01089: immediate shutdown in progress - no operations are permitted



    ATC

    • Gjest
    [Solved] Oracle: How to cancel a pending 'shutdown immediate'
    « Svar #1 på: 07. August 2009, 14:36 pm »
  • [applaud]0
  • [smite]0
  • Although you cannot cancel the shutdown per se, you can restart the instance by connecting as sysdba and issuing the following command:
    'startup force'

    From the shutdown pending state, this actually causes the instance to 'shutdown abort' and then start up, minimizing downtime.