Re: Shutting down Oracle under VMS

Hi Richard,

I don't understand why you say THE VMS SYSTEM user can't perform privileged Oracle Opérations...

I'm running Oracle 7.1.3.2 on OpenVMS (vax) 6.1 and i can connect internal and shutdown the oracle database from the system User. But you should grant following identifier (ORA_DBA, ORA_<sid>_dba, ORA_OPER or ORA_<sid>_OPER, i'm using ORA_<sid>_OPER) to the SYSTEM account (look at Oracle7 for VAX OpenVMS installation guide page 2-25 "Setting Process Rights Identifiers and at the administrator's guide for OpenVMS in page c-13). For the shutdown i just start a command file from within the SYSHUTDWN.COM wich run the right ORAUSER_xxx.com and then runs SQLDBA to do the shutdown.

Hope this help you

Best regards   

Richard Armstrong <richard_at_juno.demon.co.uk> wrote:

>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

Yves Raisin                                     tel   : +41 21 341 81 11
Ofisa Informatique                              fax   : +41 21 341 84 57
Chemin des Charmettes 7                         e-mail: ra_at_ofisa.ch