Re: Shutting down Oracle under VMS
Date: 1996/03/11
Message-ID: <1996Mar11.151024.2630_at_es.dupont.com>#1/1
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) ** ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^&)(*&)#%(^*) I KEEP HITTING THE ESCAPE KEY, BUT I'M STILL HERE! Received on Mon Mar 11 1996 - 00:00:00 CET