I am trying to ALTER DATABASE CLOSE; on my learning database (not production) and I am getting the error:
"ORA-01093: ALTER DATABASE CLOSE only permitted with no sessions connected"
SELECT sid,serial#,username from v$session;
SID SERIAL# USERNAME
---------- ---------- ---------------------------
135 6 SYSMAN
137 102 SYSMAN
139 1274 SYSMAN
141 17 DBSNMP
142 107 SYS
143 185 SYSMAN
147 32 DBSNMP
152 12
159 3
160 3
SID SERIAL# USERNAME
---------- ---------- ---------------------------
161 153
162 38
164 1
165 1
166 1
167 1
168 1
169 1
170 1
I have tried killing the named sessions (only a database for learning, no production impact) only to either have them reappear or not being killed in the first place.
What am I missing? How can I clear existing sessions?
Oracle 10g, 10.1.0.4.0 on Windows2003 Server
Thanks, Brian