how to use " alter database close" in Oracle 7.x ?

From: Lijun Shi <eq418_at_freenet.carleton.ca>
Date: Sat, 8 Dec 2001 18:02:28 -0500
Message-ID: <9uu62u$33s$1@freenet9.carleton.ca>

hi , all

I use Oracle 7.x now( It switches quickly) can somebody tell me how to use " alter database close" to close database ( while not dismount):

what I do :
1.----
SVRMGR> select sid , serial# , status, username,server from v$session ;

SID        SERIAL#    STATUS   USERNAME                       SERVER
---------- ---------- -------- ------------------------------ ---------
         1          1 ACTIVE                                  DEDICATED
         2          1 ACTIVE                                  DEDICATED
         3          1 ACTIVE                                  DEDICATED
         4          1 ACTIVE                                  DEDICATED
         5          1 ACTIVE                                  DEDICATED
         6        229 ACTIVE                                  DEDICATED
         7        229 ACTIVE                                  DEDICATED
         8         15 ACTIVE   SYS                            DEDICATED

2.----
SVRMGR> alter system kill session '8,229';( as many as possble, I'm SYS)

3.----
SVRMGR> alter database close ;
alter database close
*
ORA-01093: ALTER DATABASE CLOSE only permitted with no sessions connected

4.----
I change into user " internal "
still can not close ?

5.---
why ????

thanks Received on Sat Dec 08 2001 - 17:02:28 CST