in Oracle 9.2.0
after start database , I used "alter databsse cloes",
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?

Thanks,

epeppanda

<epeppanda@yahoo.com.cn> a ¨¦crit dans le message de news: 1137553779.476727.287770@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