Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: why can I logon in restricted mode?
"Tanel Poder" <tanel@@peldik.com> wrote in
news:3e568f12_1_at_news.estpak.ee:
> Hi!
>
> I think such command as alter database open restrict doesnt exist (at
> least in 8i). Either user startup restrict which you can't in current
> situation, or enable restricted session right after open.
>
> Some people use to shut down their db listeners to prevent
> users/applications from logging on..
>
> Tanel.
>
>> "ALTER DABABASE OPEN" opens it in unrestricted mode, undoing whatever >> you did in the previous command. You want to say "ALTER DABABASE OPEN >> RESTRICT".
You're right. The correct command is "startup restrict". Received on Fri Feb 21 2003 - 14:46:44 CST