Re: Shutting down Oracle under VMS

In article <80108BAN$VQxEwJS_at_juno.demon.co.uk>, Richard Armstrong (richard_at_juno.demon.co.uk) says...
!>
!>Can anyone suggest a reliable way of automatically shutting down Oracle
!>7.1 during a VMS shutdown ?
!>
!>The VMS SYSTEM user can't perform privileged Oracle operations so
!>calling the Oracle shutdown scripts from the VMS site specific shutdown
!>script doesn't work. We get round this during VMS startup by
!submitting
!>the Oracle startup script to a batch queue with the /USER=ORACLE
!>qualifier. However, by the time the site specific shutdown script
!runs,
!>all of the batch queues have been shut down so this trick is no good.
!>
!>We have tried using a SET UIC command in the Oracle shutdown script but
!>this won't work either. Oracle support have suggested modifying the
!DEC
!>supplied VMS shutdown script but this seems a bit drastic !
!>
!>Does anyone know whether Oracle will shut down in a controlled manner
!if
!>we simply leave VMS to kill off Oracle's processes during shut down.
!>(i.e. will it commit uncommitted data and flush data in the SGA to
!>disk).
!>
!>Any comments will be gratefully received.
!>--
!>Richard Armstrong

I've only once installed Oracle on VMS, but I allways pay much attention to automatic startup and shutdown. I found no way to do an automatic shutdown, documentation even stated there was none (but they say that also for AIX 3, while you can insert it in the shutdown script, why not do the same? Document it well and remember to insert it again after an update of the OS).
Sorry to dissapoint you, and seen my limited experience, keep looking on

-- 
Kind reGards
     \ /   |
      X    |
     / \   s
     Gerard