Re: Shutting down Oracle under VMS

In article <80108BAN$VQxEwJS_at_juno.demon.co.uk>, Richard Armstrong <richard_at_juno.demon.co.uk> writes:
>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.
>--
>Richard Armstrong

        We let the SYSTEM account run a plain DCL script that sets process privileges CMKRNL,SYSNAM,SYSPRV (even though it already has them), then interactively runs each shutdown script for each database instance (we have 3 running). Each instance DCL shutdown script simply runs the ORAUSER.COM for that instance, then does a SHUTDOWN IMMEDIATE so it doesn't have to wait. We've never had a problem with this setup, and I've been using it since version 5 of Oracle. I still haven't made the leap to version 7, so I can't guarantee it works there, but I don't see why it wouldn't. Apparently, the CMKRNL allows the ORAUSER.COM to set the account up as a DBA. I don't have rights identifiers on the SYSTEM account, but it still seems to work.

        Good luck!

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Vicki Sadowski                  ** all current disclaimers apply **
sadowsvl_at_a1.spoc2.umc.dupont.com       ORACLE DBA V6.0.33
DuPont Co.                      ** MOM to Eric (10/12/89)        **
Seaford, Delaware               ** and  Rachel (6/20/92)         **
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^