Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to use alter database close?

Re: How to use alter database close?

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Wed, 18 Jan 2006 07:18:48 +0100
Message-ID: <43cdddca$0$11893$626a14ce@news.free.fr>

<epeppanda_at_yahoo.com.cn> a ¨¦crit dans le message de news: 1137553779.476727.287770_at_o13g2000cwo.googlegroups.com...
| in Oracle 9.2.0
| after start database , I used "alter databsse cloes",

Don't use it, it's an internal statement.

| it shows "ORA-01094 ALTER DATABASE CLOSE in progress. Connections not
| permitted"
| but it hasn't any session except backgroud process.
| if I want to change status to nomount ,must I shutdown database first?

Yes

|
| Thanks,
|
| epeppanda
|

Regards
Michel Cadot Received on Wed Jan 18 2006 - 00:18:48 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US