Re: Shutting down Oracle under VMS
Date: 1996/03/19
Message-ID: <1996Mar19.135725.399_at_ns2>#1/1
In article <4i5j22$6q_at_dfw-ixnews3.ix.netcom.com>, mvergara_at_ix.netcom.com(Michael Vergara ) writes:
>In <1996Mar11.151024.2630_at_es.dupont.com> sadowsvl_at_wmvx.lvs.dupont.com (vicki
>sadowski) writes:
>>
>>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.
>(stuff snipped)
>
>Oracle implements the restrictions on the SYSTEM-level accounts in the
>STARTUP_EXCLUSIVE_<instance>.COM and SHUTDOWN_<instance>.COM files
>for each instance.
>
>I granted ORA_DBA to the SYSTEM user in AUTHORIZE, then commented out
>the
>restrictive sections of the STARTUP/SHUTDOWN...COM files, and viola!
>The SYSTEM user can now shutdown the Oracle database.
>
>This works on 7.0.13, 7.0.15, and 7.1.3 on VAX/VMS 5.5-2.
FYI: Oracle does not support v7.1 on VMS versions beneath 6.2 .
| Peter J.R. Vermaat | Dutch Department of Agriculture | Wageningen |
| p.j.r.vermaat_at_tfdl.agro.nl | http://gemini.tfdl.agro.nl:1024/~vermaat/ |
| Flagellant in Dreamland | ********************************************************************************Received on Tue Mar 19 1996 - 00:00:00 CET