Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: shutdown and close
> - I did a shutdown and there are users connected,
> I can't do another shutdown immediate.
> What is the good solution to stop the database ?
If you don't like a shutdown immediate you can also use a 'shutdown transactional' - Users will only be disconnected when their transactions end (rollback/commit) after which the DB closes down...
> - Is it possible to close a database when it is open ?
> alter database close does no work ...
Don't know which version you're working on but on 8i - when the DB is open -
you can do 'alter database close', 'alter database dismount', etc
However if you first issued a 'shutdown' you can't just do an 'alter
database close' because the database is performing a shutdown ...
"Thierry" <thierry.constant2_at_wanadoo.fr> wrote in message
news:3c03f6ac$0$210$626a54ce_at_news.free.fr...
> Hi,
>
> I have two questions:
>
> - I did a shutdown and there are users connected,
> I can't do another shutdown immediate.
> What is the good solution to stop the database ?
>
> - Is it possible to close a database when it is open ?
> alter database close does no work ...
>
>
> thanks ...
>
>
Received on Tue Nov 27 2001 - 14:41:27 CST