Re: Q: Shutdown Oracle 7.1 on Open VMS

From: David A. Owens <daveo_at_criticaldata.com>
Date: 1998/03/09
Message-ID: <35047394.4B34@criticaldata.com>#1/1

On VMS you can use (edit for your paths and SID names):

$ @DB_DSK1:[DB_RTH]orauser_RTH
$ @ora_rdbms:rdbmsuser.com
$ sqldba lmode=y

  spool ora_instance:shutdown_RTH.log
  set echo on
  connect internal
  shutdown immediate;
  exit;

$!Now shutdown listener
$ lsnrctrl stop
$ exit

The first two commands setup your logical names. The shutdown immediate closes any user sessions and rolls back any uncommitted transactions. If you used ORACLEINS to setup your DBs, then you can just edit the shutdown sql script and add the immediate option.

• Dave

Italo Bozzi wrote:
>
> We have Oracle7 Server Release 7.1.5.2.3 on OpenVMS Alpha 6.2-1H3 with
> TNSLSNR for VMS: Version 2.1.5.1.0.
>
> When we want to stop the database there're active connections via
> SQL*Net. With the stop command of the LSNRCTL the proccess still
> connected.
>
> How we can stop the SQL*Net connection and the database without doing an
> abort shutdown.
>
> Anyone have a script to do that? If yes please help us.
>
> Thanks,
>
> Italo Bozzi F.
>
> ---------------------------------------------------------------
>
> Name: vcard.vcf
> Part 1.2 Type: text/x-vcard
> Encoding: 7bit
> Description: Card for Italo Bozzi
Received on Mon Mar 09 1998 - 00:00:00 CST