alter database close/open, did it ever work ?
Date: 1996/04/02
Message-ID: <4js8d6$oto_at_cm1.umd.edu>#1/1
I can't remember if it worked in Oracle V6. In V7 it did not work for me (7.0.16 and 7.1.2). Is it normal or I did something wrong ?
]SQL*DBA: Release 7.0.16.6.1 - Production on Tue Apr 2 16:49:07 1996
Copyright (c) Oracle Corporation 1979, 1992. All rights reserved.
ORACLE7 Server Release 7.0.16.6.1 - Production With the procedural and distributed options PL/SQL Release 2.0.18.1.0 - Production
SQLDBA> connect internal
Connected.
SQLDBA> alter database close normal;
Statement processed.
SQLDBA> alter database open;
ORA-01531: a database already open by the instance
SQLDBA> alter database close;
ORA-01109: database not open
SQLDBA> alter database dismount;
Statement processed.
SQLDBA> alter database mount exclusive;
Statement processed.
SQLDBA> alter database open;
ORA-01531: a database already open by the instance
SQLDBA> shutdown
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQLDBA>
Lu, H.
Received on Tue Apr 02 1996 - 00:00:00 CEST